Browse by Tags

• 24 hours of PASS
• 24hop
• activity
• activity monitoring
• administration
• blocking
• DMFs
• DMOs
• dynamic management
• exec
• insert
• monitoring
• month of monitoring
• PASS
• Performance
• performance monitoring
• Scripts
• sp_whoisactive
• transactions
• who is active

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

  This post is part 1 of a 30-part series about the Who is Active stored procedure. A new post will run each day during the month of April, 2011. After April all of these posts will be edited and combined into a single document to become the basis of the Read More... Posted Friday, April 01, 2011 11:00 AM by Adam Machanic | 9 Comments Filed under: DMVs, who is active, sp_whoisactive, activity monitoring, month of monitoring

• Who is Active? v10.00: DMV Monitoring Made Easy

  Today I am happy to release the newest official build of my Who is Active procedure: v10.00 . For those of you who haven't been following along, here are some quick facts on Who is Active: Who is Active is a DMV-based monitoring stored procedure that Read More... Posted Thursday, October 21, 2010 3:33 PM by Adam Machanic | 60 Comments Filed under: DMVs, who is active, sp_whoisactive, performance monitoring

• Smashing a DMV Myth: session_id > 50 == User Process

  Ever since I started working with SQL Server, I've been seeing advice to filter system views based on session identifiers, in order to return only user processes. The general advice is to look for session IDs (or SPIDs) greater than 50. And this seems Read More... Posted Wednesday, June 23, 2010 12:26 PM by Adam Machanic | 17 Comments Filed under: DMVs

• 24 Hours of PASS: 15 Powerful Dynamic Management Objects - Deck and Demos

  Thank you to everyone who attended today's 24 Hours of PASS webcast on Dynamic Management Objects! I was shocked, awed, and somewhat scared when I saw the attendee number peak at over 800. I really appreciate your taking time out of your day to listen Read More... Posted Wednesday, May 19, 2010 3:57 PM by Adam Machanic | 10 Comments Filed under: DMVs, PASS, 24 hours of PASS, DMFs, 24hop, DMOs, dynamic management Attachment(s): Machanic_24HOP_201005_DMOs.zip

• A Warning to Those Using sys.dm_exec_query_stats

  The sys.dm_exec_query_stats view is one of my favorite DMVs. It has replaced a large chunk of what I used to use SQL Trace for--pulling metrics about what queries are running and how often--and it makes this kind of data collection painless and automatic. Read More... Posted Thursday, April 22, 2010 11:15 PM by Adam Machanic | 10 Comments Filed under: Performance, DMVs, monitoring

• 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: Performance, Scripts, DMVs, who is active, monitoring

• 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: Scripts, DMVs, who is active, monitoring Attachment(s): who_is_active_v8_82.zip

• The Hidden Costs of INSERT EXEC

  INSERT and EXEC: relational brothers in arms, helping you get your data and then put it somewhere. But like all brothers, their relationship has its ups and downs and sometimes you need to look just below the surface to see the real issues. In this post Read More... Posted Thursday, June 25, 2009 5:19 PM by Adam Machanic | 17 Comments Filed under: Performance, DMVs, insert, exec

• 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: Scripts, DMVs, who is active, monitoring 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: Scripts, DMVs, who is active, monitoring 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: Performance, Scripts, DMVs, blocking, who is active, monitoring, activity Attachment(s): who_is_active_v7_22.zip

• A Gift of Script for 2008: Who's Active, What Are They Doing, and Who is Blocked?

  As with all of the blog posts I keep meaning to write -- I keep a list and given the infrequency with which I've been posting lately, it's getting quite large -- this script has been on the queue for quite some time. So here I find myself with a spare Read More... Posted Monday, December 31, 2007 6:32 PM by Adam Machanic | 16 Comments Filed under: Scripts, DMVs, administration