Browse by Tags

• activity
• blocking
• Performance

• Who is Active? v9.57: Fast, Comprehensive DMV Collection - What's Really Happening on Your Server?

  UPDATE, April 28 2011: Who is Active v9.57 is outdated. Please use v11.00 instead. Happy December, SQLblog readers! My gift to you, just in time for the holidays: The newest "official" release of your favorite SQL Server activity monitoring stored procedure Read More... Posted Thursday, December 03, 2009 3:59 PM by Adam Machanic | 24 Comments Filed under: DMVs, monitoring, Performance, Scripts, who is active

• Who is Active? v8.82 - Harder, Better, Faster, Stronger

  I've had a lot of great feedback since my last "official" Who is Active? release-- v8.40, back in March --and since then I've made 42 distinct changes, bringing us all the way to v8.82. My versioning scheme is quite simple: one change, one increment, Read More... Posted Thursday, August 20, 2009 12:03 PM by Adam Machanic | 13 Comments Filed under: DMVs, monitoring, Scripts, who is active Attachment(s): who_is_active_v8_82.zip

• Who is Active? v8.40 - Now With Delta Power!

  NOTE: v8.40 is outdated at this time. Please try v9.57, which you can find here . It has been only a month and a half since I posted the last version of Who is Active? ( v7.30 ), but in that time I've made a huge number of changes, fixes, and enhancements. Read More... Posted Monday, March 30, 2009 1:41 PM by Adam Machanic | 26 Comments Filed under: DMVs, monitoring, Scripts, who is active Attachment(s): who_is_active_v8_40.zip

• Who is Active? v7.30

  Who is Active? is a comprehensive DMV-based monitoring script, designed to tell you at a glance what processes are active on your SQL Server and what they're up to. It has a number of optional features so that you can get results quickly, or monitor deeply, Read More... Posted Wednesday, February 18, 2009 11:34 AM by Adam Machanic | 5 Comments Filed under: DMVs, monitoring, Scripts, who is active Attachment(s): who_is_active_v7_30.zip

• A Gift of Script for 2009: Who is Active, Redux

  Last year on December 31 I posted part of a larger monitoring script that I had been working on for a few months . I received lots of great feedback on the little script in both the comments and from people I was working with, and over the course of the Read More... Posted Wednesday, December 31, 2008 10:49 AM by Adam Machanic | 9 Comments Filed under: activity, blocking, DMVs, monitoring, Performance, Scripts, who is active Attachment(s): who_is_active_v7_22.zip