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.

Who is Active: The License (A Month of Activity Monitoring, Part 3 of 30)


Published Sunday, April 3, 2011 11:00 AM by Adam Machanic



Antony said:

I don't think anyone could complain at these very generous terms, Adam!

I know you've put hundreds of hours of work into it, and in doing so you've saved those of use that use it many times that - so on behalf of us all, thank you for your hard work.

April 3, 2011 12:24 PM

Darcy said:

I'm very new to dmv's and thankful for the information in your posts.  Very helpful.  My crack at the homework is below:

Columns that will be updated at the end:

cpu_time, logical_reads, reads, and writes

Columns that may change and revert to their original value:

status, context_info, textsize, language, date_format, ansi_defaults, ansi_warnings, ansi_padding, ansi_nulls, concat_null_yields_null, transaction_iosolation_level, lock_timeout, deadlock_priority, row_count, prev_error

April 4, 2011 2:56 PM

Adam Machanic said:

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

April 20, 2011 10:42 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:45 AM

Mike said:

quick one.

Adam, I was thinking about a Udemy course on how to use sp_whoisactive.

Is that ok or outside what's allowable.


August 26, 2014 1:57 PM

Adam Machanic said:


I'd rather you not. I'm already working on something along those lines.



August 27, 2014 10:16 AM

Mike West said:

Will do Adam.

Let me know when you course is ready please!!!

Again, thanks for sp_whoisactive.

By the way, Atlanta is looking for your return. Any time soon?

August 27, 2014 10:41 AM

Muhammad Asam said:


Are you preparing courses for PluralSight or UDemy? It will be really helpful indeed.

Thanks Mike West for giving this reminder and pushing things in right direction for everyone.

Thanks and Cheers.

October 3, 2015 1:21 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