{"id":527,"date":"2011-10-04T02:42:00","date_gmt":"2011-10-04T02:42:00","guid":{"rendered":"\/blogs\/joe\/post\/Under-the-covers-with-sp_server_diagnostics-data-(Part-I).aspx"},"modified":"2011-10-04T02:42:00","modified_gmt":"2011-10-04T02:42:00","slug":"under-the-covers-with-sp_server_diagnostics-data-part-i","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/joe\/under-the-covers-with-sp_server_diagnostics-data-part-i\/","title":{"rendered":"Under the covers with sp_server_diagnostics data (Part I)"},"content":{"rendered":"

<\/font><\/p>\n

\nThis post covers examples from Denali CTP3, version 11.0.1440<\/em>.<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\nIn this post I’ll be discussing the SQL Server health related output from Denali’s sys.sp_server_diagnostics<\/em> system stored procedure.  <\/span>This system stored procedure is used to check Denali SQL Server health status behind-the-scenes for both failover cluster instances and availability groups.  <\/span><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\nWhile this procedure is used in service of base functionality, you can still call sys.sp_server_diagnostics directly yourself and find some pretty useful information embedded in the [data] column.  <\/span>This is information that you could gather using other methods as well, but if you’re in a situation where you don’t have access to your script toolbox or if there are no existing data collection processes running on the SQL Server instance you have a quick way to snapshot the health of the SQL Server instance at a specific point in time.  <\/span><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\nWhile this procedure is documented in Books Online, the output it returns may change in the future and so you should avoid creating application dependencies on it.  <\/span> <\/span>With that said, I think this is a great out-of-the-box tool and I can definitely see using it in the future to supplement other data sources or serve as a quick assessment in a pinch…<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\nFor this post I’ll capture a single execution of the stored procedure into a new table in tempdb:<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\nUSE tempdb<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n<\/font>\n<\/p>\n

<\/font><\/p>\n

\nCREATE TABLE dbo.tmp_sp_server_diagnostics<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n               <\/span>([create_time] datetime,<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n               <\/span> <\/span>[component_name] nvarchar(20),<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n               <\/span> <\/span>[state] int,<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n               <\/span> <\/span>[state_desc] nvarchar(20),<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n               <\/span> <\/span>[data] xml)<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n<\/font>\n<\/p>\n

<\/font><\/p>\n

\nINSERT dbo.tmp_sp_server_diagnostics<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\nEXEC sys.sp_server_diagnostics<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n<\/font>\n<\/p>\n

<\/font><\/p>\n

\nAs an aside, I’m using the xml data type for the “data” column in the tmp_sp_server_diagnostics table – but that is not<\/em> its actual data type according to Books Online (which states that it is varchar(max)). Aaron Bertrand (<\/font>b<\/font><\/a> | <\/font>t<\/font><\/a>) actually posted a Microsoft Connect item<\/a> regarding<\/font> this observation several months ago, discussing the merits of using the xml data type instead (one advantage being that the format is easier to display in SSMS). And if I designate the [data] column as xml for the destination output table, it implicitly converts upon INSERT just fine.<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\nThe following query returns the 5 rows (without doing anything fancy with the XML value):<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\nSELECT create_time, component_name, state, state_desc, data <\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\nFROM dbo.tmp_sp_server_diagnostics<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n<\/font>\n<\/p>\n

<\/font><\/p>\n

\nThis returned:<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n

\n\tcreate_time        <\/span>                              <\/span>component_name            <\/span>state      <\/span>               <\/span>state_desc<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\t2011-10-04 07:57:07.503              <\/span>system  <\/span>                              <\/span>1             <\/span>               <\/span>clean<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\t2011-10-04 07:57:07.503              <\/span>resource              <\/span>               <\/span>1             <\/span>               <\/span>clean<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\t2011-10-04 07:57:07.503              <\/span>query_processing             <\/span>1             <\/span>               <\/span>clean<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\t2011-10-04 07:57:07.503              <\/span>io_subsystem     <\/span>               <\/span>1             <\/span>               <\/span>clean<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\t2011-10-04 07:57:07.503              <\/span>events   <\/span>                              <\/span>0             <\/span>               <\/span>unknown<\/font><\/font>\n\t<\/p>\n

\t<\/font>\n<\/p><\/blockquote>\n

\n<\/font>\n<\/p>\n

<\/font><\/p>\n

\nI intentionally left off the xml [data] column off the previous result set as this is what I’ll be walking through over this post and the next. Each row represents a different monitored “component” – covering system, resource, query processing, IO subsystem and events. I won’t recap BOL on what each of the rows reflects – but instead I’ll jump into the output and call out why this is useful.<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n<\/font>\n<\/p>\n

<\/font><\/p>\n

\nSince the [data] column was captured in the xml data type, clicking on any value in SQL Server Management Studio should bring you to the output in a separate, formatted window.  <\/span>So on my system, the first row was for the “system” component, which had a value as follows:<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n<system sqlCpuUtilization="0" systemCpuUtilization="4" pageFaults="2654" nonYieldingTasksReported="0" intervalDumpRequests="0" totalDumpRequests="0" writeAccessViolationCount="0" isAccessViolationOccurred="0" latchWarnings="0" sickSpinlockTypeAfterAv="none" sickSpinlockType="none" spinlockBackoffs="0"\/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\nBased on the naming conventions we’re looking at – the following categories of information for the “system” component data get surfaced:<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n·<\/font>        <\/span><\/span><\/span>CPU utilization (sqlCpuUtilization, systemCpuUtilization)<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n·<\/font>        <\/span><\/span><\/span>Page Faults (pageFaults)<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n·<\/font>        <\/span><\/span><\/span>Non Yielding tasks (nonYieldingTasksReported)<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n·<\/font>        <\/span><\/span><\/span>Dumps (intervalDumpRequests, totalDumpRequests)<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n·<\/font>        <\/span><\/span><\/span>Access Violations (writeAccessViolationCount, isAccessViolationOccurred )<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n·<\/font>        <\/span><\/span><\/span>Latches (latchWarnings)<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n·<\/font>        <\/span><\/span><\/span>Spinlock activity (spinlockBackoffs, sickSpinlockType, sickSpinlockTypeAfterAv )<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\nSo basically we’re looking at a bundling of occurrence counts and current values that would be quite helpful to a support engineer.  <\/span>I’ll be interested to find out what rules are used to assess “clean” state for the system component.  <\/span>I imagine this can be reversed engineered through various scenarios, but hopefully the logic will be revealed directly.  <\/span>The actual text of sp_server_diagnostics is “(server internal)” if you try looking at the definition.<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\nMoving along, for the “resource” component data there are three areas of interest in the XML output. The first is around general resource monitoring:<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n<resource lastNotification="RESOURCE_MEMPHYSICAL_HIGH" outOfMemoryExceptions="0" isAnyPoolOutOfMemory="0" processOutOfMemoryPeriod="0"><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\nSo the lastNotification looks to be the memory manager’s latest report, with RESOURCE_MEMPHYSICAL_HIGH telling us that SQL Server can further consume more memory (in this example).   <\/span>The other attributes cover out-of-memory statistics.<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\nThe second section of information from the “resource” component data is a memory report around Process and System counters and counts:<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n<memoryReport name="Process\/System Counts" unit="Value"><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Available Physical Memory" value="286638080" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Available Virtual Memory" value="8792557727744" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Available Paging File" value="1205690368" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Working Set" value="184197120" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Percent of Committed Memory in WS" value="100" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Page Faults" value="70284" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="System physical memory high" value="1" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="System physical memory low" value="0" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Process physical memory low" value="0" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Process virtual memory low" value="0" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n  <\/span><\/memoryReport><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n<\/font>\n<\/p>\n

<\/font><\/p>\n

\nAgain this is an example where we are pulling data (such as available physical and virtual memory) that could be pulled via other methods and sources.  <\/span>But in absence of other ready-to-use queries, using sp_server_diagnostics you have a nice sampling of the data as of a point in time.<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n<\/span><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\nThe third memory report from the “resource” component data covers Memory Manager counter values:<\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n<\/font>\n<\/p>\n

<\/font><\/p>\n

\n  <\/span><memoryReport name="Memory Manager" unit="KB"><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="VM Reserved" value="3098256" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="VM Committed" value="162896" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Locked Pages Allocated" value="0" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Large Pages Allocated" value="0" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Emergency Memory" value="1024" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Emergency Memory In Use" value="16" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Target Committed" value="389912" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Current Committed" value="162896" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Pages Allocated" value="109672" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Pages Reserved" value="0" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Pages Free" value="3464" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Pages In Use" value="122536" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Page Alloc Potential" value="873184" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="NUMA Growth Phase" value="0" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Last OOM Factor" value="0" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n    <\/span><entry description="Last OS Error" value="0" \/><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n  <\/span><\/memoryReport><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n<\/resource><\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\n<\/font>\n<\/p>\n

<\/font><\/p>\n

\nIn this case, although this summarized data is good, I do think collecting DBCC MEMORYSTATUS would still be useful (more detailed) along with perfmon data so I can see memory trends over time. As with any new feature, the real test of utility is in using it during an actual issue and seeing if it helps. <\/font><\/font>\n<\/p>\n

<\/font><\/p>\n

\nIn Part II of this post I’ll cover the “query_processing” (my favorite out of the bunch), “io_subsystem” and “events” component data.  <\/span>At a future point I’d also like to share  <\/span>queries for parsing out the data and also comparing samplings over time, particularly since sp_server_diagnostics has a built-in repeat interval capability, enabling it to sample data every X number of seconds.<\/font><\/font>\n<\/p>\n

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

This post covers examples from Denali CTP3, version 11.0.1440. In this post I’ll be discussing the SQL Server health related output from Denali’s sys.sp_server_diagnostics system stored procedure.  This system stored procedure is used to check Denali SQL Server health status behind-the-scenes for both failover cluster instances and availability groups.   While this procedure is used […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[],"class_list":["post-527","post","type-post","status-publish","format-standard","hentry","category-performance"],"yoast_head":"\nUnder the covers with sp_server_diagnostics data (Part I) - Joe Sack<\/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\/joe\/under-the-covers-with-sp_server_diagnostics-data-part-i\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Under the covers with sp_server_diagnostics data (Part I) - Joe Sack\" \/>\n<meta property=\"og:description\" content=\"This post covers examples from Denali CTP3, version 11.0.1440. In this post I’ll be discussing the SQL Server health related output from Denali’s sys.sp_server_diagnostics system stored procedure.  This system stored procedure is used to check Denali SQL Server health status behind-the-scenes for both failover cluster instances and availability groups.   While this procedure is used […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/joe\/under-the-covers-with-sp_server_diagnostics-data-part-i\/\" \/>\n<meta property=\"og:site_name\" content=\"Joe Sack\" \/>\n<meta property=\"article:published_time\" content=\"2011-10-04T02:42:00+00:00\" \/>\n<meta name=\"author\" content=\"Joseph Sack\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Joseph Sack\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/under-the-covers-with-sp_server_diagnostics-data-part-i\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/under-the-covers-with-sp_server_diagnostics-data-part-i\/\",\"name\":\"Under the covers with sp_server_diagnostics data (Part I) - Joe Sack\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#website\"},\"datePublished\":\"2011-10-04T02:42:00+00:00\",\"dateModified\":\"2011-10-04T02:42:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/under-the-covers-with-sp_server_diagnostics-data-part-i\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/joe\/under-the-covers-with-sp_server_diagnostics-data-part-i\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/under-the-covers-with-sp_server_diagnostics-data-part-i\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Performance\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/category\/performance\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Under the covers with sp_server_diagnostics data (Part I)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/\",\"name\":\"Joe Sack\",\"description\":\"SQL Server Performance Tuning, High Availability and Disaster Recovery Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648\",\"name\":\"Joseph Sack\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g\",\"caption\":\"Joseph Sack\"},\"description\":\"Joe Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail and the real estate industry. Prior to joining SQLskills he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development and high-availability. In 2006 Joe earned the \u201cMicrosoft Certified Master: SQL Server 2005\u201d certification and in 2008 he earned the \u201cMicrosoft Certified Master: SQL Server 2008\u201d certification. In 2009 he took over responsibility for the entire SQL Server Microsoft Certified Master program and held that post until 2011. He was given the SQL Server MVP award in 2013.\",\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/joe\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/josephsack\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/author\/joe\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Under the covers with sp_server_diagnostics data (Part I) - Joe Sack","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\/joe\/under-the-covers-with-sp_server_diagnostics-data-part-i\/","og_locale":"en_US","og_type":"article","og_title":"Under the covers with sp_server_diagnostics data (Part I) - Joe Sack","og_description":"This post covers examples from Denali CTP3, version 11.0.1440. In this post I’ll be discussing the SQL Server health related output from Denali’s sys.sp_server_diagnostics system stored procedure.  This system stored procedure is used to check Denali SQL Server health status behind-the-scenes for both failover cluster instances and availability groups.   While this procedure is used […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/joe\/under-the-covers-with-sp_server_diagnostics-data-part-i\/","og_site_name":"Joe Sack","article_published_time":"2011-10-04T02:42:00+00:00","author":"Joseph Sack","twitter_misc":{"Written by":"Joseph Sack","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/under-the-covers-with-sp_server_diagnostics-data-part-i\/","url":"https:\/\/www.sqlskills.com\/blogs\/joe\/under-the-covers-with-sp_server_diagnostics-data-part-i\/","name":"Under the covers with sp_server_diagnostics data (Part I) - Joe Sack","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#website"},"datePublished":"2011-10-04T02:42:00+00:00","dateModified":"2011-10-04T02:42:00+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/under-the-covers-with-sp_server_diagnostics-data-part-i\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/joe\/under-the-covers-with-sp_server_diagnostics-data-part-i\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/under-the-covers-with-sp_server_diagnostics-data-part-i\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/joe\/"},{"@type":"ListItem","position":2,"name":"Performance","item":"https:\/\/www.sqlskills.com\/blogs\/joe\/category\/performance\/"},{"@type":"ListItem","position":3,"name":"Under the covers with sp_server_diagnostics data (Part I)"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/joe\/","name":"Joe Sack","description":"SQL Server Performance Tuning, High Availability and Disaster Recovery Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/joe\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648","name":"Joseph Sack","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g","caption":"Joseph Sack"},"description":"Joe Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail and the real estate industry. Prior to joining SQLskills he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development and high-availability. In 2006 Joe earned the \u201cMicrosoft Certified Master: SQL Server 2005\u201d certification and in 2008 he earned the \u201cMicrosoft Certified Master: SQL Server 2008\u201d certification. In 2009 he took over responsibility for the entire SQL Server Microsoft Certified Master program and held that post until 2011. He was given the SQL Server MVP award in 2013.","sameAs":["http:\/\/3.209.169.194\/blogs\/joe","https:\/\/twitter.com\/https:\/\/twitter.com\/josephsack"],"url":"https:\/\/www.sqlskills.com\/blogs\/joe\/author\/joe\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts\/527","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/comments?post=527"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts\/527\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/media?parent=527"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/categories?post=527"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/tags?post=527"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}