Adam Machanic : DMVs, month of monitoringhttp://www2.sqlblog.com/blogs/adam_machanic/archive/tags/DMVs/month+of+monitoring/default.aspxTags: DMVs, month of monitoringenCommunityServer 2.1 SP2 (Build: 61129.1)Twenty Nine Days of Activity Monitoring (A Month of Activity Monitoring, Part 30 of 30)http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/30/twenty-nine-days-of-activity-monitoring-a-month-of-activity-monitoring-part-30-of-30.aspxSat, 30 Apr 2011 14:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:35301Adam Machanic26http://www2.sqlblog.com/blogs/adam_machanic/comments/35301.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=35301This 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...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/30/twenty-nine-days-of-activity-monitoring-a-month-of-activity-monitoring-part-30-of-30.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=35301" width="1" height="1">DMVswho is activesp_whoisactiveactivity monitoringmonth of monitoringAccess for All! (A Month of Activity Monitoring, Part 29 of 30)http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/29/access-for-all-a-month-of-activity-monitoring-part-29-of-30.aspxFri, 29 Apr 2011 14:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:35300Adam Machanic1http://www2.sqlblog.com/blogs/adam_machanic/comments/35300.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=35300This 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...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/29/access-for-all-a-month-of-activity-monitoring-part-29-of-30.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=35300" width="1" height="1">DMVswho is activesp_whoisactiveactivity monitoringmonth of monitoringWho is Active's Hidden Gems (A Month of Activity Monitoring, Part 28 of 30)http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/28/who-is-active-s-hidden-gems-a-month-of-activity-monitoring-part-28-of-30.aspxThu, 28 Apr 2011 14:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:35114Adam Machanic2http://www2.sqlblog.com/blogs/adam_machanic/comments/35114.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=35114This 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...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/28/who-is-active-s-hidden-gems-a-month-of-activity-monitoring-part-28-of-30.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=35114" width="1" height="1">DMVswho is activesp_whoisactiveactivity monitoringmonth of monitoringWho is Active v11.00 (A Month of Activity Monitoring, Part 27 of 30)http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/27/who-is-active-v11-00-a-month-of-activity-monitoring-part-27-of-30.aspxWed, 27 Apr 2011 14:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:35113Adam Machanic42http://www2.sqlblog.com/blogs/adam_machanic/comments/35113.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=35113This 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...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/27/who-is-active-v11-00-a-month-of-activity-monitoring-part-27-of-30.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=35113" width="1" height="1">DMVswho is activesp_whoisactiveactivity monitoringmonth of monitoringDelta Force (A Month of Activity Monitoring, Part 26 of 30)http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/26/delta-force-a-month-of-activity-monitoring-part-26-of-30.aspxTue, 26 Apr 2011 14:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:35112Adam Machanic4http://www2.sqlblog.com/blogs/adam_machanic/comments/35112.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=35112This 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...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/26/delta-force-a-month-of-activity-monitoring-part-26-of-30.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=35112" width="1" height="1">DMVswho is activesp_whoisactiveactivity monitoringmonth of monitoringCapturing the Output (A Month of Activity Monitoring, Part 25 of 30)http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/25/capturing-the-output-a-month-of-activity-monitoring-part-25-of-30.aspxMon, 25 Apr 2011 14:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:35111Adam Machanic9http://www2.sqlblog.com/blogs/adam_machanic/comments/35111.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=35111This 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...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/25/capturing-the-output-a-month-of-activity-monitoring-part-25-of-30.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=35111" width="1" height="1">DMVswho is activesp_whoisactiveactivity monitoringmonth of monitoringThe Output of Your Dreams (A Month of Activity Monitoring, Part 24 of 30)http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/24/the-output-of-your-dreams-a-month-of-activity-monitoring-part-24-of-30.aspxSun, 24 Apr 2011 14:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:35110Adam Machanic6http://www2.sqlblog.com/blogs/adam_machanic/comments/35110.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=35110This 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...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/24/the-output-of-your-dreams-a-month-of-activity-monitoring-part-24-of-30.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=35110" width="1" height="1">DMVswho is activesp_whoisactiveactivity monitoringmonth of monitoringLeader of the Block (A Month of Activity Monitoring, Part 23 of 30)http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/23/leader-of-the-block-a-month-of-activity-monitoring-part-23-of-30.aspxSat, 23 Apr 2011 14:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:35109Adam Machanic6http://www2.sqlblog.com/blogs/adam_machanic/comments/35109.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=35109This 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...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/23/leader-of-the-block-a-month-of-activity-monitoring-part-23-of-30.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=35109" width="1" height="1">DMVswho is activesp_whoisactiveactivity monitoringmonth of monitoringThe Key to Your Locks (A Month of Activity Monitoring, Part 22 of 30)http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/22/the-key-to-your-locks-a-month-of-activity-monitoring-part-22-of-30.aspxFri, 22 Apr 2011 14:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:34996Adam Machanic5http://www2.sqlblog.com/blogs/adam_machanic/comments/34996.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=34996This 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...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/22/the-key-to-your-locks-a-month-of-activity-monitoring-part-22-of-30.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=34996" width="1" height="1">DMVswho is activesp_whoisactiveactivity monitoringmonth of monitoringAnalyzing Tempdb Contention (A Month of Activity Monitoring, Part 21 of 30)http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/21/analyzing-tempdb-contention-a-month-of-activity-monitoring-part-21-of-30.aspxThu, 21 Apr 2011 14:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:34995Adam Machanic8http://www2.sqlblog.com/blogs/adam_machanic/comments/34995.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=34995This 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...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/21/analyzing-tempdb-contention-a-month-of-activity-monitoring-part-21-of-30.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=34995" width="1" height="1">DMVswho is activesp_whoisactiveactivity monitoringmonth of monitoringThe Node Knows (A Month of Activity Monitoring, Part 20 of 30)http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/20/the-node-knows-a-month-of-activity-monitoring-part-20-of-30.aspxWed, 20 Apr 2011 14:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:34994Adam Machanic7http://www2.sqlblog.com/blogs/adam_machanic/comments/34994.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=34994This 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...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/20/the-node-knows-a-month-of-activity-monitoring-part-20-of-30.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=34994" width="1" height="1">DMVswho is activesp_whoisactiveactivity monitoringmonth of monitoringWhy Am I Blocked? (A Month of Activity Monitoring, Part 19 of 30)http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/19/why-am-i-blocked-a-month-of-activity-monitoring-part-19-of-30.aspxTue, 19 Apr 2011 14:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:34993Adam Machanic8http://www2.sqlblog.com/blogs/adam_machanic/comments/34993.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=34993This 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...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/19/why-am-i-blocked-a-month-of-activity-monitoring-part-19-of-30.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=34993" width="1" height="1">DMVswho is activesp_whoisactiveactivity monitoringmonth of monitoringGetting More Information (A Month of Activity Monitoring, Part 18 of 30)http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/18/getting-more-information-a-month-of-activity-monitoring-part-18-of-30.aspxMon, 18 Apr 2011 14:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:34960Adam Machanic5http://www2.sqlblog.com/blogs/adam_machanic/comments/34960.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=34960This 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...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/18/getting-more-information-a-month-of-activity-monitoring-part-18-of-30.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=34960" width="1" height="1">DMVswho is activesp_whoisactiveactivity monitoringmonth of monitoringIs This Normal? (A Month of Activity Monitoring, Part 17 of 30)http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/17/is-this-normal-a-month-of-activity-monitoring-part-17-of-30.aspxSun, 17 Apr 2011 14:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:34941Adam Machanic10http://www2.sqlblog.com/blogs/adam_machanic/comments/34941.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=34941This 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...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/17/is-this-normal-a-month-of-activity-monitoring-part-17-of-30.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=34941" width="1" height="1">DMVswho is activesp_whoisactiveactivity monitoringmonth of monitoringSeeing All of the Waits (A Month of Activity Monitoring, Part 16 of 30)http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/16/seeing-all-of-the-waits-a-month-of-activity-monitoring-part-16-of-30.aspxSat, 16 Apr 2011 14:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:34781Adam Machanic2http://www2.sqlblog.com/blogs/adam_machanic/comments/34781.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=34781This 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...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2011/04/16/seeing-all-of-the-waits-a-month-of-activity-monitoring-part-16-of-30.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=34781" width="1" height="1">DMVswho is activesp_whoisactiveactivity monitoringmonth of monitoring