New Release of SP_WHOISACTIVE

RSS
I profiled Adam Machanic's (blog | twitter) excellent stored procedure, SP_WHOISACTIVE, back in August of 2010.

Adam has been diligent about maintaining the tool and adding new features.  The latest release can be found here - http://sqlblog.com/files/folders/beta/entry35046.aspx

Some new features in this release (and I quote):

Who is Active v10.99

  • CPU deltas can now use real-time thread-based metrics for more accurate data (use both @delta_interval and @get_task_info = 2)
  • command_type information added to [additional_info] column for active requests
  • Query plans that are not able to be rendered due to XML data type limitations will now be returned in an encapsulated text form
  • Fixed bug where system processes were sometimes reporting start times in the future
  • Fixed bug where @get_locks sometimes failed with a constraint error
Be sure to put this in your tool kit!

Enjoy!

-Kev

 More content at http://KevinEKline.com  

Please or Register to post comments.

What's Tool Time Blog?

SQL Server tools and tips from Kevin Kline.

Blog Archive

Sponsored Introduction Continue on to (or wait seconds) ×