[sims] Identify users running large reports

[nLinked]

Sometimes SIMS .net usage becomes very high, with CPU spikes on the server. This normally happens when a user is running a large report. It then sometimes (rarely) causes SIMS .net to slow down or crash for other users. Is there any way to check, in these occasions, which user is running a large report in realtime? Thanks.

[localzuk]

If you have SQL Server Management Studio installed, you can log in as an administrator and use the Activity Monitor in it to watch what's going on. Ongoing transactions show the user doing them.

[nLinked]

Thank you!