{"id":1864,"date":"2013-11-22T19:47:21","date_gmt":"2013-11-23T00:47:21","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/jonathan\/?p=1864"},"modified":"2013-11-22T20:20:39","modified_gmt":"2013-11-23T01:20:39","slug":"mapping-wait-types-in-dm_os_wait_stats-to-extended-events","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\/","title":{"rendered":"Mapping wait types in dm_os_wait_stats to Extended Events"},"content":{"rendered":"

A few months back I received an email from a member of the community that was trying to filter the sqlos.wait_info event for some of the wait types that are filtered out by Glenn’s diagnostic queries, and to their dismay wasn’t able to find the specific wait types in the wait_types map in sys.dm_xe_map_values.\u00a0 This scenario is something that I have long known about but never actually blogged about, though this blog post has been sitting in draft form since early 2012.\u00a0 Now that things have started to slow down at the end of this year I took a little time and built a spreadsheet of the wait_type names in sys.dm_os_wait_stats that don’t match exactly to the map_value in sys.dm_xe_map_values.<\/p>\n

I’d like to thank Bob Ward at Microsoft for taking the time to double check the spreadsheet I originally built for this blog post for accuracy and for the corrections on a few of the wait types he provided.\u00a0 The list of wait types below was generated from SQL Server 2012 Service Pack 1 + Cumulative Update 6.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

wait_type in sys.dm_os_wait_stats<\/p>\n<\/td>\n

\n

map_value in sys.dm_xe_map_values<\/p>\n<\/td>\n<\/tr>\n

ASYNC_NETWORK_IO<\/td>\nNETWORK_IO<\/td>\n<\/tr>\n
BROKER_TASK_STOP<\/td>\nSSB_TASK_STOP<\/td>\n<\/tr>\n
CLR_JOIN<\/td>\nCLR_TASK_JOIN<\/td>\n<\/tr>\n
CLR_MEMORY_SPY<\/td>\nCLR_MEMORY_SPY_ACCESS<\/td>\n<\/tr>\n
CREATE_DATINISERVICE<\/td>\nGET_DATINISERVICE<\/td>\n<\/tr>\n
DBCC_SCALE_OUT_EXPR_CACHE<\/td>\nCHECK_EXPRESSION_CACHE<\/td>\n<\/tr>\n
DBSTATE<\/td>\nDB_STATE<\/td>\n<\/tr>\n
DLL_LOADING_MUTEX<\/td>\nDLL_LOAD<\/td>\n<\/tr>\n
ERROR_REPORTING_MANAGER<\/td>\nERROR_REPORTING_MGR<\/td>\n<\/tr>\n
EXECUTION_PIPE_EVENT_INTERNAL<\/td>\nTWO_THREAD_PIPE_EVENT<\/td>\n<\/tr>\n
FS_FC_RWLOCK<\/td>\nFS_GC_RWLOCK<\/td>\n<\/tr>\n
FT_IFTS_RWLOCK<\/td>\nFT_RWLOCK<\/td>\n<\/tr>\n
FT_IFTS_SCHEDULER_IDLE_WAIT<\/td>\nFT_SCHEDULER_IDLE_WAIT<\/td>\n<\/tr>\n
FULLTEXT GATHERER<\/td>\nFULLTEXT_GATHERER<\/td>\n<\/tr>\n
HADR_ARCONTROLLER_NOTIFICATIONS_SUBSCRIBER_LIST<\/td>\nHADR_ARPROXY_NOTIFICATION_SUBSCRIBER_LIST<\/td>\n<\/tr>\n
HADR_DATABASE_FLOW_CONTROL<\/td>\nHADR_PARTNER_FLOW<\/td>\n<\/tr>\n
HADR_DATABASE_VERSIONING_STATE<\/td>\nHADR_VERSIONING_STATE<\/td>\n<\/tr>\n
HADR_DATABASE_WAIT_FOR_RESTART<\/td>\n__indexMUTEX_HADR_DATABASE_WAIT_FOR_RESTART<\/td>\n<\/tr>\n
HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING<\/td>\nHADR_WAIT_FOR_TRANSITION_TO_VERSIONING<\/td>\n<\/tr>\n
HADR_FILESTREAM_BLOCK_FLUSH<\/td>\nHADRFS_BLOCK_FLUSH<\/td>\n<\/tr>\n
HADR_FILESTREAM_FILE_CLOSE<\/td>\nHADRFS_FILE_CLOSE<\/td>\n<\/tr>\n
HADR_FILESTREAM_FILE_REQUEST<\/td>\nHADRFS_FILE_REQUEST<\/td>\n<\/tr>\n
HADR_FILESTREAM_IOMGR<\/td>\nHADRFS_IOMGR<\/td>\n<\/tr>\n
HADR_FILESTREAM_IOMGR_IOCOMPLETION<\/td>\nHADRFS_IOMGR_IOCOMPLETION<\/td>\n<\/tr>\n
HADR_FILESTREAM_MANAGER<\/td>\nHADRFS_MANAGER<\/td>\n<\/tr>\n
HADR_RECOVERY_WAIT_FOR_CONNECTION<\/td>\n__indexMUTEX_HADR_RECOVERY_WAIT_FOR_CONNECTION<\/td>\n<\/tr>\n
HADR_RECOVERY_WAIT_FOR_UNDO<\/td>\n__indexMUTEX_HADR_RECOVERY_WAIT_FOR_UNDO<\/td>\n<\/tr>\n
HADR_TRANSPORT_FLOW_CONTROL<\/td>\nHADR_TRANSPORT_FLOW<\/td>\n<\/tr>\n
HTBUILD<\/td>\nHASH_TABLE_BUILD<\/td>\n<\/tr>\n
HTREPARTITION<\/td>\nHASH_TABLE_REPARTITION<\/td>\n<\/tr>\n
INTERNAL_TESTING<\/td>\n <\/td>\n<\/tr>\n
LAZYWRITER_SLEEP<\/td>\nLZW_SLEEP<\/td>\n<\/tr>\n
MD_AGENT_YIELD<\/td>\nMETADATA_AGENT_YIELD<\/td>\n<\/tr>\n
MD_LAZYCACHE_RWLOCK<\/td>\nMETADATA_LAZYCACHE_RWLOCK<\/td>\n<\/tr>\n
MISCELLANEOUS<\/td>\nUNKNOWN<\/td>\n<\/tr>\n
MSSEARCH<\/td>\nMSSEARCH_COM<\/td>\n<\/tr>\n
PREEMPTIVE_FSRECOVER_UNCONDITIONALUNDO<\/td>\nPREEMPTIVE_FSRECOVER_CONDITIONALUNDO<\/td>\n<\/tr>\n
PREEMPTIVE_OS_SQMLAUNCH<\/td>\nPREEMPTIVE_SQMLAUNCH<\/td>\n<\/tr>\n
PWAIT_ALL_COMPONENTS_INITIALIZED<\/td>\nALL_COMPONENTS_INITIALIZED<\/td>\n<\/tr>\n
PWAIT_COOP_SCAN<\/td>\nCOOP_SCAN<\/td>\n<\/tr>\n
PWAIT_EVENT_SESSION_INIT_MUTEX<\/td>\nEVENT_SESSION_INIT_MUTEX<\/td>\n<\/tr>\n
PWAIT_HADR_ACTION_COMPLETED<\/td>\nHADR_ACTION_COMPLETED<\/td>\n<\/tr>\n
PWAIT_HADR_CHANGE_NOTIFIER_TERMINATION_SYNC<\/td>\nHADR_ARPROXY_NOTIFICATION_SUBSCRIBER_LIST<\/td>\n<\/tr>\n
PWAIT_HADR_CLUSTER_INTEGRATION<\/td>\nHADR_CHANGE_NOTIFIER_TERMINATION_SYNC<\/td>\n<\/tr>\n
PWAIT_HADR_FAILOVER_COMPLETED<\/td>\nHADR_CLUSTER_INTEGRATION<\/td>\n<\/tr>\n
PWAIT_HADR_OFFLINE_COMPLETED<\/td>\nHADR_FAILOVER_COMPLETED<\/td>\n<\/tr>\n
PWAIT_HADR_ONLINE_COMPLETED<\/td>\nHADR_OFFLINE_COMPLETED<\/td>\n<\/tr>\n
PWAIT_HADR_POST_ONLINE_COMPLETED<\/td>\nHADR_ONLINE_COMPLETED<\/td>\n<\/tr>\n
PWAIT_HADR_SERVER_READY_CONNECTIONS<\/td>\nHADR_SERVER_READY_CONNECTIONS<\/td>\n<\/tr>\n
PWAIT_HADR_WORKITEM_COMPLETED<\/td>\nHADR_WORKITEM_COMPLETED<\/td>\n<\/tr>\n
PWAIT_MD_LOGIN_STATS<\/td>\nMD_LOGIN_STATS<\/td>\n<\/tr>\n
PWAIT_MD_RELATION_CACHE<\/td>\nMD_RELATION_CACHE<\/td>\n<\/tr>\n
PWAIT_MD_SERVER_CACHE<\/td>\nMD_SERVER_CACHE<\/td>\n<\/tr>\n
PWAIT_MD_UPGRADE_CONFIG<\/td>\nMD_UPGRADE_CONFIG<\/td>\n<\/tr>\n
PWAIT_PREEMPTIVE_AUDIT_ACCESS_WINDOWSLOG<\/td>\nPREEMPTIVE_AUDIT_ACCESS_WINDOWSLOG<\/td>\n<\/tr>\n
PWAIT_QRY_BPMEMORY<\/td>\nQRY_BPMEMORY<\/td>\n<\/tr>\n
PWAIT_REPLICA_ONLINE_INIT_MUTEX<\/td>\nREPLICA_ONLINE_INIT_MUTEX<\/td>\n<\/tr>\n
PWAIT_RESOURCE_SEMAPHORE_FT_PARALLEL_QUERY_SYNC<\/td>\nRESOURCE_SEMAPHORE_FT_PARALLEL_QUERY_SYNC<\/td>\n<\/tr>\n
PWAIT_SECURITY_CACHE_INVALIDATION<\/td>\nSECURITY_CACHE_INVALIDATION<\/td>\n<\/tr>\n
QUERY_EXECUTION_INDEX_SORT_EVENT_OPEN<\/td>\nQUERY_EXEC_INDEXSORT_OPEN<\/td>\n<\/tr>\n
REDO_THREAD_PENDING_WORK<\/td>\nREDO_SIGNAL<\/td>\n<\/tr>\n
REDO_THREAD_SYNC<\/td>\nREDO_SYNC<\/td>\n<\/tr>\n
RESOURCE_GOVERNOR_IDLE<\/td>\n <\/td>\n<\/tr>\n
SCAN_CHAR_HASH_ARRAY_INITIALIZATION<\/td>\nSCAN_CHAR_HASH_ARRAY_INIT<\/td>\n<\/tr>\n
SERVER_IDLE_CHECK<\/td>\nSERVER_IDLE_LOCK<\/td>\n<\/tr>\n
SNI_LISTENER_ACCESS<\/td>\nLISTENER_UPDATE<\/td>\n<\/tr>\n
SNI_TASK_COMPLETION<\/td>\nSNI_WAIT_TASK_FINISH<\/td>\n<\/tr>\n
SP_PREEMPTIVE_SERVER_DIAGNOSTICS_SLEEP<\/td>\nPREEMPTIVE_SP_SERVER_DIAGNOSTICS_SLEEP<\/td>\n<\/tr>\n
THREADPOOL<\/td>\nSOS_WORKER<\/td>\n<\/tr>\n
TRAN_MARKLATCH_DT<\/td>\nTRANMARKLATCH_DT<\/td>\n<\/tr>\n
TRAN_MARKLATCH_EX<\/td>\nTRANMARKLATCH_EX<\/td>\n<\/tr>\n
TRAN_MARKLATCH_KP<\/td>\nTRANMARKLATCH_KP<\/td>\n<\/tr>\n
TRAN_MARKLATCH_NL<\/td>\nTRANMARKLATCH_NL<\/td>\n<\/tr>\n
TRAN_MARKLATCH_SH<\/td>\nTRANMARKLATCH_SH<\/td>\n<\/tr>\n
TRAN_MARKLATCH_UP<\/td>\nTRANMARKLATCH_UP<\/td>\n<\/tr>\n
VIA_ACCEPT<\/td>\nVIA_ACCEPT_DONE<\/td>\n<\/tr>\n
WAIT_XTP_GUEST<\/td>\nXTP_GUEST<\/td>\n<\/tr>\n
WAIT_XTP_TASK_SHUTDOWN<\/td>\nXTP_TASK_SHUTDOWN<\/td>\n<\/tr>\n
WAIT_XTP_TRAN_COMMIT<\/td>\nXTP_TRAN_COMMIT<\/td>\n<\/tr>\n
WAITFOR_TASKSHUTDOWN<\/td>\nTASKSHUTDOWN<\/td>\n<\/tr>\n
XE_CALLBACK_LIST<\/td>\nXE_CALLBACK<\/td>\n<\/tr>\n
XTPPROC_PARTITIONED_STACK_CREATE<\/td>\n__indexXTPPROC_PARTITIONED_STACK_CREATE<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

A few months back I received an email from a member of the community that was trying to filter the sqlos.wait_info event for some of the wait types that are filtered out by Glenn’s diagnostic queries, and to their dismay wasn’t able to find the specific wait types in the wait_types map in sys.dm_xe_map_values.\u00a0 This […]<\/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,39],"tags":[],"class_list":["post-1864","post","type-post","status-publish","format-standard","hentry","category-extended-events","category-sql-server-2008","category-sql-server-2012"],"yoast_head":"\nMapping wait types in dm_os_wait_stats to Extended Events - 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\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mapping wait types in dm_os_wait_stats to Extended Events - Jonathan Kehayias\" \/>\n<meta property=\"og:description\" content=\"A few months back I received an email from a member of the community that was trying to filter the sqlos.wait_info event for some of the wait types that are filtered out by Glenn’s diagnostic queries, and to their dismay wasn’t able to find the specific wait types in the wait_types map in sys.dm_xe_map_values.\u00a0 This […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\/\" \/>\n<meta property=\"og:site_name\" content=\"Jonathan Kehayias\" \/>\n<meta property=\"article:published_time\" content=\"2013-11-23T00:47:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-11-23T01:20:39+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=\"4 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\\\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\\\/\"},\"author\":{\"name\":\"Jonathan Kehayias\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"headline\":\"Mapping wait types in dm_os_wait_stats to Extended Events\",\"datePublished\":\"2013-11-23T00:47:21+00:00\",\"dateModified\":\"2013-11-23T01:20:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\\\/\"},\"wordCount\":760,\"commentCount\":4,\"articleSection\":[\"Extended Events\",\"SQL Server 2008\",\"SQL Server 2012\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\\\/\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\\\/\",\"name\":\"Mapping wait types in dm_os_wait_stats to Extended Events - Jonathan Kehayias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\"},\"datePublished\":\"2013-11-23T00:47:21+00:00\",\"dateModified\":\"2013-11-23T01:20:39+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\\\/#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\":\"Mapping wait types in dm_os_wait_stats to Extended Events\"}]},{\"@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":"Mapping wait types in dm_os_wait_stats to Extended Events - 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\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\/","og_locale":"en_US","og_type":"article","og_title":"Mapping wait types in dm_os_wait_stats to Extended Events - Jonathan Kehayias","og_description":"A few months back I received an email from a member of the community that was trying to filter the sqlos.wait_info event for some of the wait types that are filtered out by Glenn’s diagnostic queries, and to their dismay wasn’t able to find the specific wait types in the wait_types map in sys.dm_xe_map_values.\u00a0 This […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\/","og_site_name":"Jonathan Kehayias","article_published_time":"2013-11-23T00:47:21+00:00","article_modified_time":"2013-11-23T01:20:39+00:00","author":"Jonathan Kehayias","twitter_misc":{"Written by":"Jonathan Kehayias","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\/#article","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\/"},"author":{"name":"Jonathan Kehayias","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"headline":"Mapping wait types in dm_os_wait_stats to Extended Events","datePublished":"2013-11-23T00:47:21+00:00","dateModified":"2013-11-23T01:20:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\/"},"wordCount":760,"commentCount":4,"articleSection":["Extended Events","SQL Server 2008","SQL Server 2012"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\/","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\/","name":"Mapping wait types in dm_os_wait_stats to Extended Events - Jonathan Kehayias","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website"},"datePublished":"2013-11-23T00:47:21+00:00","dateModified":"2013-11-23T01:20:39+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/mapping-wait-types-in-dm_os_wait_stats-to-extended-events\/#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":"Mapping wait types in dm_os_wait_stats to Extended Events"}]},{"@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\/1864","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=1864"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/1864\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/media?parent=1864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/categories?post=1864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/tags?post=1864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}