{"id":551,"date":"2010-12-14T08:00:00","date_gmt":"2010-12-14T08:00:00","guid":{"rendered":"\/blogs\/jonathan\/post\/An-XEvent-a-Day-(13-of-31)-The-system_health-Session.aspx"},"modified":"2017-04-13T12:12:55","modified_gmt":"2017-04-13T16:12:55","slug":"an-xevent-a-day-13-of-31-the-system_health-session","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-13-of-31-the-system_health-session\/","title":{"rendered":"An XEvent a Day (13 of 31) &#8211; The system_health Session"},"content":{"rendered":"<p>Today\u2019s post was originally planned for this coming weekend, but seems I\u2019ve caught whatever bug my kids had over the weekend so I am changing up today\u2019s blog post with one that is easier to cover and shorter.&#160; If you\u2019ve been running some of the queries from the posts in this series, you have no doubt come across an Event Session running on your server with the name of system_health.&#160; In today\u2019s post I\u2019ll go over this session and provide links to references related to it.<\/p>\n<p>When Extended Events was introduced in SQL Server 2008, the Produce Support Services group worked with the Extended Events developers to create the definition for an Event Session that could be shipped with SQL Server 2008, would startup automatically when SQL Server starts up, and contained Events of interest in troubleshooting common problems seen by the PSS Engineers.&#160; Bob Ward (<a href=\"https:\/\/blogs.msdn.microsoft.com\/b\/psssql\/\" target=\"_blank\">Blog<\/a>|<a href=\"https:\/\/twitter.com\/bobwardms\" target=\"_blank\">Twitter<\/a>) blogged about the details of the system_health session that shipped with SQL Server 2008 in his blog post <a href=\"https:\/\/blogs.msdn.microsoft.com\/b\/psssql\/archive\/2008\/07\/15\/supporting-sql-server-2008-the-system-health-session.aspx\">Supporting SQL Server 2008: The system_health session<\/a>.&#160; The script for this Event Session is inside of the utables.sql script file that is in the instance Install folder (for example c:\\Program Files\\Microsoft SQL Server\\&lt;InstanceDesignator&gt;\\MSSQL\\Install) and can be used to recreate the Event Session if you inadvertently change it.<\/p>\n<blockquote>\n<pre class=\"code\"><span style=\"color: green\">-- The predicates in this session have been carefully crafted to minimize impact of event collection\r\n-- Changing the predicate definition may impact system performance\r\n--\r\n<\/span><span style=\"color: blue\">CREATE EVENT SESSION <\/span>system_health <span style=\"color: blue\">ON SERVER<\/span><\/pre>\n<\/blockquote>\n<ul>\n<li>The sql_text and session_id for any sessions that encounter an error that has a severity &gt;=20. <\/li>\n<li>The sql_text and session_id for any sessions that encounter a memory-related error. The errors include 17803, 701, 802, 8645, 8651, 8657 and 8902. <\/li>\n<\/ul>\n<blockquote>\n<pre class=\"code\"><span style=\"color: blue\">ADD EVENT <\/span>sqlserver<span style=\"color: gray\">.<\/span>error_reported\r\n<span style=\"color: gray\">(\r\n    <\/span><span style=\"color: blue\">ACTION <\/span><span style=\"color: gray\">(<\/span>package0<span style=\"color: gray\">.<\/span>callstack<span style=\"color: gray\">, <\/span>sqlserver<span style=\"color: gray\">.<\/span>session_id<span style=\"color: gray\">, <\/span>sqlserver<span style=\"color: gray\">.<\/span>sql_text<span style=\"color: gray\">, <\/span>sqlserver<span style=\"color: gray\">.<\/span>tsql_stack<span style=\"color: gray\">)\r\n    <\/span><span style=\"color: green\">-- Get callstack, SPID, and query for all high severity errors ( above sev 20 )\r\n    <\/span><span style=\"color: blue\">WHERE <\/span>severity <span style=\"color: gray\">&gt;= <\/span>20\r\n    <span style=\"color: green\">-- Get callstack, SPID, and query for OOM errors ( 17803 , 701 , 802 , 8645 , 8651 , 8657 , 8902 )\r\n    <\/span><span style=\"color: gray\">OR (<\/span>ERROR <span style=\"color: gray\">= <\/span>17803 <span style=\"color: gray\">OR <\/span>ERROR <span style=\"color: gray\">= <\/span>701 <span style=\"color: gray\">OR <\/span>ERROR <span style=\"color: gray\">= <\/span>802 <span style=\"color: gray\">OR <\/span>ERROR <span style=\"color: gray\">= <\/span>8645 <span style=\"color: gray\">OR <\/span>ERROR <span style=\"color: gray\">= <\/span>8651 <span style=\"color: gray\">OR <\/span>ERROR <span style=\"color: gray\">= <\/span>8657 <span style=\"color: gray\">OR <\/span>ERROR <span style=\"color: gray\">= <\/span>8902<span style=\"color: gray\">)\r\n),<\/span><\/pre>\n<\/blockquote>\n<ul>\n<li>A record of any non-yielding scheduler problems. (These appear in the SQL Server error log as error 17883.) <\/li>\n<\/ul>\n<blockquote>\n<pre class=\"code\"><span style=\"color: blue\">ADD EVENT <\/span>sqlos<span style=\"color: gray\">.<\/span>scheduler_monitor_non_yielding_ring_buffer_recorded<span style=\"color: gray\">,<\/span><\/pre>\n<\/blockquote>\n<ul>\n<li>Any deadlocks that are detected. <\/li>\n<\/ul>\n<blockquote><\/blockquote>\n<blockquote><\/blockquote>\n<blockquote>\n<pre class=\"code\"><span style=\"color: blue\">ADD EVENT <\/span>sqlserver<span style=\"color: gray\">.<\/span>xml_deadlock_report<span style=\"color: gray\">,<\/span><\/pre>\n<\/blockquote>\n<ul>\n<li>The callstack, sql_text, and session_id for any sessions that have waited on latches (or other interesting resources) for &gt; 15 seconds. <\/li>\n<\/ul>\n<blockquote>\n<pre class=\"code\"><span style=\"color: blue\">ADD EVENT <\/span>sqlos<span style=\"color: gray\">.<\/span>wait_info\r\n<span style=\"color: gray\">(\r\n    <\/span><span style=\"color: blue\">ACTION <\/span><span style=\"color: gray\">(<\/span>package0<span style=\"color: gray\">.<\/span>callstack<span style=\"color: gray\">, <\/span>sqlserver<span style=\"color: gray\">.<\/span>session_id<span style=\"color: gray\">, <\/span>sqlserver<span style=\"color: gray\">.<\/span>sql_text<span style=\"color: gray\">)\r\n    <\/span><span style=\"color: blue\">WHERE \r\n    <\/span><span style=\"color: gray\">(<\/span>duration <span style=\"color: gray\">&gt; <\/span>15000 <span style=\"color: gray\">AND \r\n        (    \r\n            (<\/span>wait_type <span style=\"color: gray\">&gt; <\/span>31    <span style=\"color: green\">-- Waits for latches and important wait resources (not locks ) that have exceeded 15 seconds. \r\n                <\/span><span style=\"color: gray\">AND\r\n                (\r\n                    (<\/span>wait_type <span style=\"color: gray\">&gt; <\/span>47 <span style=\"color: gray\">AND <\/span>wait_type <span style=\"color: gray\">&lt; <\/span>54<span style=\"color: gray\">)\r\n                    OR <\/span>wait_type <span style=\"color: gray\">&lt; <\/span>38\r\n                    <span style=\"color: gray\">OR (<\/span>wait_type <span style=\"color: gray\">&gt; <\/span>63 <span style=\"color: gray\">AND <\/span>wait_type <span style=\"color: gray\">&lt; <\/span>70<span style=\"color: gray\">)\r\n                    OR (<\/span>wait_type <span style=\"color: gray\">&gt; <\/span>96 <span style=\"color: gray\">AND <\/span>wait_type <span style=\"color: gray\">&lt; <\/span>100<span style=\"color: gray\">)\r\n                    OR (<\/span>wait_type <span style=\"color: gray\">= <\/span>107<span style=\"color: gray\">)\r\n                    OR (<\/span>wait_type <span style=\"color: gray\">= <\/span>113<span style=\"color: gray\">)\r\n                    OR (<\/span>wait_type <span style=\"color: gray\">&gt; <\/span>174 <span style=\"color: gray\">AND <\/span>wait_type <span style=\"color: gray\">&lt; <\/span>179<span style=\"color: gray\">)\r\n                    OR (<\/span>wait_type <span style=\"color: gray\">= <\/span>186<span style=\"color: gray\">)\r\n                    OR (<\/span>wait_type <span style=\"color: gray\">= <\/span>207<span style=\"color: gray\">)\r\n                    OR (<\/span>wait_type <span style=\"color: gray\">= <\/span>269<span style=\"color: gray\">)\r\n                    OR (<\/span>wait_type <span style=\"color: gray\">= <\/span>283<span style=\"color: gray\">)\r\n                    OR (<\/span>wait_type <span style=\"color: gray\">= <\/span>284<span style=\"color: gray\">)\r\n                )\r\n            )<\/span><\/pre>\n<\/blockquote>\n<ul>\n<li>The callstack, sql_text, and session_id for any sessions that have waited on locks for &gt; 30 seconds. <\/li>\n<\/ul>\n<blockquote>\n<pre class=\"code\">            <span style=\"color: gray\">OR \r\n            (<\/span>duration <span style=\"color: gray\">&gt; <\/span>30000        <span style=\"color: green\">-- Waits for locks that have exceeded 30 secs.\r\n                <\/span><span style=\"color: gray\">AND <\/span>wait_type <span style=\"color: gray\">&lt; <\/span>22\r\n            <span style=\"color: gray\">) \r\n        )\r\n    )\r\n),<\/span><\/pre>\n<\/blockquote>\n<ul>\n<li>The callstack, sql_text, and session_id for any sessions that have waited for a long time for preemptive waits. The duration varies by wait type. A preemptive wait is where SQL Server is waiting for external API calls. <\/li>\n<\/ul>\n<blockquote>\n<pre class=\"code\"><span style=\"color: blue\">ADD EVENT <\/span>sqlos<span style=\"color: gray\">.<\/span>wait_info_external\r\n<span style=\"color: gray\">(\r\n    <\/span><span style=\"color: blue\">ACTION <\/span><span style=\"color: gray\">(<\/span>package0<span style=\"color: gray\">.<\/span>callstack<span style=\"color: gray\">, <\/span>sqlserver<span style=\"color: gray\">.<\/span>session_id<span style=\"color: gray\">, <\/span>sqlserver<span style=\"color: gray\">.<\/span>sql_text<span style=\"color: gray\">)\r\n    <\/span><span style=\"color: blue\">WHERE \r\n    <\/span><span style=\"color: gray\">(<\/span>duration <span style=\"color: gray\">&gt; <\/span>5000 <span style=\"color: gray\">AND\r\n        (   \r\n            (    <\/span><span style=\"color: green\">-- Login related preemptive waits that have exceeded 5 seconds.\r\n                <\/span><span style=\"color: gray\">(<\/span>wait_type <span style=\"color: gray\">&gt; <\/span>365 <span style=\"color: gray\">AND <\/span>wait_type <span style=\"color: gray\">&lt; <\/span>372<span style=\"color: gray\">)\r\n                OR    (<\/span>wait_type <span style=\"color: gray\">&gt; <\/span>372 <span style=\"color: gray\">AND <\/span>wait_type <span style=\"color: gray\">&lt; <\/span>377<span style=\"color: gray\">)\r\n                OR    (<\/span>wait_type <span style=\"color: gray\">&gt; <\/span>377 <span style=\"color: gray\">AND <\/span>wait_type <span style=\"color: gray\">&lt; <\/span>383<span style=\"color: gray\">)\r\n                OR    (<\/span>wait_type <span style=\"color: gray\">&gt; <\/span>420 <span style=\"color: gray\">AND <\/span>wait_type <span style=\"color: gray\">&lt; <\/span>424<span style=\"color: gray\">)\r\n                OR    (<\/span>wait_type <span style=\"color: gray\">&gt; <\/span>426 <span style=\"color: gray\">AND <\/span>wait_type <span style=\"color: gray\">&lt; <\/span>432<span style=\"color: gray\">)\r\n                OR    (<\/span>wait_type <span style=\"color: gray\">&gt; <\/span>432 <span style=\"color: gray\">AND <\/span>wait_type <span style=\"color: gray\">&lt; <\/span>435<span style=\"color: gray\">)\r\n            )\r\n            OR \r\n            (<\/span>duration <span style=\"color: gray\">&gt; <\/span>45000     <span style=\"color: green\">-- Preemptive OS waits that have exceeded 45 seconds. \r\n                <\/span><span style=\"color: gray\">AND \r\n                (    \r\n                    (<\/span>wait_type <span style=\"color: gray\">&gt; <\/span>382 <span style=\"color: gray\">AND <\/span>wait_type <span style=\"color: gray\">&lt; <\/span>386<span style=\"color: gray\">)\r\n                    OR    (<\/span>wait_type <span style=\"color: gray\">&gt; <\/span>423 <span style=\"color: gray\">AND <\/span>wait_type <span style=\"color: gray\">&lt; <\/span>427<span style=\"color: gray\">)\r\n                    OR    (<\/span>wait_type <span style=\"color: gray\">&gt; <\/span>434 <span style=\"color: gray\">AND <\/span>wait_type <span style=\"color: gray\">&lt; <\/span>437<span style=\"color: gray\">)\r\n                    OR    (<\/span>wait_type <span style=\"color: gray\">&gt; <\/span>442 <span style=\"color: gray\">AND <\/span>wait_type <span style=\"color: gray\">&lt; <\/span>451<span style=\"color: gray\">)\r\n                    OR    (<\/span>wait_type <span style=\"color: gray\">&gt; <\/span>451 <span style=\"color: gray\">AND <\/span>wait_type <span style=\"color: gray\">&lt; <\/span>473<span style=\"color: gray\">)\r\n                    OR    (<\/span>wait_type <span style=\"color: gray\">&gt; <\/span>484 <span style=\"color: gray\">AND <\/span>wait_type <span style=\"color: gray\">&lt; <\/span>499<span style=\"color: gray\">)\r\n                    OR <\/span>wait_type <span style=\"color: gray\">= <\/span>365\r\n                    <span style=\"color: gray\">OR <\/span>wait_type <span style=\"color: gray\">= <\/span>372\r\n                    <span style=\"color: gray\">OR <\/span>wait_type <span style=\"color: gray\">= <\/span>377\r\n                    <span style=\"color: gray\">OR <\/span>wait_type <span style=\"color: gray\">= <\/span>387\r\n                    <span style=\"color: gray\">OR <\/span>wait_type <span style=\"color: gray\">= <\/span>432\r\n                    <span style=\"color: gray\">OR <\/span>wait_type <span style=\"color: gray\">= <\/span>502\r\n                <span style=\"color: gray\">)\r\n            )\r\n        )\r\n    )\r\n)<\/span><\/pre>\n<\/blockquote>\n<ul>\n<li>Capture Event information using the ring_buffer target. <\/li>\n<\/ul>\n<blockquote><\/blockquote>\n<blockquote>\n<pre class=\"code\"><span style=\"color: blue\">ADD target <\/span>package0<span style=\"color: gray\">.<\/span>ring_buffer        <span style=\"color: green\">-- Store events in the ring buffer target\r\n    <\/span><span style=\"color: gray\">(<\/span><span style=\"color: blue\">SET <\/span>max_memory <span style=\"color: gray\">= <\/span>4096<span style=\"color: gray\">)<\/span><\/pre>\n<\/blockquote>\n<ul>\n<li>Set the session to start automatically with SQL Server <\/li>\n<\/ul>\n<blockquote>\n<pre class=\"code\"><span style=\"color: blue\">WITH <\/span><span style=\"color: gray\">(<\/span>startup_state <span style=\"color: gray\">= <\/span><span style=\"color: blue\">ON<\/span><span style=\"color: gray\">)\r\n<\/span><span style=\"color: blue\">GO<\/span><\/pre>\n<\/blockquote>\n<p>In SQL Server Denali CTP1, two new Events have been added to the system_health session specific to SQLCLR.<\/p>\n<ul>\n<li>A SQLCLR memory allocation failed. <\/li>\n<\/ul>\n<blockquote>\n<pre class=\"code\"><span style=\"color: blue\">ADD EVENT <\/span>sqlclr<span style=\"color: gray\">.<\/span>allocation_failure<span style=\"color: gray\">,<\/span><\/pre>\n<\/blockquote>\n<ul>\n<li>A SQLCLR virtual memory allocation failed. <\/li>\n<\/ul>\n<blockquote>\n<pre class=\"code\"><span style=\"color: blue\">ADD EVENT <\/span>sqlclr<span style=\"color: gray\">.<\/span>virtual_alloc_failure<span style=\"color: gray\">,<\/span><\/pre>\n<\/blockquote>\n<p>While the system_health session captures very useful information, it uses the ring_buffer Target to store the Event data.&#160; In a scenario where the database engine fails completely the information that may have been captured by the system_health session will be lost when the process terminates.&#160; Also since the Event Session uses the ring_buffer Target, it is possible that you may not receive back all of the Event data contained in the target, or the Events that you might have expected to exist.&#160; Bob Ward talked about the limitation of the DMV\u2019s to return 4MB of XML data and how this impacts the in memory Targets in Extended Events in his blog post <a href=\"https:\/\/blogs.msdn.microsoft.com\/b\/psssql\/archive\/2009\/09\/17\/you-may-not-see-the-data-you-expect-in-extended-event-ring-buffer-targets.aspx\">You may not see the data you expect in Extended Event Ring Buffer Targets\u2026.<\/a>&#160; <\/p>\n<p>One of my favorite aspects of the system_health session is that it includes deadlock tracing through Extended Events by default.&#160; However, in order to make use of the deadlock graph captured by Extended Events, you have to be on CU6 for SQL Server 2008 SP1 (<a title=\"http:\/\/support.microsoft.com\/kb\/978629\" href=\"https:\/\/support.microsoft.com\/kb\/978629\">http:\/\/support.microsoft.com\/kb\/978629<\/a>), or you could try to hack your way around the bug as I showed in my article <a href=\"http:\/\/www.sqlservercentral.com\/articles\/deadlocks\/65658\/\" target=\"_blank\">Retrieving Deadlock Graphs with SQL Server 2008 Extended Events<\/a>, and Michael Zilberstein\u2019s update to correct a problem with the code in that article, <a href=\"http:\/\/sqlblog.com\/blogs\/michael_zilberstein\/archive\/2010\/05\/10\/24970.aspx\" target=\"_blank\">Parsing Extended Events xml_deadlock_report<\/a>.&#160; The deadlock graph in Extended Events will not open graphically in SSMS like a SQL Trace XML Deadlock Graph will due to changes in its output to support multi-victim deadlocks, which I covered in my blog post <a href=\"http:\/\/sqlblog.com\/blogs\/jonathan_kehayias\/archive\/2009\/05\/27\/changes-to-the-deadlock-monitor-for-the-extended-events-xml-deadlock-report-and-multi-victim-deadlocks.aspx\">Changes to the Deadlock Monitor for the Extended Events xml_deadlock_report and Multi-Victim Deadlocks<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today\u2019s post was originally planned for this coming weekend, but seems I\u2019ve caught whatever bug my kids had over the weekend so I am changing up today\u2019s blog post with one that is easier to cover and shorter.&#160; If you\u2019ve been running some of the queries from the posts in this series, you have no [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,38,40,45],"tags":[],"class_list":["post-551","post","type-post","status-publish","format-standard","hentry","category-extended-events","category-sql-server-2008","category-sql-server-denali","category-xevent-a-day-series"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>An XEvent a Day (13 of 31) - The system_health Session - 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-13-of-31-the-system_health-session\/\" \/>\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 (13 of 31) - The system_health Session - Jonathan Kehayias\" \/>\n<meta property=\"og:description\" content=\"Today\u2019s post was originally planned for this coming weekend, but seems I\u2019ve caught whatever bug my kids had over the weekend so I am changing up today\u2019s blog post with one that is easier to cover and shorter.&#160; If you\u2019ve been running some of the queries from the posts in this series, you have no [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-13-of-31-the-system_health-session\/\" \/>\n<meta property=\"og:site_name\" content=\"Jonathan Kehayias\" \/>\n<meta property=\"article:published_time\" content=\"2010-12-14T08:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T16:12:55+00:00\" \/>\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=\"5 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-13-of-31-the-system_health-session\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-13-of-31-the-system_health-session\\\/\"},\"author\":{\"name\":\"Jonathan Kehayias\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"headline\":\"An XEvent a Day (13 of 31) &#8211; The system_health Session\",\"datePublished\":\"2010-12-14T08:00:00+00:00\",\"dateModified\":\"2017-04-13T16:12:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-13-of-31-the-system_health-session\\\/\"},\"wordCount\":699,\"commentCount\":0,\"articleSection\":[\"Extended Events\",\"SQL Server 2008\",\"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-13-of-31-the-system_health-session\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-13-of-31-the-system_health-session\\\/\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-13-of-31-the-system_health-session\\\/\",\"name\":\"An XEvent a Day (13 of 31) - The system_health Session - Jonathan Kehayias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\"},\"datePublished\":\"2010-12-14T08:00:00+00:00\",\"dateModified\":\"2017-04-13T16:12:55+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-13-of-31-the-system_health-session\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-13-of-31-the-system_health-session\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-13-of-31-the-system_health-session\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Extended Events\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/category\\\/extended-events\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"An XEvent a Day (13 of 31) &#8211; The system_health Session\"}]},{\"@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 (13 of 31) - The system_health Session - 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-13-of-31-the-system_health-session\/","og_locale":"en_US","og_type":"article","og_title":"An XEvent a Day (13 of 31) - The system_health Session - Jonathan Kehayias","og_description":"Today\u2019s post was originally planned for this coming weekend, but seems I\u2019ve caught whatever bug my kids had over the weekend so I am changing up today\u2019s blog post with one that is easier to cover and shorter.&#160; If you\u2019ve been running some of the queries from the posts in this series, you have no [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-13-of-31-the-system_health-session\/","og_site_name":"Jonathan Kehayias","article_published_time":"2010-12-14T08:00:00+00:00","article_modified_time":"2017-04-13T16:12:55+00:00","author":"Jonathan Kehayias","twitter_misc":{"Written by":"Jonathan Kehayias","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-13-of-31-the-system_health-session\/#article","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-13-of-31-the-system_health-session\/"},"author":{"name":"Jonathan Kehayias","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"headline":"An XEvent a Day (13 of 31) &#8211; The system_health Session","datePublished":"2010-12-14T08:00:00+00:00","dateModified":"2017-04-13T16:12:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-13-of-31-the-system_health-session\/"},"wordCount":699,"commentCount":0,"articleSection":["Extended Events","SQL Server 2008","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-13-of-31-the-system_health-session\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-13-of-31-the-system_health-session\/","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-13-of-31-the-system_health-session\/","name":"An XEvent a Day (13 of 31) - The system_health Session - Jonathan Kehayias","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website"},"datePublished":"2010-12-14T08:00:00+00:00","dateModified":"2017-04-13T16:12:55+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-13-of-31-the-system_health-session\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-13-of-31-the-system_health-session\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-13-of-31-the-system_health-session\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/"},{"@type":"ListItem","position":2,"name":"Extended Events","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/category\/extended-events\/"},{"@type":"ListItem","position":3,"name":"An XEvent a Day (13 of 31) &#8211; The system_health Session"}]},{"@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\/551","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=551"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/551\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/media?parent=551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/categories?post=551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/tags?post=551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}