I am currently monitoring the expensive queries from the activity monitor for SQL server.
How do I see who is running the different queries?
activity-monitorsql serversql-server-2008
I am currently monitoring the expensive queries from the activity monitor for SQL server.
How do I see who is running the different queries?
Best Answer
A much better way to monitor is using sp_whoisactive - from Adam Machanic. I use sp_whoisactive with below parameters :
You can even log the output to a physical table for future analysis. It allows you to capture query plan, blocking, etc as well.