Checking SQL Server current process

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

Published by Aryan Nava

Founder of "BlockchainMind", CTO for two Blockchain startup during 2018, Cloud/DevOps Consultant and Blockchain Trainer

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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: