About Me - Who is DR DBA?

Hello. My name is Rudy Panigas and I am a Production Senior Microsoft SQL Server Database Administrator (DBA) with over 14 years of experience. Have published articles with SQL Central, am a leader for the my local PASS chapter in Toronto (TORPASS) and love to automate anything SQL including disaster recovery. I created this blog to share my views, knowledge and to discuss Microsoft SQL server in order to help out others in this field. Please test these scripts before using. I do not warranty and do not take any responsibility for it, its misuse or output it creates. You can reach me at this email address: sqlsurgeon@outlook.com

Thursday, August 8, 2013

Who is Active on the SQL Server

Hello everyone,

It's been a while but I'm back.

Today I would like to share a link to Adam Machanic's blog page that has a very cool SQL script.

The script is called sp_WhoIsActive and what it shows is everything you wanted to know about who is doing what on your SQL Server. I highly recommend it and you should try it for yourself, on a development server. 

Look at the link here: http://sqlblog.com/files/folders/release/tags/who+is+active/default.aspx

Enjoy!

Rudy

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.