{"id":1037,"date":"2016-01-14T07:37:16","date_gmt":"2016-01-14T15:37:16","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1037"},"modified":"2017-04-13T12:28:48","modified_gmt":"2017-04-13T19:28:48","slug":"sql-server-diagnostic-information-queries-detailed-day-14","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-diagnostic-information-queries-detailed-day-14\/","title":{"rendered":"SQL Server Diagnostic Information Queries Detailed, Day 14"},"content":{"rendered":"

For Day 14 of this series, we start out with Query #33<\/strong>, which is Top Waits. This query retrieves information from the sys.dm_os_wait_stats<\/a> dynamic management view about the cumulative wait statistics for the instance since the last time it was restarted (or the wait statistics were manually cleared). Query #33 is shown in Figure 1.<\/p>\n

\n
\n
   1:<\/span> -- Clear Wait Stats with this command<\/span><\/pre>\n
<\/p>\n
   2:<\/span> -- DBCC SQLPERF('sys.dm_os_wait_stats', CLEAR);<\/span><\/pre>\n
<\/p>\n
   3:<\/span>  <\/pre>\n
<\/p>\n
   4:<\/span> -- Isolate top waits for server instance since last restart or wait statistics clear  (Query 33) (Top Waits)<\/span><\/pre>\n
<\/p>\n
   5:<\/span> WITH<\/span> [Waits] <\/pre>\n
<\/p>\n
   6:<\/span> AS<\/span> (SELECT<\/span> wait_type, wait_time_ms\/ 1000.0 AS<\/span> [WaitS],<\/pre>\n
<\/p>\n
   7:<\/span>           (wait_time_ms - signal_wait_time_ms) \/ 1000.0 AS<\/span> [ResourceS],<\/pre>\n
<\/p>\n
   8:<\/span>            signal_wait_time_ms \/ 1000.0 AS<\/span> [SignalS],<\/pre>\n
<\/p>\n
   9:<\/span>            waiting_tasks_count AS<\/span> [WaitCount],<\/pre>\n
<\/p>\n
  10:<\/span>            100.0 *  wait_time_ms \/ SUM<\/span> (wait_time_ms) OVER<\/span>() AS<\/span> [Percentage],<\/pre>\n
<\/p>\n
  11:<\/span>            ROW_NUMBER() OVER<\/span>(ORDER<\/span> BY<\/span> wait_time_ms DESC<\/span>) AS<\/span> [RowNum]<\/pre>\n
<\/p>\n
  12:<\/span>     FROM<\/span> sys.dm_os_wait_stats WITH<\/span> (NOLOCK)<\/pre>\n
<\/p>\n
  13:<\/span>     WHERE<\/span> [wait_type] NOT<\/span> IN<\/span> (<\/pre>\n
<\/p>\n
  14:<\/span>         N'BROKER_EVENTHANDLER'<\/span>, N'BROKER_RECEIVE_WAITFOR'<\/span>, N'BROKER_TASK_STOP'<\/span>,<\/pre>\n
<\/p>\n
  15:<\/span>         N'BROKER_TO_FLUSH'<\/span>, N'BROKER_TRANSMITTER'<\/span>, N'CHECKPOINT_QUEUE'<\/span>,<\/pre>\n
<\/p>\n
  16:<\/span>         N'CHKPT'<\/span>, N'CLR_AUTO_EVENT'<\/span>, N'CLR_MANUAL_EVENT'<\/span>, N'CLR_SEMAPHORE'<\/span>,<\/pre>\n
<\/p>\n
  17:<\/span>         N'DBMIRROR_DBM_EVENT'<\/span>, N'DBMIRROR_EVENTS_QUEUE'<\/span>, N'DBMIRROR_WORKER_QUEUE'<\/span>,<\/pre>\n
<\/p>\n
  18:<\/span>         N'DBMIRRORING_CMD'<\/span>, N'DIRTY_PAGE_POLL'<\/span>, N'DISPATCHER_QUEUE_SEMAPHORE'<\/span>,<\/pre>\n
<\/p>\n
  19:<\/span>         N'EXECSYNC'<\/span>, N'FSAGENT'<\/span>, N'FT_IFTS_SCHEDULER_IDLE_WAIT'<\/span>, N'FT_IFTSHC_MUTEX'<\/span>,<\/pre>\n
<\/p>\n
  20:<\/span>         N'HADR_CLUSAPI_CALL'<\/span>, N'HADR_FILESTREAM_IOMGR_IOCOMPLETION'<\/span>, N'HADR_LOGCAPTURE_WAIT'<\/span>, <\/pre>\n
<\/p>\n
  21:<\/span>         N'HADR_NOTIFICATION_DEQUEUE'<\/span>, N'HADR_TIMER_TASK'<\/span>, N'HADR_WORK_QUEUE'<\/span>,<\/pre>\n
<\/p>\n
  22:<\/span>         N'KSOURCE_WAKEUP'<\/span>, N'LAZYWRITER_SLEEP'<\/span>, N'LOGMGR_QUEUE'<\/span>, <\/pre>\n
<\/p>\n
  23:<\/span>         N'MEMORY_ALLOCATION_EXT'<\/span>, N'ONDEMAND_TASK_QUEUE'<\/span>,<\/pre>\n
<\/p>\n
  24:<\/span>         N'PREEMPTIVE_OS_LIBRARYOPS'<\/span>, N'PREEMPTIVE_OS_COMOPS'<\/span>, N'PREEMPTIVE_OS_CRYPTOPS'<\/span>,<\/pre>\n
<\/p>\n
  25:<\/span>         N'PREEMPTIVE_OS_PIPEOPS'<\/span>, N'PREEMPTIVE_OS_AUTHENTICATIONOPS'<\/span>,<\/pre>\n
<\/p>\n
  26:<\/span>         N'PREEMPTIVE_OS_GENERICOPS'<\/span>, N'PREEMPTIVE_OS_VERIFYTRUST'<\/span>,<\/pre>\n
<\/p>\n
  27:<\/span>         N'PREEMPTIVE_OS_FILEOPS'<\/span>, N'PREEMPTIVE_OS_DEVICEOPS'<\/span>,<\/pre>\n
<\/p>\n
  28:<\/span>         N'PWAIT_ALL_COMPONENTS_INITIALIZED'<\/span>, N'QDS_PERSIST_TASK_MAIN_LOOP_SLEEP'<\/span>,<\/pre>\n
<\/p>\n
  29:<\/span>         N'QDS_ASYNC_QUEUE'<\/span>,<\/pre>\n
<\/p>\n
  30:<\/span>         N'QDS_CLEANUP_STALE_QUERIES_TASK_MAIN_LOOP_SLEEP'<\/span>, N'REQUEST_FOR_DEADLOCK_SEARCH'<\/span>,<\/pre>\n
<\/p>\n
  31:<\/span>         N'RESOURCE_QUEUE'<\/span>, N'SERVER_IDLE_CHECK'<\/span>, N'SLEEP_BPOOL_FLUSH'<\/span>, N'SLEEP_DBSTARTUP'<\/span>,<\/pre>\n
<\/p>\n
  32:<\/span>         N'SLEEP_DCOMSTARTUP'<\/span>, N'SLEEP_MASTERDBREADY'<\/span>, N'SLEEP_MASTERMDREADY'<\/span>,<\/pre>\n
<\/p>\n
  33:<\/span>         N'SLEEP_MASTERUPGRADED'<\/span>, N'SLEEP_MSDBSTARTUP'<\/span>, N'SLEEP_SYSTEMTASK'<\/span>, N'SLEEP_TASK'<\/span>,<\/pre>\n
<\/p>\n
  34:<\/span>         N'SLEEP_TEMPDBSTARTUP'<\/span>, N'SNI_HTTP_ACCEPT'<\/span>, N'SP_SERVER_DIAGNOSTICS_SLEEP'<\/span>,<\/pre>\n
<\/p>\n
  35:<\/span>         N'SQLTRACE_BUFFER_FLUSH'<\/span>, N'SQLTRACE_INCREMENTAL_FLUSH_SLEEP'<\/span>, N'SQLTRACE_WAIT_ENTRIES'<\/span>,<\/pre>\n
<\/p>\n
  36:<\/span>         N'WAIT_FOR_RESULTS'<\/span>, N'WAITFOR'<\/span>, N'WAITFOR_TASKSHUTDOWN'<\/span>, N'WAIT_XTP_HOST_WAIT'<\/span>,<\/pre>\n
<\/p>\n
  37:<\/span>         N'WAIT_XTP_OFFLINE_CKPT_NEW_LOG'<\/span>, N'WAIT_XTP_CKPT_CLOSE'<\/span>, N'XE_DISPATCHER_JOIN'<\/span>,<\/pre>\n
<\/p>\n
  38:<\/span>         N'XE_DISPATCHER_WAIT'<\/span>, N'XE_LIVE_TARGET_TVF'<\/span>, N'XE_TIMER_EVENT'<\/span>)<\/pre>\n
<\/p>\n
  39:<\/span>     AND<\/span> waiting_tasks_count > 0)<\/pre>\n
<\/p>\n
  40:<\/span> SELECT<\/span><\/pre>\n
<\/p>\n
  41:<\/span>     MAX<\/span> (W1.wait_type) AS<\/span> [WaitType],<\/pre>\n
<\/p>\n
  42:<\/span>     CAST<\/span> (MAX<\/span> (W1.WaitS) AS<\/span> DECIMAL<\/span> (16,2)) AS<\/span> [Wait_Sec],<\/pre>\n
<\/p>\n
  43:<\/span>     CAST<\/span> (MAX<\/span> (W1.ResourceS) AS<\/span> DECIMAL<\/span> (16,2)) AS<\/span> [Resource_Sec],<\/pre>\n
<\/p>\n
  44:<\/span>     CAST<\/span> (MAX<\/span> (W1.SignalS) AS<\/span> DECIMAL<\/span> (16,2)) AS<\/span> [Signal_Sec],<\/pre>\n
<\/p>\n
  45:<\/span>     MAX<\/span> (W1.WaitCount) AS<\/span> [Wait Count<\/span>],<\/pre>\n
<\/p>\n
  46:<\/span>     CAST<\/span> (MAX<\/span> (W1.Percentage) AS<\/span> DECIMAL<\/span> (5,2)) AS<\/span> [Wait Percentage],<\/pre>\n
<\/p>\n
  47:<\/span>     CAST<\/span> ((MAX<\/span> (W1.WaitS) \/ MAX<\/span> (W1.WaitCount)) AS<\/span> DECIMAL<\/span> (16,4)) AS<\/span> [AvgWait_Sec],<\/pre>\n
<\/p>\n
  48:<\/span>     CAST<\/span> ((MAX<\/span> (W1.ResourceS) \/ MAX<\/span> (W1.WaitCount)) AS<\/span> DECIMAL<\/span> (16,4)) AS<\/span> [AvgRes_Sec],<\/pre>\n
<\/p>\n
  49:<\/span>     CAST<\/span> ((MAX<\/span> (W1.SignalS) \/ MAX<\/span> (W1.WaitCount)) AS<\/span> DECIMAL<\/span> (16,4)) AS<\/span> [AvgSig_Sec]<\/pre>\n
<\/p>\n
  50:<\/span> FROM<\/span> Waits AS<\/span> W1<\/pre>\n
<\/p>\n
  51:<\/span> INNER<\/span> JOIN<\/span> Waits AS<\/span> W2<\/pre>\n
<\/p>\n
  52:<\/span> ON<\/span> W2.RowNum <= W1.RowNum<\/pre>\n
<\/p>\n
  53:<\/span> GROUP<\/span> BY<\/span> W1.RowNum<\/pre>\n
<\/p>\n
  54:<\/span> HAVING<\/span> SUM<\/span> (W2.Percentage) - MAX<\/span> (W1.Percentage) < 99 -- percentage threshold<\/span><\/pre>\n
<\/p>\n
  55:<\/span> OPTION<\/span> (RECOMPILE);<\/pre>\n
<\/p>\n
  56:<\/span>  <\/pre>\n
<\/p>\n
  57:<\/span> -- Cumulative wait stats are not as useful on an idle instance that is not under load or performance pressure<\/span><\/pre>\n
<\/p>\n
  58:<\/span>  <\/pre>\n
<\/p>\n
  59:<\/span> -- The SQL Server Wait Type Repository<\/span><\/pre>\n
<\/p>\n
  60:<\/span> -- http:\/\/blogs.msdn.com\/b\/psssql\/archive\/2009\/11\/03\/the-sql-server-wait-type-repository.aspx<\/span><\/pre>\n
<\/p>\n
  61:<\/span>  <\/pre>\n
<\/p>\n
  62:<\/span> -- Wait statistics, or please tell me where it hurts<\/span><\/pre>\n
<\/p>\n
  63:<\/span> -- https:\/\/www.sqlskills.com\/blogs\/paul\/wait-statistics-or-please-tell-me-where-it-hurts\/<\/span><\/pre>\n
<\/p>\n
  64:<\/span>  <\/pre>\n
<\/p>\n
  65:<\/span> -- SQL Server 2005 Performance Tuning using the Waits and Queues<\/span><\/pre>\n
<\/p>\n
  66:<\/span> -- http:\/\/technet.microsoft.com\/en-us\/library\/cc966413.aspx<\/span><\/pre>\n
<\/p>\n
  67:<\/span>  <\/pre>\n
<\/p>\n
  68:<\/span> -- sys.dm_os_wait_stats (Transact-SQL)<\/span><\/pre>\n
<\/p>\n
  69:<\/span> -- http:\/\/msdn.microsoft.com\/en-us\/library\/ms179984(v=sql<\/span>.120).aspx<\/pre>\n
<\/div>\n<\/div>\n
Figure 1: Query #33 Top Waits<\/strong><\/p>\n
This query is can be very useful when your instance has been experiencing performance problems. At the same time, I have seen many DBAs spend way too much time agonizing about their top wait statistics when they don\u2019t need to. SQL Server will always be waiting on some type of resource (which is why I try to filter out what are generally considered to be benign wait types). If your instance is performing well, and nobody is complaining about performance, then you can relax a little bit.<\/p>\n
Another issue with the results of this query is that there is a lot of bad advice on the internet about what certain wait types mean and what, if anything, you should do if you see them. This often leads to what Paul Randal calls \u201cknee-jerk\u201d performance tuning<\/a>, where you see a certain wait type, and then immediately want to make some configuration change without doing any further investigation or putting any deeper thought into the matter.<\/p>\n
After all of those cautions, this query can be very useful in pointing you in one direction or another to do deeper investigation, especially when your instance has been performing poorly. If you do make any configuration changes, or do something else that might affect performance (such as adding an index), then it is a good idea to clear the wait statistics so that the old cumulative wait statistics don\u2019t obscure what is going on after the change.<\/p>\n
 <\/p>\n
Query #34<\/strong> is Connection Counts by IP Address. This query retrieves information from the sys.dm_exec_sessions<\/a> dynamic management view and the  sys.dm_exec_connections<\/a> dynamic management view about your current connection counts by IP address. Query #34 is shown in Figure 2.<\/p>\n
\n
\n
   1:<\/span> -- Get a count of SQL connections by IP address (Query 34) (Connection Counts by IP Address)<\/span><\/pre>\n
<\/p>\n
   2:<\/span> SELECT<\/span> ec.client_net_address, es.[program_name], es.[host_name], es.login_name, <\/pre>\n
<\/p>\n
   3:<\/span> COUNT<\/span>(ec.session_id) AS<\/span> [connection<\/span> count<\/span>] <\/pre>\n
<\/p>\n
   4:<\/span> FROM<\/span> sys.dm_exec_sessions AS<\/span> es WITH<\/span> (NOLOCK) <\/pre>\n
<\/p>\n
   5:<\/span> INNER<\/span> JOIN<\/span> sys.dm_exec_connections AS<\/span> ec WITH<\/span> (NOLOCK) <\/pre>\n
<\/p>\n
   6:<\/span> ON<\/span> es.session_id = ec.session_id <\/pre>\n
<\/p>\n
   7:<\/span> GROUP<\/span> BY<\/span> ec.client_net_address, es.[program_name], es.[host_name], es.login_name  <\/pre>\n
<\/p>\n
   8:<\/span> ORDER<\/span> BY<\/span> ec.client_net_address, es.[program_name] OPTION<\/span> (RECOMPILE);<\/pre>\n
<\/p>\n
   9:<\/span>  <\/pre>\n
<\/p>\n
  10:<\/span> -- This helps you figure where your database load is coming from<\/span><\/pre>\n
<\/p>\n
  11:<\/span> -- and<\/span> verifies connectivity from<\/span> other machines<\/pre>\n
<\/div>\n<\/div>\n
Figure 2: Query #34 Connection Counts by IP Address<\/strong><\/p>\n
This query helps you see the magnitude of your workload and judge whether it is in the normal range that you should be seeing. I think it is a good idea to have a baseline for how many connections your database server typically has from whatever other machines normally connect to it. This query can also help you confirm and troubleshoot connectivity issues from other machines. I can\u2019t tell you how many times that people have claimed my SQL Server instance was down because they could not connect to it. In the vast majority of cases, they simply had an incorrect connection string or there was a blocked port on their machine that prevented the connection. Remember, the database is always guilty until proven innocent!<\/p>\n","protected":false},"excerpt":{"rendered":"
For Day 14 of this series, we start out with Query #33, which is Top Waits. This query retrieves information from the sys.dm_os_wait_stats dynamic management view about the cumulative wait statistics for the instance since the last time it was restarted (or the wait statistics were manually cleared). Query #33 is shown in Figure 1. […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[273],"tags":[270],"class_list":["post-1037","post","type-post","status-publish","format-standard","hentry","category-dmv-diagnostic-queries-detailed","tag-sql-server-diagnostic-information-queries-detailed"],"yoast_head":"\nSQL Server Diagnostic Information Queries Detailed, Day 14 - Glenn Berry<\/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\/glenn\/sql-server-diagnostic-information-queries-detailed-day-14\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Diagnostic Information Queries Detailed, Day 14 - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"For Day 14 of this series, we start out with Query #33, which is Top Waits. This query retrieves information from the sys.dm_os_wait_stats dynamic management view about the cumulative wait statistics for the instance since the last time it was restarted (or the wait statistics were manually cleared). Query #33 is shown in Figure 1. […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-diagnostic-information-queries-detailed-day-14\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2016-01-14T15:37:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T19:28:48+00:00\" \/>\n<meta name=\"author\" content=\"Glenn Berry\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Glenn Berry\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-diagnostic-information-queries-detailed-day-14\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-diagnostic-information-queries-detailed-day-14\/\",\"name\":\"SQL Server Diagnostic Information Queries Detailed, Day 14 - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2016-01-14T15:37:16+00:00\",\"dateModified\":\"2017-04-13T19:28:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-diagnostic-information-queries-detailed-day-14\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-diagnostic-information-queries-detailed-day-14\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-diagnostic-information-queries-detailed-day-14\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Diagnostic Information Queries Detailed, Day 14\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\",\"name\":\"Glenn Berry\",\"description\":\"Semi-random musings about SQL Server performance\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/?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\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\",\"name\":\"Glenn Berry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"caption\":\"Glenn Berry\"},\"sameAs\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server Diagnostic Information Queries Detailed, Day 14 - Glenn Berry","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\/glenn\/sql-server-diagnostic-information-queries-detailed-day-14\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Diagnostic Information Queries Detailed, Day 14 - Glenn Berry","og_description":"For Day 14 of this series, we start out with Query #33, which is Top Waits. This query retrieves information from the sys.dm_os_wait_stats dynamic management view about the cumulative wait statistics for the instance since the last time it was restarted (or the wait statistics were manually cleared). Query #33 is shown in Figure 1. […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-diagnostic-information-queries-detailed-day-14\/","og_site_name":"Glenn Berry","article_published_time":"2016-01-14T15:37:16+00:00","article_modified_time":"2017-04-13T19:28:48+00:00","author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-diagnostic-information-queries-detailed-day-14\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-diagnostic-information-queries-detailed-day-14\/","name":"SQL Server Diagnostic Information Queries Detailed, Day 14 - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2016-01-14T15:37:16+00:00","dateModified":"2017-04-13T19:28:48+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-diagnostic-information-queries-detailed-day-14\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-diagnostic-information-queries-detailed-day-14\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-diagnostic-information-queries-detailed-day-14\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"SQL Server Diagnostic Information Queries Detailed, Day 14"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/","name":"Glenn Berry","description":"Semi-random musings about SQL Server performance","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/glenn\/?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\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7","name":"Glenn Berry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","caption":"Glenn Berry"},"sameAs":["https:\/\/www.sqlskills.com\/blogs\/glenn\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1037","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/comments?post=1037"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1037\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1037"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1037"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1037"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}