{"id":543,"date":"2010-12-21T13:03:00","date_gmt":"2010-12-21T13:03:00","guid":{"rendered":"\/blogs\/jonathan\/post\/An-XEvent-a-Day-(21-of-31)-The-Future-Tracking-Blocking-in-Denali.aspx"},"modified":"2017-04-13T12:18:30","modified_gmt":"2017-04-13T16:18:30","slug":"an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\/","title":{"rendered":"An XEvent a Day (21 of 31) – The Future – Tracking Blocking in Denali"},"content":{"rendered":"

One of my favorite features that was added to SQL Server 2005 has been the Blocked Process Report trace event which collects an XML report whenever a process is blocked inside of the database engine longer than the user configurable threshold.  I wrote an article about this feature on SQL Server Central  two years ago titled Using the Blocked Process Report in SQL Server 2005\/2008<\/a>.  One of the aspects of this feature is that it requires that you either have a SQL Trace running that captures the event, or you configure Event Notifications on the server to capture the event information in a Service Broker Queue, neither of which is overly difficult to accomplish.  In SQL Server Denali CTP1, there is a new Extended Event, sqlserver.blocked_process_report, that makes this even easier to use.  We can now create an Event Session that exists in our SQL Server and is waiting to be started to capture blocked process information as needed.  However, we still have to set the \u2018blocked process threshold\u2019 sp_configure option to set the threshold at which blocked process report information is generated by Database Engine, firing the Event in our Event Session.<\/p>\n

\n
CREATE EVENT SESSION <\/span>MonitorBlocking\r\nON SERVER\r\nADD EVENT <\/span>sqlserver.<\/span>blocked_process_report\r\nADD TARGET <\/span>package0.<\/span>ring_buffer(<\/span>SET <\/span>MAX_MEMORY=<\/span>2048)\r\n<\/span>WITH <\/span>(<\/span>MAX_DISPATCH_LATENCY = <\/span>5SECONDS)\r\n<\/span>GO\r\nALTER EVENT SESSION <\/span>MonitorBlocking\r\nON SERVER\r\nSTATE<\/span>=<\/span>START\r\nGO\r\nEXECUTE <\/span>sp_configure <\/span>'show advanced options'<\/span>, <\/span>1\r\nGO\r\nRECONFIGURE\r\nGO\r\nEXECUTE <\/span>sp_configure <\/span>'blocked process threshold'<\/span>, <\/span>15\r\nGO\r\nRECONFIGURE\r\nGO\r\nEXECUTE <\/span>sp_configure <\/span>'show advanced options'<\/span>, <\/span>0\r\nGO\r\nRECONFIGURE\r\nGO<\/span><\/pre>\n<\/blockquote>\n
To test this Event Session, we can open two New Query Windows in SSMS and connect them to our database engine.  Then in one window run the following code:<\/p>\n
\n
USE <\/span>[tempdb]\r\nGO\r\nCREATE TABLE <\/span>t1 (<\/span>RowID int identity primary key<\/span>)\r\n<\/span>GO\r\nBEGIN TRANSACTION\r\nINSERT INTO <\/span>t1 DEFAULT VALUES\r\nWAITFOR DELAY <\/span>'00:00:30'\r\n<\/span>COMMIT<\/span><\/pre>\n<\/blockquote>\n
Then in the other window run the following code:<\/p>\n
\n
USE <\/span>[tempdb]\r\nGO\r\nSELECT <\/span>* <\/span>FROM <\/span>t1<\/pre>\n<\/blockquote>\n
The first query will block the execution of the second query until it completes, generating our blocked process report in the ring_buffer Target for our Event Session.  To get the information from the ring_buffer target, we can run a quick XQuery to parse the Target (at this point in the series, you should be an XQuery pro):<\/p>\n
\n
-- Query the XML to get the Target Data\r\n<\/span>SELECT \r\n    <\/span>n.<\/span>value(<\/span>'(event\/@name)[1]'<\/span>, <\/span>'varchar(50)'<\/span>) <\/span>AS <\/span>event_name,\r\n    <\/span>n.<\/span>value(<\/span>'(event\/@package)[1]'<\/span>, <\/span>'varchar(50)'<\/span>) <\/span>AS <\/span>package_name,\r\n    <\/span>DATEADD<\/span>(<\/span>hh, \r\n            <\/span>DATEDIFF<\/span>(<\/span>hh, <\/span>GETUTCDATE<\/span>(), <\/span>CURRENT_TIMESTAMP<\/span>), \r\n            <\/span>n.<\/span>value(<\/span>'(event\/@timestamp)[1]'<\/span>, <\/span>'datetime2'<\/span>)) <\/span>AS <\/span>[timestamp],\r\n    <\/span>ISNULL<\/span>(<\/span>n.<\/span>value(<\/span>'(event\/data[@name="database_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>),\r\n            <\/span>n.<\/span>value(<\/span>'(event\/action[@name="database_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>)) <\/span>as <\/span>[database_id],\r\n    <\/span>n.<\/span>value(<\/span>'(event\/data[@name="database_name"]\/value)[1]'<\/span>, <\/span>'nvarchar(128)'<\/span>) <\/span>as <\/span>[database_name],\r\n    <\/span>n.<\/span>value(<\/span>'(event\/data[@name="object_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>as <\/span>[object_id],\r\n    <\/span>n.<\/span>value(<\/span>'(event\/data[@name="index_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>as <\/span>[index_id],\r\n    <\/span>CAST<\/span>(<\/span>n.<\/span>value(<\/span>'(event\/data[@name="duration"]\/value)[1]'<\/span>, <\/span>'bigint'<\/span>)\/<\/span>1000000.0 AS decimal<\/span>(<\/span>6,<\/span>2)) <\/span>as <\/span>[duration_seconds],\r\n    <\/span>n.<\/span>value(<\/span>'(event\/data[@name="lock_mode"]\/text)[1]'<\/span>, <\/span>'nvarchar(10)'<\/span>) <\/span>as <\/span>[file_handle],\r\n    <\/span>n.<\/span>value(<\/span>'(event\/data[@name="transaction_id"]\/value)[1]'<\/span>, <\/span>'bigint'<\/span>) <\/span>as <\/span>[transaction_id],\r\n    <\/span>n.<\/span>value(<\/span>'(event\/data[@name="resource_owner_type"]\/text)[1]'<\/span>, <\/span>'nvarchar(10)'<\/span>) <\/span>as <\/span>[resource_owner_type],\r\n    <\/span>CAST<\/span>(<\/span>n.<\/span>value(<\/span>'(event\/data[@name="blocked_process"]\/value)[1]'<\/span>, <\/span>'nvarchar(max)'<\/span>) <\/span>as XML<\/span>) <\/span>as <\/span>[blocked_process_report]\r\nFROM\r\n<\/span>(    <\/span>SELECT <\/span>td.<\/span>query(<\/span>'.'<\/span>) <\/span>as <\/span>n\r\n    FROM \r\n    <\/span>(\r\n        <\/span>SELECT <\/span>CAST<\/span>(<\/span>target_data AS XML<\/span>) <\/span>as <\/span>target_data\r\n        FROM <\/span>sys<\/span>.<\/span>dm_xe_sessions <\/span>AS <\/span>s    \r\n        JOIN <\/span>sys<\/span>.<\/span>dm_xe_session_targets <\/span>AS <\/span>t\r\n            ON <\/span>s.<\/span>address <\/span>= <\/span>t.<\/span>event_session_address\r\n        WHERE <\/span>s.<\/span>name = <\/span>'MonitorBlocking'\r\n          <\/span>AND <\/span>t.<\/span>target_name = <\/span>'ring_buffer'\r\n    <\/span>) <\/span>AS <\/span>sub\r\n    CROSS APPLY <\/span>target_data.<\/span>nodes(<\/span>'RingBufferTarget\/event'<\/span>) <\/span>AS <\/span>q(<\/span>td)\r\n) <\/span>as <\/span>tab\r\nGO<\/span><\/pre>\n<\/blockquote>\n
\n
\"image\"<\/a> <\/p>\n<\/blockquote>\n
The output of the Event in Extended Events contains some additional information to the blocked process report in XML format including the database_id, object_id, index_id, duration, lock_mode, transaction_id, and resource_owner_type for the blocking resource.  Clicking on the blocked process report XML will open it up in Management Studio as an XML document allowing detailed analysis of the blocking to be performed.<\/p>\n
\n
<<\/span>blocked-process-report<\/span>>\r\n  <<\/span>blocked-process<\/span>>\r\n    <<\/span>process <\/span>id<\/span>=<\/span>"process2eb8bda8<\/span>" taskpriority<\/span>=<\/span>"0<\/span>" logused<\/span>=<\/span>"0<\/span>" waitresource<\/span>=<\/span>"KEY: 2:2666130980878942208 (61a06abd401c)<\/span>" \r\n             waittime<\/span>=<\/span>"25480<\/span>" ownerId<\/span>=<\/span>"12748<\/span>" transactionname<\/span>=<\/span>"SELECT<\/span>" lasttranstarted<\/span>=<\/span>"2010-12-21T18:19:03.263<\/span>" \r\n             XDES<\/span>=<\/span>"0x2dfb9c10<\/span>" lockMode<\/span>=<\/span>"S<\/span>" schedulerid<\/span>=<\/span>"1<\/span>" kpid<\/span>=<\/span>"2484<\/span>" status<\/span>=<\/span>"suspended<\/span>" spid<\/span>=<\/span>"60<\/span>" sbid<\/span>=<\/span>"0<\/span>" ecid<\/span>=<\/span>"0<\/span>" \r\n             priority<\/span>=<\/span>"0<\/span>" trancount<\/span>=<\/span>"0<\/span>" lastbatchstarted<\/span>=<\/span>"2010-12-21T18:19:03.263<\/span>" \r\n             lastbatchcompleted<\/span>=<\/span>"2010-12-21T18:19:03.263<\/span>" clientapp<\/span>=<\/span>"Microsoft SQL Server Management Studio - Query<\/span>" \r\n             hostname<\/span>=<\/span>"WIN-5B9V8JPLP3H<\/span>" hostpid<\/span>=<\/span>"2708<\/span>" loginname<\/span>=<\/span>"WIN-5B9V8JPLP3H\\Administrator<\/span>" \r\n             isolationlevel<\/span>=<\/span>"read committed (2)<\/span>" xactid<\/span>=<\/span>"12748<\/span>" currentdb<\/span>=<\/span>"2<\/span>" lockTimeout<\/span>=<\/span>"4294967295<\/span>" \r\n             clientoption1<\/span>=<\/span>"671090784<\/span>" clientoption2<\/span>=<\/span>"390200<\/span>">\r\n      <<\/span>executionStack<\/span>>\r\n        <<\/span>frame <\/span>line<\/span>=<\/span>"1<\/span>" sqlhandle<\/span>=<\/span>"0x02000000d9de7b2f4f3a78e40f100bc02a84efbb9f01a84d<\/span>" \/>\r\n      <\/<\/span>executionStack<\/span>>\r\n      <<\/span>inputbuf<\/span>>\r\n<\/span>SELECT * FROM t1   <\/<\/span>inputbuf<\/span>>\r\n    <\/<\/span>process<\/span>>\r\n  <\/<\/span>blocked-process<\/span>>\r\n  <<\/span>blocking-process<\/span>>\r\n    <<\/span>process <\/span>status<\/span>=<\/span>"suspended<\/span>" waittime<\/span>=<\/span>"27430<\/span>" spid<\/span>=<\/span>"57<\/span>" sbid<\/span>=<\/span>"0<\/span>" ecid<\/span>=<\/span>"0<\/span>" priority<\/span>=<\/span>"0<\/span>" trancount<\/span>=<\/span>"1<\/span>" \r\n             lastbatchstarted<\/span>=<\/span>"2010-12-21T18:19:01.437<\/span>" lastbatchcompleted<\/span>=<\/span>"2010-12-21T18:13:25.637<\/span>" \r\n             clientapp<\/span>=<\/span>"Microsoft SQL Server Management Studio - Query<\/span>" hostname<\/span>=<\/span>"WIN-5B9V8JPLP3H<\/span>" \r\n             hostpid<\/span>=<\/span>"2708<\/span>" loginname<\/span>=<\/span>"WIN-5B9V8JPLP3H\\Administrator<\/span>" isolationlevel<\/span>=<\/span>"read committed (2)<\/span>" \r\n             xactid<\/span>=<\/span>"12733<\/span>" currentdb<\/span>=<\/span>"2<\/span>" lockTimeout<\/span>=<\/span>"4294967295<\/span>" clientoption1<\/span>=<\/span>"671090784<\/span>" clientoption2<\/span>=<\/span>"390200<\/span>">\r\n      <<\/span>executionStack<\/span>>\r\n        <<\/span>frame <\/span>line<\/span>=<\/span>"3<\/span>" stmtstart<\/span>=<\/span>"100<\/span>" stmtend<\/span>=<\/span>"150<\/span>" sqlhandle<\/span>=<\/span>"0x020000005a74b3030117e049389a93b2ce5bfb48e272f938<\/span>" \/>\r\n      <\/<\/span>executionStack<\/span>>\r\n      <<\/span>inputbuf<\/span>>\r\n<\/span>BEGIN TRANSACTION\r\nINSERT INTO t1 DEFAULT VALUES\r\nWAITFOR DELAY '00:00:30'\r\nCOMMIT   <\/<\/span>inputbuf<\/span>>\r\n    <\/<\/span>process<\/span>>\r\n  <\/<\/span>blocking-process<\/span>>\r\n<\/<\/span>blocked-process-report<\/span>><\/span><\/pre>\n<\/blockquote>\n
The output of the blocked process report in Extended Events is the same as the blocked process report from SQL Trace and Event Notifications.  This is only a new mechanism of collecting this information, and when Denali releases RTM, this will be an Event Session that I install on my Denali based servers as a part of my configuration scripts, having it ready to activate when necessary.<\/p>\n
Make sure that you turn off the generation of blocked process reports by changing the \u2018blocked process threshold\u2019 sp_configure option back to 0 (zero) whenever you are not actively looking for blocked processes.<\/p>\n","protected":false},"excerpt":{"rendered":"
One of my favorite features that was added to SQL Server 2005 has been the Blocked Process Report trace event which collects an XML report whenever a process is blocked inside of the database engine longer than the user configurable threshold.  I wrote an article about this feature on SQL Server Central  two years ago […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[40,45],"tags":[],"class_list":["post-543","post","type-post","status-publish","format-standard","hentry","category-sql-server-denali","category-xevent-a-day-series"],"yoast_head":"\nAn XEvent a Day (21 of 31) - The Future - Tracking Blocking in Denali - Jonathan Kehayias<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"An XEvent a Day (21 of 31) - The Future - Tracking Blocking in Denali - Jonathan Kehayias\" \/>\n<meta property=\"og:description\" content=\"One of my favorite features that was added to SQL Server 2005 has been the Blocked Process Report trace event which collects an XML report whenever a process is blocked inside of the database engine longer than the user configurable threshold.  I wrote an article about this feature on SQL Server Central  two years ago […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\/\" \/>\n<meta property=\"og:site_name\" content=\"Jonathan Kehayias\" \/>\n<meta property=\"article:published_time\" content=\"2010-12-21T13:03:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T16:18:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/d5bff98342cb\/41cf99c5\/image_thumb.png\" \/>\n<meta name=\"author\" content=\"Jonathan Kehayias\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonathan Kehayias\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\\\/\"},\"author\":{\"name\":\"Jonathan Kehayias\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"headline\":\"An XEvent a Day (21 of 31) – The Future – Tracking Blocking in Denali\",\"datePublished\":\"2010-12-21T13:03:00+00:00\",\"dateModified\":\"2017-04-13T16:18:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\\\/\"},\"wordCount\":473,\"commentCount\":5,\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.SQLskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/d5bff98342cb\\\/41cf99c5\\\/image_thumb.png\",\"articleSection\":[\"SQL Server Denali\",\"XEvent a Day Series\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\\\/\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\\\/\",\"name\":\"An XEvent a Day (21 of 31) - The Future - Tracking Blocking in Denali - Jonathan Kehayias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.SQLskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/d5bff98342cb\\\/41cf99c5\\\/image_thumb.png\",\"datePublished\":\"2010-12-21T13:03:00+00:00\",\"dateModified\":\"2017-04-13T16:18:30+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.SQLskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/d5bff98342cb\\\/41cf99c5\\\/image_thumb.png\",\"contentUrl\":\"https:\\\/\\\/www.SQLskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/d5bff98342cb\\\/41cf99c5\\\/image_thumb.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Denali\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/category\\\/sql-server-denali\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"An XEvent a Day (21 of 31) – The Future – Tracking Blocking in Denali\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\",\"name\":\"Jonathan Kehayias - The Rambling DBA\",\"description\":\"The Rambling DBA\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\",\"name\":\"Jonathan Kehayias\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"caption\":\"Jonathan Kehayias\"},\"sameAs\":[\"http:\\\/\\\/3.209.169.194\\\/blogs\\\/jonathan\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"An XEvent a Day (21 of 31) - The Future - Tracking Blocking in Denali - Jonathan Kehayias","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\/","og_locale":"en_US","og_type":"article","og_title":"An XEvent a Day (21 of 31) - The Future - Tracking Blocking in Denali - Jonathan Kehayias","og_description":"One of my favorite features that was added to SQL Server 2005 has been the Blocked Process Report trace event which collects an XML report whenever a process is blocked inside of the database engine longer than the user configurable threshold.  I wrote an article about this feature on SQL Server Central  two years ago […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\/","og_site_name":"Jonathan Kehayias","article_published_time":"2010-12-21T13:03:00+00:00","article_modified_time":"2017-04-13T16:18:30+00:00","og_image":[{"url":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/d5bff98342cb\/41cf99c5\/image_thumb.png","type":"","width":"","height":""}],"author":"Jonathan Kehayias","twitter_misc":{"Written by":"Jonathan Kehayias","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\/#article","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\/"},"author":{"name":"Jonathan Kehayias","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"headline":"An XEvent a Day (21 of 31) – The Future – Tracking Blocking in Denali","datePublished":"2010-12-21T13:03:00+00:00","dateModified":"2017-04-13T16:18:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\/"},"wordCount":473,"commentCount":5,"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\/#primaryimage"},"thumbnailUrl":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/d5bff98342cb\/41cf99c5\/image_thumb.png","articleSection":["SQL Server Denali","XEvent a Day Series"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\/","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\/","name":"An XEvent a Day (21 of 31) - The Future - Tracking Blocking in Denali - Jonathan Kehayias","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\/#primaryimage"},"thumbnailUrl":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/d5bff98342cb\/41cf99c5\/image_thumb.png","datePublished":"2010-12-21T13:03:00+00:00","dateModified":"2017-04-13T16:18:30+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\/#primaryimage","url":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/d5bff98342cb\/41cf99c5\/image_thumb.png","contentUrl":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/d5bff98342cb\/41cf99c5\/image_thumb.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/"},{"@type":"ListItem","position":2,"name":"SQL Server Denali","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/category\/sql-server-denali\/"},{"@type":"ListItem","position":3,"name":"An XEvent a Day (21 of 31) – The Future – Tracking Blocking in Denali"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/","name":"Jonathan Kehayias - The Rambling DBA","description":"The Rambling DBA","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c","name":"Jonathan Kehayias","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","caption":"Jonathan Kehayias"},"sameAs":["http:\/\/3.209.169.194\/blogs\/jonathan"]}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/543","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/comments?post=543"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/543\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/media?parent=543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/categories?post=543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/tags?post=543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}