Browse by Tags

• 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 | 5 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 | 27 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 | 9 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 | 6 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