{"id":6304,"date":"2015-12-10T09:00:38","date_gmt":"2015-12-10T08:00:38","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/"},"modified":"2015-12-10T09:00:38","modified_gmt":"2015-12-10T08:00:38","slug":"sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/","title":{"rendered":"SQL Server Extended Event: Eine Deadlock-Event aus der &#8220;system_health&#8221; \u00dcberwachung"},"content":{"rendered":"<p>Wie Sie vielleicht wissen, gibt es eine \u00dcberwachung \u00fcber Extended Events: <strong>system_health<\/strong>.<br \/>\nK\u00fcrzlich fragt mich ein Kunde an, um ein zuf\u00e4lliges Deadlock-Problem zu analysieren&#8230;<\/p>\n<p><!--more--><br \/>\nIch hatte im September in Lausanne einen Vortrag zum Thema Performance-Monitoring und Extended Events pr\u00e4sentiert&#8230;<br \/>\nViele Leute kennen das nicht, dass in den system_health des SQL Servers die Informationen zu den Deadlock-Events abgelegt sind.<\/p>\n<h3>Wo sind die \u201esystem_health\u201c Extended Event?<\/h3>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_00.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-5432 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_00.png\" alt=\"xe_deadlock_00\" width=\"234\" height=\"300\" \/><\/a><br \/>\nWie Sie sehen k\u00f6nnen, unter <strong>Management &#8211; Extended Events<\/strong> finden wir den \u201esystem_health mit 2 Eintr\u00e4gen:<\/p>\n<ul>\n<li><strong>Package0.event_file<\/strong>: Das Ereignisdateiziel ist ein Ziel, das den vollst\u00e4ndigen Puffer auf\u00a0 den Datentr\u00e4ger schreibt. Der Msdn Link <a title=\"Ereignisdateiziel \" href=\"https:\/\/msdn.microsoft.com\/de-de\/library\/ff878115.aspx\" target=\"_blank\">hier<\/a><\/li>\n<li><strong>Package0.ring_buffer<\/strong>: Das Ringpufferziel speichert kurzzeitig Ereignisdaten im Arbeitsspeicher. Der Msdn Link <a title=\"Ringpufferziel\" href=\"https:\/\/msdn.microsoft.com\/de-de\/library\/ff878182.aspx\" target=\"_blank\">hier<\/a><\/li>\n<\/ul>\n<p>Diese \u00dcberwachung ist direkt nach der Installatio n aktiv.<\/p>\n<h3>Erste Analyse<\/h3>\n<p>Ein Doppelklick auf das Ereignisdateiziel, \u00f6ffnet ein Fenster mit alle Events.<br \/>\nIn meinem Beispiel, haben wir <strong>7655 Events<\/strong>.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-5433 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_01.png\" alt=\"xe_deadlock_01\" width=\"300\" height=\"254\" \/><\/a><br \/>\nUm die Deadlock-Events zu sehen, erstelle ich ein Filter auf den Event: <strong>xml_deadlock_report<\/strong>.<br \/>\nJetzt habe ich nur noch <strong>541 Eintr\u00e4ge<\/strong> in meiner Liste f\u00fcr den Event \u201exml_deadlock_report\u201c.<br \/>\nSie haben bemerkt dass f\u00fcr jeden Event, 2 Tabs vorhanden sind:<\/p>\n<ul>\n<li>Details<\/li>\n<li>Deadlock<\/li>\n<\/ul>\n<p>Das <strong>\u201eDetail\u201c Tab<\/strong> gibt Auskunft in einem XML File zu diesem Event.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_05.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-5437 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_05.png\" alt=\"xe_deadlock_05\" width=\"300\" height=\"165\" \/><\/a><br \/>\nDas <strong>\u201eDeadLock\u201c Tab<\/strong> zeigt ein Schema<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_03.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-5435 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_03.png\" alt=\"xe_deadlock_03\" width=\"300\" height=\"183\" \/><\/a><br \/>\nUnd auf meiner Seite, ist das einfacher zu verstehen\u2026<\/p>\n<h3>Zweite Analyse<\/h3>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_06.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-5438 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_06.png\" alt=\"xe_deadlock_06\" width=\"300\" height=\"54\" \/><\/a><br \/>\nWir haben zwei Prozesse mit der id 68 und 75.<br \/>\nSQL Server stoppt den Prozess mit der id 68\u2026 Warum?<br \/>\nSQL Server hat eine System-Task REQUEST_FOR_DEADLOCK_SEARCH die alle f\u00fcnf Sekunden, \u00fcberwacht ob irgendwelche Deadlocks auftreten. Wenn er eine Deadlock findet, beendet diese System-Task ein von den zwei aktuelle Prozesse.<br \/>\nDie Frage ist, welscher Prozess wird beendet?<br \/>\nNormalerweise, der System-Task beendet den Prozess der den wenige \u201eLog used\u201c hat.<br \/>\nIn meinem Fall, sind die \u201eLog used\u201c gleich (864), dann beendet er den zweiten Prozess!<\/p>\n<p>In diesem Schema analysieren wir auch noch die \u201elocks\u201c Typen.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_08.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-5990 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_08.png\" alt=\"xe_deadlock_08\" width=\"300\" height=\"56\" \/><\/a><\/p>\n<p>Wir sehen das es ein shared (S) lock gibt ,ein exclusive(X) lock angefordert oder zugeteilt worden ist und auch noch ein shared (S) lock angefordert wurde.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_09.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-5989 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_09.png\" alt=\"xe_deadlock_09\" width=\"300\" height=\"240\" \/><\/a><\/p>\n<p>Source: <a title=\"Locks table\" href=\"https:\/\/technet.microsoft.com\/en-us\/library\/ms186396%28v=sql.105%29.aspx\" target=\"_blank\">https:\/\/technet.microsoft.com\/en-us\/library\/ms186396%28v=sql.105%29.aspx<\/a><\/p>\n<p>Ich denke, dass ist ein \u201eLese-Schreib\u201c Deadlock zwischen einer Anweisung die am Lesen ist und eine andere Anweisung die am Schreiben ist.<br \/>\nAber in diesem Schema, sehe ich die Anfragen die der den \u201eDeadlock\u201c generiert, hat nicht.<\/p>\n<h3>Dritte Analyse<\/h3>\n<p>Meine letzte Analyse ist mit den XML File.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_07.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-5439 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_07.png\" alt=\"xe_deadlock_07\" width=\"300\" height=\"165\" \/><\/a><br \/>\nDer Deadlock bezieht sich auf eine SELECT Anfragen.<\/p>\n<h3>Was k\u00f6nnen wir verbessern?<\/h3>\n<p>Die erste Idee ist, die NO LOCK Option. Mit dieser, den SELECT zu erstellen, das habe ich in anderen Blogs gesehen.<br \/>\nIn diesem Fall, eines Deadlock mit SELECT, ist diese Option nie die L\u00f6sung! \ud83d\ude41<br \/>\nDa m\u00fcsste man noch weiter nachforschen\u2026<\/p>\n<p>Der SQL Server h\u00e4lt ein shared (S) lock bis zum Ende der Transaktion mit sein Standardisolationsstufe (READ COMMITTED).<br \/>\nUm dieses Problem zu beheben, ist mein Vorschlag, die Isolationsstufe zu \u00e4ndern, auf READ COMMITTED SNAPSHOT oder SNAPSHOT.<br \/>\nIn dieser zeilenbasierten Isolationsstufen, k\u00f6nnen die Leser nicht Lock verwenden und m\u00fcssen stattdessen die zeilenbasiert Versionen f\u00fcr die Isolierung verwenden.<br \/>\nUnd in der Theorie, keine shared (S) locks bedeutet keine Deadlock.<\/p>\n<p>Um zum Schluss das Beste: Um diese Performance Probleme besser zu verstehen, besuchen Sie unseren neuen \u201e<a title=\"Workshop SQL Server Performance Tuning\" href=\"https:\/\/www.dbi-services.com\/de\/schulungen\/sql-server-performance-tuning-workshop\/\" target=\"_blank\">Workshop SQL Server Performance Tuning<\/a>\u201c! \ud83d\ude09<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Wie Sie vielleicht wissen, gibt es eine \u00dcberwachung \u00fcber Extended Events: system_health. K\u00fcrzlich fragt mich ein Kunde an, um ein zuf\u00e4lliges Deadlock-Problem zu analysieren&#8230;<\/p>\n","protected":false},"author":15,"featured_media":6313,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[368],"tags":[49,67,51],"type_dbi":[],"class_list":["post-6304","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-development-performance","tag-microsoft","tag-performance","tag-sql-server"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server Extended Event: Eine Deadlock-Event aus der &quot;system_health&quot; \u00dcberwachung<\/title>\n<meta name=\"description\" content=\"Viele Leute kennen das nicht, dass in den system_health des SQL Servers die Informationen zu den deadlock-Events sind.\" \/>\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.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Extended Event: Eine Deadlock-Event aus der &quot;system_health&quot; \u00dcberwachung\" \/>\n<meta property=\"og:description\" content=\"Viele Leute kennen das nicht, dass in den system_health des SQL Servers die Informationen zu den deadlock-Events sind.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-12-10T08:00:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_00-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"396\" \/>\n\t<meta property=\"og:image:height\" content=\"508\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server Extended Event: Eine Deadlock-Event aus der &#8220;system_health&#8221; \u00dcberwachung\",\"datePublished\":\"2015-12-10T08:00:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\\\/\"},\"wordCount\":564,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/xe_deadlock_00-1.png\",\"keywords\":[\"Microsoft\",\"Performance\",\"SQL Server\"],\"articleSection\":[\"Development &amp; Performance\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\\\/\",\"name\":\"SQL Server Extended Event: Eine Deadlock-Event aus der \\\"system_health\\\" \u00dcberwachung\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/xe_deadlock_00-1.png\",\"datePublished\":\"2015-12-10T08:00:38+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"Viele Leute kennen das nicht, dass in den system_health des SQL Servers die Informationen zu den deadlock-Events sind.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/xe_deadlock_00-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/xe_deadlock_00-1.png\",\"width\":396,\"height\":508},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Extended Event: Eine Deadlock-Event aus der &#8220;system_health&#8221; \u00dcberwachung\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \\\/ Financial Services, and many other industries.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server Extended Event: Eine Deadlock-Event aus der \"system_health\" \u00dcberwachung","description":"Viele Leute kennen das nicht, dass in den system_health des SQL Servers die Informationen zu den deadlock-Events sind.","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.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Extended Event: Eine Deadlock-Event aus der \"system_health\" \u00dcberwachung","og_description":"Viele Leute kennen das nicht, dass in den system_health des SQL Servers die Informationen zu den deadlock-Events sind.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/","og_site_name":"dbi Blog","article_published_time":"2015-12-10T08:00:38+00:00","og_image":[{"width":396,"height":508,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_00-1.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server Extended Event: Eine Deadlock-Event aus der &#8220;system_health&#8221; \u00dcberwachung","datePublished":"2015-12-10T08:00:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/"},"wordCount":564,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_00-1.png","keywords":["Microsoft","Performance","SQL Server"],"articleSection":["Development &amp; Performance"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/","name":"SQL Server Extended Event: Eine Deadlock-Event aus der \"system_health\" \u00dcberwachung","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_00-1.png","datePublished":"2015-12-10T08:00:38+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"Viele Leute kennen das nicht, dass in den system_health des SQL Servers die Informationen zu den deadlock-Events sind.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_00-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/xe_deadlock_00-1.png","width":396,"height":508},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-extended-event-eine-deadlock-event-von-system_health-uberwachung\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server Extended Event: Eine Deadlock-Event aus der &#8220;system_health&#8221; \u00dcberwachung"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6304","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=6304"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6304\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/6313"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=6304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=6304"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=6304"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=6304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}