{"id":1088,"date":"2018-01-31T10:51:43","date_gmt":"2018-01-31T09:51:43","guid":{"rendered":"https:\/\/dbafox.com\/?p=1088"},"modified":"2018-02-08T11:44:57","modified_gmt":"2018-02-08T10:44:57","slug":"sql-server-deadlock-detection","status":"publish","type":"post","link":"https:\/\/dbafox.com\/?p=1088","title":{"rendered":"SQL Server – Deadlock History with Extended Events"},"content":{"rendered":"

Using SSMS to Display Deadlock History with Extended Events<\/h1>\n

To use Extended Events to display deadlock history, the following method can be used.
\nIn the Object Explorer, Open Management folder\n<\/p>\n

\"Extended

Extended Events to display deadlock history<\/p><\/div>\n

\nOpen Extended Events\/Sessions\/system_health<\/p>\n

Right-click on package0.eventfile and select “View Target Data”. This will display a list of events.<\/p>\n

To apply a filter, for example “deadlock”, select Filters toolbar button (may be hidden in a drop-down list)\n<\/p>\n

\"\"<\/p>\n

Set the filter(s)<\/p>\n

\"\"<\/p>\n

The results are displayed.<\/p>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

Using SSMS to Display Deadlock History with Extended Events To use Extended Events to display deadlock history, the following method can be used. In the Object Explorer, Open Management folder Open Extended Events\/Sessions\/system_health Right-click on package0.eventfile and select “View Target … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pgc_sgb_lightbox_settings":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[24],"tags":[56,57],"class_list":["post-1088","post","type-post","status-publish","format-standard","hentry","category-ms-sql-server","tag-deadlock","tag-extended-event"],"yoast_head":"\nSQL Server - Deadlock History with Extended Events - dbafox<\/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:\/\/dbafox.com\/?p=1088\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server - Deadlock History with Extended Events - dbafox\" \/>\n<meta property=\"og:description\" content=\"Using SSMS to Display Deadlock History with Extended Events To use Extended Events to display deadlock history, the following method can be used. In the Object Explorer, Open Management folder Open Extended Events\/Sessions\/system_health Right-click on package0.eventfile and select “View Target … Continue reading →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbafox.com\/?p=1088\" \/>\n<meta property=\"og:site_name\" content=\"dbafox\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-31T09:51:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-02-08T10:44:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbafox.com\/wp-content\/uploads\/DeadlockHistory.png\" \/>\n<meta name=\"author\" content=\"Ray Fox\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ray Fox\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbafox.com\/?p=1088\",\"url\":\"https:\/\/dbafox.com\/?p=1088\",\"name\":\"SQL Server - Deadlock History with Extended Events - dbafox\",\"isPartOf\":{\"@id\":\"https:\/\/dbafox.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbafox.com\/?p=1088#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbafox.com\/?p=1088#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbafox.com\/wp-content\/uploads\/DeadlockHistory.png\",\"datePublished\":\"2018-01-31T09:51:43+00:00\",\"dateModified\":\"2018-02-08T10:44:57+00:00\",\"author\":{\"@id\":\"https:\/\/dbafox.com\/#\/schema\/person\/287adc474c1aebd398752ac4dcfe27eb\"},\"breadcrumb\":{\"@id\":\"https:\/\/dbafox.com\/?p=1088#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbafox.com\/?p=1088\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/dbafox.com\/?p=1088#primaryimage\",\"url\":\"https:\/\/dbafox.com\/wp-content\/uploads\/DeadlockHistory.png\",\"contentUrl\":\"https:\/\/dbafox.com\/wp-content\/uploads\/DeadlockHistory.png\",\"width\":431,\"height\":275,\"caption\":\"Extended Events to display deadlock history\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbafox.com\/?p=1088#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbafox.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server – Deadlock History with Extended Events\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbafox.com\/#website\",\"url\":\"https:\/\/dbafox.com\/\",\"name\":\"dbafox\",\"description\":\"DBA Technical Information\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbafox.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbafox.com\/#\/schema\/person\/287adc474c1aebd398752ac4dcfe27eb\",\"name\":\"Ray Fox\",\"sameAs\":[\"http:\/\/www.dbafox.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server - Deadlock History with Extended Events - dbafox","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:\/\/dbafox.com\/?p=1088","og_locale":"en_GB","og_type":"article","og_title":"SQL Server - Deadlock History with Extended Events - dbafox","og_description":"Using SSMS to Display Deadlock History with Extended Events To use Extended Events to display deadlock history, the following method can be used. In the Object Explorer, Open Management folder Open Extended Events\/Sessions\/system_health Right-click on package0.eventfile and select “View Target … Continue reading →","og_url":"https:\/\/dbafox.com\/?p=1088","og_site_name":"dbafox","article_published_time":"2018-01-31T09:51:43+00:00","article_modified_time":"2018-02-08T10:44:57+00:00","og_image":[{"url":"https:\/\/dbafox.com\/wp-content\/uploads\/DeadlockHistory.png","type":"","width":"","height":""}],"author":"Ray Fox","twitter_misc":{"Written by":"Ray Fox"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/dbafox.com\/?p=1088","url":"https:\/\/dbafox.com\/?p=1088","name":"SQL Server - Deadlock History with Extended Events - dbafox","isPartOf":{"@id":"https:\/\/dbafox.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbafox.com\/?p=1088#primaryimage"},"image":{"@id":"https:\/\/dbafox.com\/?p=1088#primaryimage"},"thumbnailUrl":"https:\/\/dbafox.com\/wp-content\/uploads\/DeadlockHistory.png","datePublished":"2018-01-31T09:51:43+00:00","dateModified":"2018-02-08T10:44:57+00:00","author":{"@id":"https:\/\/dbafox.com\/#\/schema\/person\/287adc474c1aebd398752ac4dcfe27eb"},"breadcrumb":{"@id":"https:\/\/dbafox.com\/?p=1088#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbafox.com\/?p=1088"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/dbafox.com\/?p=1088#primaryimage","url":"https:\/\/dbafox.com\/wp-content\/uploads\/DeadlockHistory.png","contentUrl":"https:\/\/dbafox.com\/wp-content\/uploads\/DeadlockHistory.png","width":431,"height":275,"caption":"Extended Events to display deadlock history"},{"@type":"BreadcrumbList","@id":"https:\/\/dbafox.com\/?p=1088#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbafox.com\/"},{"@type":"ListItem","position":2,"name":"SQL Server – Deadlock History with Extended Events"}]},{"@type":"WebSite","@id":"https:\/\/dbafox.com\/#website","url":"https:\/\/dbafox.com\/","name":"dbafox","description":"DBA Technical Information","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbafox.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/dbafox.com\/#\/schema\/person\/287adc474c1aebd398752ac4dcfe27eb","name":"Ray Fox","sameAs":["http:\/\/www.dbafox.com"]}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3ecMb-hy","_links":{"self":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/posts\/1088","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dbafox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1088"}],"version-history":[{"count":20,"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/posts\/1088\/revisions"}],"predecessor-version":[{"id":1122,"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/posts\/1088\/revisions\/1122"}],"wp:attachment":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1088"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbafox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1088"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbafox.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1088"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}