Checking SQL Server current process

October 12, 2011 — Leave a comment

What’s currently going on on the SQL Server, who is executing which query or fetches a few thousands of rows and slowing down the server with it?
With this Transact-SQL script you can list all processes with their SQL statements.

Additional you get the cummulative values of IO / CPU usage and the row count of the last statement execution.

Script Source:

End Results in SQL Server

Checking SQL Server Current Status

No Comments

Be the first to start the conversation!

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s