Browse by Tags

• DMVs
• sp_whoisactive

• 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 | 21 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 | 2 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 | 29 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 | 9 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 | 6 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 | 2 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 | 6 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 | 8 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 | 9 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