What I Use – sp_WhoIsActive

Who is Active? Not I! 3 blog posts in 2014, all published in the beginning of the year. However in 2015 I’ll be looking to change all that. Back to SQL!

Who is Active, an awesome stored procedure I use on a daily basis to see what is going on, at that very moment, on SQL Servers I monitor. At the moment I only really use it to view percentage completed (for certain queries), blocked queries, query wait types and resource heavy queries. It is far more powerful though with filters, output columns and delta mode, just to name a few features. And it also provides loads of information you can use at your will.

At the time of writing this post, the latest version is v11.11 and you can download it from here. Do it, and add it to your arsenal! Happy New Year!


Leave a Reply

Your email address will not be published. Required fields are marked *