April 2011 - Posts

• Twenty Nine Days of Activity Monitoring (A Month of Activity Monitoring, Part 30 of 30)

  This post is part 30 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 Saturday, April 30, 2011 11:00 AM by Adam Machanic | 17 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Access for All! (A Month of Activity Monitoring, Part 29 of 30)

  This post is part 29 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 29, 2011 11:00 AM by Adam Machanic | 1 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Who is Active's Hidden Gems (A Month of Activity Monitoring, Part 28 of 30)

  This post is part 28 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 Thursday, April 28, 2011 11:00 AM by Adam Machanic | 3 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Who is Active v11.00 (A Month of Activity Monitoring, Part 27 of 30)

  This post is part 27 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 Wednesday, April 27, 2011 11:00 AM by Adam Machanic | 31 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Delta Force (A Month of Activity Monitoring, Part 26 of 30)

  This post is part 26 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 Tuesday, April 26, 2011 11:00 AM by Adam Machanic | 4 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Capturing the Output (A Month of Activity Monitoring, Part 25 of 30)

  This post is part 25 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 Monday, April 25, 2011 11:00 AM by Adam Machanic | 5 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

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

  This post is part 24 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 Sunday, April 24, 2011 11:00 AM by Adam Machanic | 4 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Leader of the Block (A Month of Activity Monitoring, Part 23 of 30)

  This post is part 23 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 Saturday, April 23, 2011 11:00 AM by Adam Machanic | 8 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• The Key to Your Locks (A Month of Activity Monitoring, Part 22 of 30)

  This post is part 22 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 22, 2011 11:00 AM by Adam Machanic | 3 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Analyzing Tempdb Contention (A Month of Activity Monitoring, Part 21 of 30)

  This post is part 21 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 Thursday, April 21, 2011 11:00 AM by Adam Machanic | 5 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• The Node Knows (A Month of Activity Monitoring, Part 20 of 30)

  This post is part 20 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 Wednesday, April 20, 2011 11:00 AM by Adam Machanic | 7 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Why Am I Blocked? (A Month of Activity Monitoring, Part 19 of 30)

  This post is part 19 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 Tuesday, April 19, 2011 11:00 AM by Adam Machanic | 7 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Getting More Information (A Month of Activity Monitoring, Part 18 of 30)

  This post is part 18 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 Monday, April 18, 2011 11:00 AM by Adam Machanic | 5 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Is This Normal? (A Month of Activity Monitoring, Part 17 of 30)

  This post is part 17 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 Sunday, April 17, 2011 11:00 AM by Adam Machanic | 8 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Seeing All of the Waits (A Month of Activity Monitoring, Part 16 of 30)

  This post is part 16 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 Saturday, April 16, 2011 11:00 AM by Adam Machanic | 2 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Seeing the Wait That Matters Most (A Month of Activity Monitoring, Part 15 of 30)

  This post is part 15 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 15, 2011 11:00 AM by Adam Machanic | 12 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Blocking, Blockers, and Other B Words (A Month of Activity Monitoring, Part 14 of 30)

  This post is part 14 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 Thursday, April 14, 2011 11:00 AM by Adam Machanic | 8 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• How Queries Are Processed (A Month of Activity Monitoring, Part 13 of 30)

  This post is part 13 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 Wednesday, April 13, 2011 11:00 AM by Adam Machanic | 10 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• The Almighty Transaction (A Month of Activity Monitoring, Part 12 of 30)

  This post is part 12 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 Tuesday, April 12, 2011 11:00 AM by Adam Machanic | 2 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• "Planning" for Success (A Month of Activity Monitoring, Part 11 of 30)

  This post is part 11 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 Monday, April 11, 2011 11:00 AM by Adam Machanic | 14 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Commands, Batches, and the Mysteries of Text (A Month of Activity Monitoring, Part 10 of 30)

  This post is part 10 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 Sunday, April 10, 2011 11:00 AM by Adam Machanic | 2 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Deciding What (Not) To See (A Month of Activity Monitoring, Part 9 of 30)

  This post is part 9 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 Saturday, April 09, 2011 11:00 AM by Adam Machanic | 5 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Active Request, Sleeping Session (A Month of Activity Monitoring, Part 8 of 30)

  This post is part 8 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 08, 2011 11:00 AM by Adam Machanic | 25 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Who is Active: Default Columns (A Month of Activity Monitoring, Part 7 of 30)

  This post is part 7 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 Thursday, April 07, 2011 11:00 AM by Adam Machanic | 4 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Who is Active: Options (A Month of Monitoring, Part 6 of 30)

  This post is part 6 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 Wednesday, April 06, 2011 11:00 AM by Adam Machanic | 10 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Less Data is More Data (A Month of Monitoring, Part 5 of 30)

  This post is part 5 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 Tuesday, April 05, 2011 11:00 AM by Adam Machanic | 10 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Installing Who is Active (A Month of Activity Monitoring, Part 4 of 30)

  This post is part 4 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 Monday, April 04, 2011 11:00 AM by Adam Machanic | 10 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

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

  This post is part 3 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 Sunday, April 03, 2011 11:00 AM by Adam Machanic | 4 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active

• Who is Active: Design Philosophy (A Month of Activity Monitoring, Part 2 of 30)

  This post is part 2 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 Saturday, April 02, 2011 11:00 AM by Adam Machanic | 7 Comments Filed under: activity monitoring, DMVs, month of monitoring, sp_whoisactive, 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: activity monitoring, DMVs, month of monitoring, sp_whoisactive, who is active