Finding out who is active with your MS SQL Server Database

Hello World,I was trying to research how to quickly (and easily :-)) find out what is currently active on a particular database instance and landed on this excellent post by Brent Ozar. He describes in a short, crisp video a tool called sp_whoIsActive created by Adam Machanic. You need to run the SQL script on your master database and once done, fire it from the context of the database you are interested in:

EXEC master..sp_WhoIsActive

You would get this nice result window:

 

 

 

Happy Coding!

Advertisements
Posted in MSSQL

Leave a Reply

Fill in your details below or click an icon to log in:

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

  • Comic for July 25, 2017
    Dilbert readers - Please visit Dilbert.com to read this feature. Due to changes with our feeds, we are now making this RSS feed a link to Dilbert.com.
%d bloggers like this: