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: http://gallery.technet.microsoft.com/scriptcenter/Current-processes-and-d9b4c8d9

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:

WordPress.com Logo

You are commenting using your WordPress.com 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