SQL USER PROCESSES (TOP 10 BY CPU) - drill down
Server hosts/matrix
Drill down
Some select's come up in mine, but I'm not able to drill down to find more details like the SQL itself
4
votes
Patrick
shared this idea
-
Don Ferguson commented
This would be very useful. It seems that active queries are not captured in the Server Overview page until they are complete. Adding detail such as query and execution plan of active long running queries during any time slice it's running (similar to what sp_whoisactive @get_plans=1 captures, http://whoisactive.com/) on this page would improve this tool dramatically.