THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Adam Machanic

Adam Machanic, Boston-based SQL Server developer, shares his experiences with programming, monitoring, and performance tuning SQL Server. And the occasional battle with the query optimizer.

A Brief History of Monitoring (A Month of Activity Monitoring, Part 1 of 30)


Published Friday, April 1, 2011 11:00 AM by Adam Machanic



Sean Shanny said:

As always informative and entertaining.  I use your script a gazillion times a day and cannot imagine life without it.

April 1, 2011 12:30 PM

DaniSQL said:

Thanks for your work. I use your script all the time but i know it can do a lot more and I cant wait to read all the series...I even asked you on twitter for help months ago regarding documentation.

April 1, 2011 1:22 PM

Ken Trock said:

I have the script and am looking forward to this series.

April 1, 2011 2:44 PM

Adam Machanic said:

This post is part 2 of a 30-part series about the Who is Active stored procedure. A new post will run

April 3, 2011 12:58 PM

aspiringgeek said:

Beautiful!  Can't wait for more!

April 3, 2011 3:38 PM

fase hf said:

well, you are trying

April 16, 2011 2:03 PM

monitor said:

try some more

April 16, 2011 2:05 PM

Adam Machanic said:

This post is part 8 of a 30-part series about the Who is Active stored procedure. A new post will run

April 20, 2011 10:40 AM

Adam Machanic said:

This post is part 30 of a 30-part series about the Who is Active stored procedure. A new post will run

April 30, 2011 11:44 AM

Richard said:

Was this 30-part series ever consolidated into documentation?

July 27, 2013 6:03 AM

Adam Machanic said:

@Richard: Unfortunately, no. It's still on my potential to do list but I decided to focus my energy on something else in the meantime.

July 27, 2013 4:07 PM

Eva Arriaga said:

Hi Adam,

New to the SQL world.. learning SQL 2012.. I want to read all of the A Brief History of Monitoring, and to use your Script once I understand it..

I read part 1 here, but cannot find the rest.

Where is it?



January 22, 2014 2:00 PM

Eva Arriaga said:

I found it.. thanks!  Does your script works for SQL 2012?

January 22, 2014 2:11 PM

Adam Machanic said:


Yes, it works with all current versions of SQL Server 2005 and up.


January 22, 2014 8:56 PM

Kumar Duvvuri said:

Does the Script works with SQL Server 2014


May 7, 2014 1:05 PM

Mike said:

This single best free tool on the market for SQL Server DBAs. Thanks Adam. I use it every single day.

August 26, 2014 1:49 PM
New Comments to this post are disabled

About Adam Machanic

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "SQL Server 2008 Internals" (Microsoft Press, 2009) and "Expert SQL Server 2005 Development" (Apress, 2007). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.

This Blog


Privacy Statement