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.

The Output of Your Dreams (A Month of Activity Monitoring, Part 24 of 30)


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



Adam Machanic said:

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

April 27, 2011 12: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

Jeremy Marx (@jmarx) said:


On 11.00, if I use @format_output = {0|2}, the [dd hh:mm:ss.mss] and [dd hh:mm:ss.mss (avg)] columns won't show.


EXEC master..[sp_WhoIsActive] @format_output = 0 -- columns don't show up

EXEC master..[sp_WhoIsActive] @format_output = 1 -- columns show up

EXEC master..[sp_WhoIsActive] @format_output = 2 -- columns don't show up

Noticed on 9.0.5000 and also tested on 10.50.1600.

June 3, 2011 12:33 PM

Adam Machanic said:

Hi Jeremy,

Thanks for the report. It's not supposed to show up for @format_output = 0, but it should for @format_output = 2.


June 3, 2011 2:06 PM

Chris said:


This wonderfull procedure just miss ONE thing to be absolutely perfect and an overall killer: The name of the function / procedure.

If it would be possible to get this information in a new column 'process_name' just before sql_ext, il would be very greeeeaaaaaat !!!

April 11, 2014 6:22 AM

Adam Machanic said:

Hi Chris,

Unfortunately that's not possible. But you can figure it out yourself by doing: @get_full_inner_text = 1


April 11, 2014 11:43 AM

Julio Nobre said:

Hi Adam

I just would like to let you know that being a longtime database engine lover, I think you have done a great work colleting and simplifying sp_WhoIsActive stored procedure.

Congratulations for an excellent job!!!

Thanks a lot for sharing it


February 16, 2016 6:59 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