Is it possible to configure Spotlight such that an alert is flagged, if any single session performs more than xx,xxx logical I/O per second?
(or some other metric)
Spotlight does not specifically identify particular sessions that are causing performance issues, it just alerts you when performance issues arise, then you can drill down to try to identify the specific cause of the performance bottleneck.
One thing to keep in mind is that Spotlight tries to limit itself to about 3% of your system resources on the server in collecting statistics. If it were to collect such detailed information as session activity, it would require much more of your system resources.
Spotlight is really intended to be used only when you suspect performance bottlenecks, it is not a 24-hour monitoring tool as such.