April 16, 2015 at 8:06 pm
Hello,
Last year October we migrated to SQLserver 2014. And for the last two months we are noticing that full backups causing performance issues quite frequently. Certain queries that run during the backup time takes little longer than usual. And we don't observe this phenomenon other than the backup time.
And those queries are very light weighted. It hardly takes a second to run. But during the backup it takes about 10 seconds to execute.
Server has a memory of 384 GB ram and we configured 372 GB ram in the SQLserver maximum memory. Logical processors: 24. The server is running on cluster with San storage.
The database is 695360.00 MB in size and we use Ola backup scripts to take backup in a network share.
Reading through a lot of documents yesterday I find there could be something not correct with the SQLserver max memory settings.
Can you please check my configuration and comment if we could improve the situation.
Please let me know if you need any other information.
Thank you very much.
My Sys.configuration.
0 101 Maximum recovery interval in minutes 3
0 102 Allow updates to system tables 1
0 103 Number of user connections allowed 2
0 106 Number of locks for all users 2
0 107 Number of open database objects 2
0 109 Default fill factor percentage 2
0 114 Disallow returning results from triggers 3
1 115 Allow triggers to be invoked within triggers 1
1 116 Allow recursion for server level triggers 1
1 117 Allow remote access 0
0 124 default language 1
0 400 Allow cross db ownership chaining 1
0 503 Maximum worker threads 3
4096 505 Network packet size 3
1 518 show advanced options 1
0 542 Create DTC transaction for remote procedures 1
0 544 c2 audit mode 2
1033 1126 default full-text language 3
2049 1127 two digit year cutoff 3
0 1505 Memory for index create sorts (kBytes) 3
0 1517 Priority boost 2
10 1519 remote login timeout 1
600 1520 remote query timeout 1
-1 1531 cursor threshold 3
0 1532 set working set size 2
0 1534 user options 1
0 1535 affinity mask 3
65536 1536 Maximum size of a text field in replication. 1
0 1537 Tape retention period in days 3
5 1538 cost threshold for parallelism 3
0 1539 maximum degree of parallelism 3
1024 1540 minimum memory per query (kBytes) 3
-1 1541 maximum time to wait for query memory (s) 3
0 1543 Minimum size of server memory (MB) 3
380928 1544 Maximum size of server memory (MB) 3
0 1545 Maximum estimated cost allowed by query governor 3
0 1546 User mode scheduler uses lightweight pooling 2
0 1547 scan for startup stored procedures 2
0 1549 affinity64 mask 3
0 1550 affinity I/O mask 2
0 1551 affinity64 I/O mask 2
0 1555 Transform noise words for full-text query 3
0 1556 Use precomputed rank for full-text query 3
60 1557 DB connection timeout for full-text protocol handler (s) 3
0 1562 CLR user code execution enabled in the server 1
4 1563 Maximum crawl ranges allowed in full-text indexing 3
0 1564 Number of reserved full-text notifications buffers 3
100 1565 Max number of full-text notifications buffers 3
0 1566 Number of reserved full-text crawl buffers 3
100 1567 Max number of full-text crawl buffers 3
1 1568 Enable or disable the default trace 3
1 1569 Blocked process reporting threshold 3
0 1570 Recovery policy for DTC transactions with unknown outcome 3
1 1576 Dedicated Admin Connections are allowed from remote clients 1
0 1577 Common Criteria compliance mode enabled 2
0 1578 Enable or disable EKM provider 3
1 1579 Enable compression of backups by default 1
0 1580 Sets the FILESTREAM access level 1
0 1581 When this option is set, plan cache size is further reduced for single-use adhoc OLTP workload. 3
0 1582 Default hash bucket count for the access check result security cache 3
0 1583 Default quota for the access check result security cache 3
0 1584 Enable checksum of backups by default 1
1 16384 Enable or disable Agent XPs 3
1 16386 Enable or disable Database Mail XPs 3
1 16387 Enable or disable SMO and DMO XPs 3
0 16388 Enable or disable Ole Automation Procedures 3
0 16390 Enable or disable command shell 3
0 16391 Enable or disable Ad Hoc Distributed Queries 3
0 16392 Enable or disable Replication XPs 3
0 16393 Enables contained databases and contained authentication 1
select type, virtual_memory_reserved_kb,virtual_memory_committed_kb,awe_allocated_kb from sys.dm_os_memory_clerks
where virtual_memory_reserved_kb > 0
order by virtual_memory_reserved_kb desc
Results of the above query
MEMORYCLERK_SQLBUFFERPOOL 199630896 524288 8797512
MEMORYCLERK_SQLCLR 9450368 10212 0
MEMORYCLERK_SOSMEMMANAGER 1394380 1244876 149448
OBJECTSTORE_LOCK_MANAGER 1050624 1050624 0
MEMORYCLERK_SQLSTORENG 9792 0 9792
MEMORYCLERK_XE_BUFFER 5888 5888 0
MEMORYCLERK_XE_BUFFER 2944 2944 0
April 17, 2015 at 3:29 am
I guess that the culprit is network or disk load during the backup operation.
Which waits do you see during the backup operation?
Using sp_WhoIsActive (or querying directly sys.dm_exec_* DMVs), which wait do you see for the statements?
-- Gianluca Sartori
April 17, 2015 at 7:07 am
One setting I'd change immediately is the Cost Threshold for Parallelism. You have it at the default of 5. Change that to a reasonable number. You can look at your plans in cache and try either the mode or the median as a base and set it a little higher. Or, for just a rough number, on an OLTP system, 50, on a reporting style system, 25.
But, other than that, it's about wait statistics to understand where the slowdown is occurring as was already suggested.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 17, 2015 at 9:18 am
Grant Fritchey (4/17/2015)
One setting I'd change immediately is the Cost Threshold for Parallelism. You have it at the default of 5. Change that to a reasonable number. You can look at your plans in cache and try either the mode or the median as a base and set it a little higher. Or, for just a rough number, on an OLTP system, 50, on a reporting style system, 25.But, other than that, it's about wait statistics to understand where the slowdown is occurring as was already suggested.
Thank you for pointing out the cost threshold parallelism. Since this is production server I need approval from authorities.
For the wait statistics the information is here order by wait_time_ms desc.
Not to mention we collect sp_whoisactive every 5 minutes during the backup time. We have not seen anything obviously not correct. During the period where slowness there are lot of writelog wait_type. May be they are the symptoms not the actual root cause itself.
wait_type waiting_tasks_count wait_time_ms max_wait_time_ms signal_wait_time_ms
SP_SERVER_DIAGNOSTICS_SLEEP 7125897 5393996047 300009 5393996047
LAZYWRITER_SLEEP 882957602 5369309001 2015 5581247
CLR_AUTO_EVENT 60 5317189670 683862329 0
SLEEP_TASK 431480021 4046775833 5000 1612697
DISPATCHER_QUEUE_SEMAPHORE 24340384 2904218555 7192655 220797
QDS_PERSIST_TASK_MAIN_LOOP_SLEEP 44955 2697374948 60019 564
QDS_CLEANUP_STALE_QUERIES_TASK_MAIN_LOOP_SLEEP 44955 2697374212 60015 1022
DIRTY_PAGE_POLL 25645269 2697368989 296 29625
HADR_FILESTREAM_IOMGR_IOCOMPLETION 5389746 2697357940 526 32898
XE_DISPATCHER_WAIT 207885 2697297089 64999 0
XE_TIMER_EVENT 737273 2697233893 5187 2697228158
SQLTRACE_INCREMENTAL_FLUSH_SLEEP 674098 2696996216 4172 1282
REQUEST_FOR_DEADLOCK_SEARCH 2687678 2696072046 5010 2696072046
LOGMGR_QUEUE 582259880 2684832861 215 3462561
FT_IFTS_SCHEDULER_IDLE_WAIT 44583 2675052415 60018 579
BROKER_EVENTHANDLER 218 2663278164 80418650 3
CHECKPOINT_QUEUE 43828 2635392326 3892035 825
BROKER_TO_FLUSH 1311218 1348632581 1044 15151
WRITELOG 615569938 1335082732 6217 7634740
ASYNC_NETWORK_IO 187558183 262817225 40001 931975
PAGEIOLATCH_SH 34149496 221898038 10068 89443
BACKUPIO 48345345 185274180 23748 183405
BROKER_TASK_STOP 28180 153280481 10016 1029
BACKUPBUFFER 46064072 122624828 2073 371841
ASYNC_IO_COMPLETION 340 115906092 5751527 3
PAGEIOLATCH_EX 17255091 104964823 10035 49516
BACKUPTHREAD 48511 48492257 1483005 701
BROKER_RECEIVE_WAITFOR 140 41450077 599985 2
TRACEWRITE 1291950 40237343 2006 1557253
LATCH_SH 682208 11795747 219 276053
THREADPOOL 19618 6765366 2917 2
LOGBUFFER 64552 5255801 6201 12571
PAGEIOLATCH_UP 216146 4930732 9643 16713
CXPACKET 74139 4202010 33156 1198
SLEEP_BPOOL_FLUSH 5598226 2024349 45 42447
SOS_SCHEDULER_YIELD 51863093 1148271 214 1118358
PAGELATCH_EX 54465401 1088251 2341 558860
LCK_M_S 1263 673703 26982 53
PREEMPTIVE_OS_FILEOPS 25595 587409 19773 0
MSQL_XP 91056 419511 6445 0
PREEMPTIVE_OS_WRITEFILE 43377 391562 1053 0
PREEMPTIVE_XE_GETTARGETSTATE 144125 380925 263 0
LCK_M_IX 83216 313595 4502 1105
PREEMPTIVE_OS_AUTHENTICATIONOPS 2508483 226960 218 0
PREEMPTIVE_OS_GETFILEATTRIBUTES 29193 195546 1741 0
LCK_M_U 192 156326 10013 5
LATCH_EX 159197 149288 139 15923
PAGELATCH_UP 31288 115260 9505 1150
PAGELATCH_SH 1803906 86318 5927 19589
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY 476618 77827 245 0
PREEMPTIVE_OS_CRYPTOPS 1905092 77464 232 0
PREEMPTIVE_OS_CLOSEHANDLE 4990 58736 495 0
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT 477091 52559 17 0
PREEMPTIVE_OS_CREATEFILE 15237 50877 467 0
PREEMPTIVE_OS_GETVOLUMEPATHNAME 4120 48967 10304 0
WAITFOR 4 42326 30000 0
SLEEP_DBSTARTUP 276 27443 100 8
PREEMPTIVE_OS_AUTHORIZATIONOPS 659414 21778 20 0
PREEMPTIVE_OS_DELETESECURITYCONTEXT 654505 20065 672 0
LCK_M_X 86 16112 12922 12
PREEMPTIVE_SP_SERVER_DIAGNOSTICS 5 15105 5047 0
PREEMPTIVE_OS_FLUSHFILEBUFFERS 1673 13631 547 0
PREEMPTIVE_OS_CRYPTIMPORTKEY 478103 12714 18 0
PREEMPTIVE_OS_DECRYPTMESSAGE 654533 12660 24 0
IO_COMPLETION 29212 11893 314 44
WRITE_COMPLETION 17841 11567 20 26
LCK_M_SCH_M 3363 9670 73 751
SQLTRACE_FILE_READ_IO_COMPLETION 1696 8694 40 2
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE 476618 8383 26 0
PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT 4184 6441 10 0
PWAIT_ALL_COMPONENTS_INITIALIZED 4 6399 1603 0
PREEMPTIVE_OS_QUERYREGISTRY 44957 6390 65 0
IO_AUDIT_MUTEX 3381 4556 46 3706
SQLTRACE_FILE_BUFFER 463 2722 677 45
PREEMPTIVE_OS_REVERTTOSELF 182711 2229 12 0
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES 178606 2218 12 0
CHKPT 1 2148 2148 0
SLEEP_SYSTEMTASK 1 2147 2147 0
SLEEP_MASTERDBREADY 1 2135 2135 0
PREEMPTIVE_OS_GETDISKFREESPACE 4015 1776 4 0
CMEMTHREAD 10198 1616 11 1394
PREEMPTIVE_OS_LIBRARYOPS 1 1121 1121 0
PREEMPTIVE_OS_WAITFORSINGLEOBJECT 30281 926 129 0
PREEMPTIVE_XE_CALLBACKEXECUTE 546341 829 8 0
WAIT_XTP_HOST_WAIT 3 762 387 0
PREEMPTIVE_OS_LOADLIBRARY 35 729 46 0
PREEMPTIVE_OS_GENERICOPS 38 657 424 0
XE_BUFFERMGR_ALLPROCESSED_EVENT 40 613 563 6
SOS_PHYS_PAGE_CACHE 2021 613 6 142
FT_IFTSHC_MUTEX 4 569 568 0
PREEMPTIVE_OS_PIPEOPS 1 438 438 0
PREEMPTIVE_OS_COMOPS 1 337 337 0
EXECSYNC 675 325 4 202
PREEMPTIVE_OS_GETPROCADDRESS 91056 295 0 0
BACKUP 102 285 36 0
PREEMPTIVE_OS_LOOKUPACCOUNTSID 83 279 110 0
SQLTRACE_FILE_WRITE_IO_COMPLETION 42 234 13 0
SLEEP_DCOMSTARTUP 1 174 174 0
PREEMPTIVE_XE_TARGETINIT 11 117 75 0
PREEMPTIVE_OS_REPORTEVENT 368 110 16 0
FFT_RECOVERY 5 73 40 0
LOGMGR_FLUSH 16 61 12 0
PREEMPTIVE_OS_MOVEFILE 24 60 10 0
PREEMPTIVE_OS_DELETEFILE 10 56 22 0
PREEMPTIVE_OS_CLUSTEROPS 2 41 21 0
PREEMPTIVE_OS_WRITEFILEGATHER 7 37 10 0
PREEMPTIVE_OS_DOMAINSERVICESOPS 1 26 26 0
CLR_MANUAL_EVENT 20 26 2 0
DAC_INIT 1 26 26 0
XE_SERVICES_MUTEX 13 20 2 0
PREEMPTIVE_CLUSAPI_CLUSTERRESOURCECONTROL 87 20 3 0
QDS_TASK_START 2 19 19 0
PREEMPTIVE_FILESIZEGET 63 16 0 0
PREEMPTIVE_XE_SESSIONCOMMIT 26 9 8 0
PREEMPTIVE_OS_SETFILEVALIDDATA 6 8 1 0
PARALLEL_BACKUP_QUEUE 1297 6 0 5
PREEMPTIVE_OS_SQMLAUNCH 32 1 0 0
PREEMPTIVE_TESTING 0 0 0 0
PREEMPTIVE_SOSHOST 0 0 0 0
PREEMPTIVE_SOSTESTING 0 0 0 0
PREEMPTIVE_XETESTING 0 0 0 0
PREEMPTIVE_SB_STOPENDPOINT 1 0 0 0
PREEMPTIVE_STARTRM 0 0 0 0
PREEMPTIVE_GETRMINFO 0 0 0 0
PREEMPTIVE_SETRMINFO 0 0 0 0
PREEMPTIVE_ROLLFORWARDREDO 0 0 0 0
PREEMPTIVE_ROLLFORWARDUNDO 0 0 0 0
PREEMPTIVE_RESIZELOG 0 0 0 0
PREEMPTIVE_REENLIST 0 0 0 0
PREEMPTIVE_TRANSIMPORT 0 0 0 0
PREEMPTIVE_UNMARSHALPROPAGATIONTOKEN 0 0 0 0
PREEMPTIVE_CREATEPARAM 0 0 0 0
PREEMPTIVE_STREAMFCB_RECOVER 0 0 0 0
PREEMPTIVE_STREAMFCB_CHECKPOINT 0 0 0 0
PREEMPTIVE_CLOSEBACKUPMEDIA 0 0 0 0
PREEMPTIVE_CLOSEBACKUPTAPE 0 0 0 0
PREEMPTIVE_CLOSEBACKUPVDIDEVICE 0 0 0 0
PREEMPTIVE_OS_VSSOPS 0 0 0 0
PREEMPTIVE_VSS_CREATESNAPSHOT 0 0 0 0
PREEMPTIVE_VSS_CREATEVOLUMESNAPSHOT 0 0 0 0
PREEMPTIVE_DFSADDLINK 0 0 0 0
PREEMPTIVE_DFSLINKEXISTCHECK 0 0 0 0
PREEMPTIVE_DFSLINKHEALTHCHECK 0 0 0 0
PREEMPTIVE_DFSREMOVELINK 0 0 0 0
PREEMPTIVE_DFSREMOVEROOT 0 0 0 0
PREEMPTIVE_DFSROOTFOLDERCHECK 0 0 0 0
PREEMPTIVE_DFSROOTINIT 0 0 0 0
PREEMPTIVE_DFSROOTSHARECHECK 0 0 0 0
PREEMPTIVE_OLE_UNINIT 0 0 0 0
PREEMPTIVE_FSAOLEDB_ABORTTRANSACTION 0 0 0 0
PREEMPTIVE_FSAOLEDB_COMMITTRANSACTION 0 0 0 0
PREEMPTIVE_FSAOLEDB_STARTTRANSACTION 0 0 0 0
PREEMPTIVE_FSRECOVER_UNCONDITIONALUNDO 0 0 0 0
PREEMPTIVE_SERVER_STARTUP 0 0 0 0
PREEMPTIVE_SHAREDMEM_GETDATA 0 0 0 0
PREEMPTIVE_CONSOLEWRITE 0 0 0 0
PREEMPTIVE_OS_BACKUPREAD 0 0 0 0
PREEMPTIVE_OS_FREELIBRARY 0 0 0 0
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE 0 0 0 0
PREEMPTIVE_OS_PROCESSOPS 0 0 0 0
PREEMPTIVE_OS_SECURITYOPS 0 0 0 0
PREEMPTIVE_OS_SERVICEOPS 0 0 0 0
PREEMPTIVE_OS_SQLCLROPS 0 0 0 0
PREEMPTIVE_OS_WINSOCKOPS 0 0 0 0
PREEMPTIVE_OS_GETADDRINFO 0 0 0 0
PREEMPTIVE_OS_WSASETLASTERROR 0 0 0 0
PREEMPTIVE_OS_FORMATMESSAGE 0 0 0 0
PREEMPTIVE_OS_GETFILESIZE 0 0 0 0
PREEMPTIVE_OS_GETLONGPATHNAME 0 0 0 0
PREEMPTIVE_OS_OPENDIRECTORY 0 0 0 0
PREEMPTIVE_OS_REMOVEDIRECTORY 0 0 0 0
PREEMPTIVE_OS_SETENDOFFILE 0 0 0 0
PREEMPTIVE_OS_SETFILEPOINTER 0 0 0 0
PREEMPTIVE_OS_MESSAGEQUEUEOPS 0 0 0 0
PREEMPTIVE_ODBCOPS 0 0 0 0
PREEMPTIVE_OLEDBOPS 0 0 0 0
PREEMPTIVE_OLEDB_ABORTTRAN 0 0 0 0
PREEMPTIVE_OLEDB_ABORTORCOMMITTRAN 0 0 0 0
PREEMPTIVE_OLEDB_GETDATASOURCE 0 0 0 0
PREEMPTIVE_OLEDB_GETLITERALINFO 0 0 0 0
PREEMPTIVE_OLEDB_GETPROPERTIES 0 0 0 0
PREEMPTIVE_OLEDB_GETPROPERTYINFO 0 0 0 0
PREEMPTIVE_OLEDB_GETSCHEMALOCK 0 0 0 0
PREEMPTIVE_OLEDB_JOINTRANSACTION 0 0 0 0
PREEMPTIVE_OLEDB_RELEASE 0 0 0 0
PREEMPTIVE_OLEDB_SETPROPERTIES 0 0 0 0
PREEMPTIVE_OS_GETCOMPRESSEDFILESIZE 0 0 0 0
PREEMPTIVE_OS_DEVICEIOCONTROL 0 0 0 0
PREEMPTIVE_OS_FINDFILE 0 0 0 0
PREEMPTIVE_OS_SETNAMEDSECURITYINFO 0 0 0 0
PREEMPTIVE_OS_COPYFILE 0 0 0 0
PREEMPTIVE_OS_CREATEDIRECTORY 0 0 0 0
PREEMPTIVE_OS_DTCOPS 0 0 0 0
PREEMPTIVE_DTC_ABORT 0 0 0 0
PREEMPTIVE_DTC_ABORTREQUESTDONE 0 0 0 0
PREEMPTIVE_DTC_BEGINTRANSACTION 0 0 0 0
PREEMPTIVE_DTC_COMMITREQUESTDONE 0 0 0 0
PREEMPTIVE_DTC_ENLIST 0 0 0 0
PREEMPTIVE_DTC_PREPAREREQUESTDONE 0 0 0 0
PREEMPTIVE_OS_DEVICEOPS 0 0 0 0
PREEMPTIVE_OS_RSFXDEVICEOPS 0 0 0 0
PREEMPTIVE_OS_DIRSVC_NETWORKOPS 0 0 0 0
PREEMPTIVE_OS_DSGETDCNAME 0 0 0 0
PREEMPTIVE_OS_NETGROUPGETUSERS 0 0 0 0
PREEMPTIVE_OS_NETLOCALGROUPGETMEMBERS 0 0 0 0
PREEMPTIVE_OS_NETUSERGETGROUPS 0 0 0 0
PREEMPTIVE_OS_NETUSERGETLOCALGROUPS 0 0 0 0
PREEMPTIVE_OS_NETUSERMODALSGET 0 0 0 0
PREEMPTIVE_COM_COCREATEINSTANCE 0 0 0 0
PREEMPTIVE_COM_COGETCLASSOBJECT 0 0 0 0
PREEMPTIVE_COM_CREATEACCESSOR 0 0 0 0
PREEMPTIVE_COM_DELETEROWS 0 0 0 0
PREEMPTIVE_COM_GETCOMMANDTEXT 0 0 0 0
PREEMPTIVE_COM_GETDATA 0 0 0 0
PREEMPTIVE_COM_GETNEXTROWS 0 0 0 0
PREEMPTIVE_COM_GETRESULT 0 0 0 0
PREEMPTIVE_COM_GETROWSBYBOOKMARK 0 0 0 0
PREEMPTIVE_COM_LBFLUSH 0 0 0 0
PREEMPTIVE_COM_LBLOCKREGION 0 0 0 0
PREEMPTIVE_COM_LBREADAT 0 0 0 0
PREEMPTIVE_COM_LBSETSIZE 0 0 0 0
PREEMPTIVE_COM_LBSTAT 0 0 0 0
PREEMPTIVE_COM_LBUNLOCKREGION 0 0 0 0
PREEMPTIVE_COM_LBWRITEAT 0 0 0 0
PREEMPTIVE_COM_QUERYINTERFACE 0 0 0 0
PREEMPTIVE_COM_RELEASE 0 0 0 0
PREEMPTIVE_COM_RELEASEACCESSOR 0 0 0 0
PREEMPTIVE_COM_RELEASEROWS 0 0 0 0
PREEMPTIVE_COM_RELEASESESSION 0 0 0 0
PREEMPTIVE_COM_RESTARTPOSITION 0 0 0 0
PREEMPTIVE_COM_SEQSTRMREAD 0 0 0 0
PREEMPTIVE_COM_SEQSTRMREADANDWRITE 0 0 0 0
PREEMPTIVE_COM_SETDATAFAILURE 0 0 0 0
PREEMPTIVE_COM_SETPARAMETERINFO 0 0 0 0
PREEMPTIVE_COM_SETPARAMETERPROPERTIES 0 0 0 0
PREEMPTIVE_COM_STRMLOCKREGION 0 0 0 0
PREEMPTIVE_COM_STRMSEEKANDREAD 0 0 0 0
PREEMPTIVE_COM_STRMSEEKANDWRITE 0 0 0 0
PREEMPTIVE_COM_STRMSETSIZE 0 0 0 0
PREEMPTIVE_COM_STRMSTAT 0 0 0 0
PREEMPTIVE_COM_STRMUNLOCKREGION 0 0 0 0
PREEMPTIVE_XE_TARGETFINALIZE 6 0 0 0
PREEMPTIVE_XE_DISPATCHER 1 0 0 0
PREEMPTIVE_XE_ENGINEINIT 0 0 0 0
AUDIT_XE_SESSION_MGR 0 0 0 0
AUDIT_ON_DEMAND_TARGET_LOCK 0 0 0 0
PWAIT_PREEMPTIVE_AUDIT_ACCESS_WINDOWSLOG 0 0 0 0
AUDIT_LOGINCACHE_LOCK 0 0 0 0
AUDIT_GROUPCACHE_LOCK 0 0 0 0
FT_METADATA_MUTEX 0 0 0 0
PREEMPTIVE_XE_TIMERRUN 1 0 0 0
PREEMPTIVE_SNIOPEN 0 0 0 0
PREEMPTIVE_DEBUG 0 0 0 0
PREEMPTIVE_MSS_RELEASE 0 0 0 0
PREEMPTIVE_LOCKMONITOR 1 0 0 0
PREEMPTIVE_STRESSDRIVER 0 0 0 0
CLEAR_DB 0 0 0 0
PREEMPTIVE_ABR 0 0 0 0
LOGGENERATION 0 0 0 0
IO_RETRY 0 0 0 0
FT_IFTSISM_MUTEX 0 0 0 0
FT_IFTS_RWLOCK 0 0 0 0
FT_COMPROWSET_RWLOCK 0 0 0 0
FT_MASTER_MERGE 0 0 0 0
TRACE_EVTNOTIF 0 0 0 0
SOS_SMALL_PAGE_ALLOC 0 0 0 0
MD_LAZYCACHE_RWLOCK 0 0 0 0
MD_AGENT_YIELD 0 0 0 0
IOAFF_RANGE_QUEUE 0 0 0 0
REPL_HISTORYCACHE_ACCESS 0 0 0 0
REPL_TRANHASHTABLE_ACCESS 0 0 0 0
REPL_TRANTEXTINFO_ACCESS 0 0 0 0
REPL_TRANFSINFO_ACCESS 0 0 0 0
SERVER_RECONFIGURE 0 0 0 0
CHANGE_TRACKING_WAITFORCHANGES 0 0 0 0
PWAIT_MD_RELATION_CACHE 0 0 0 0
PWAIT_MD_SERVER_CACHE 0 0 0 0
PWAIT_MD_LOGIN_STATS 0 0 0 0
DISPATCHER_PRIORITY_QUEUE_SEMAPHORE 0 0 0 0
FT_PROPERTYLIST_CACHE 0 0 0 0
PERFORMANCE_COUNTERS_RWLOCK 2 0 0 0
SECURITY_KEYRING_RWLOCK 0 0 0 0
AM_INDBUILD_ALLOCATION 0 0 0 0
STARTUP_DEPENDENCY_MANAGER 0 0 0 0
PWAIT_SECURITY_CACHE_INVALIDATION 0 0 0 0
XDES_HISTORY 0 0 0 0
XDES_SNAPSHOT 0 0 0 0
FT_MASTER_MERGE_COORDINATOR 0 0 0 0
PWAIT_RESOURCE_SEMAPHORE_FT_PARALLEL_QUERY_SYNC 0 0 0 0
REDO_THREAD_PENDING_WORK 0 0 0 0
REDO_THREAD_SYNC 0 0 0 0
COUNTRECOVERYMGR 0 0 0 0
HADR_DB_COMMAND 0 0 0 0
HADR_TRANSPORT_SESSION 0 0 0 0
HADR_CLUSAPI_CALL 0 0 0 0
PWAIT_HADR_CHANGE_NOTIFIER_TERMINATION_SYNC 0 0 0 0
PWAIT_HADR_ACTION_COMPLETED 0 0 0 0
PWAIT_HADR_OFFLINE_COMPLETED 0 0 0 0
PWAIT_HADR_ONLINE_COMPLETED 0 0 0 0
PWAIT_HADR_FAILOVER_COMPLETED 0 0 0 0
PWAIT_HADR_WORKITEM_COMPLETED 0 0 0 0
HADR_WORK_POOL 0 0 0 0
HADR_WORK_QUEUE 0 0 0 0
HADR_LOGCAPTURE_SYNC 0 0 0 0
PWAIT_HADR_CLUSTER_INTEGRATION 0 0 0 0
LOGCAPTURE_LOGPOOLTRUNCPOINT 0 0 0 0
LOGPOOL_CACHESIZE 0 0 0 0
LOGPOOL_FREEPOOLS 0 0 0 0
LOGPOOL_REPLACEMENTSET 0 0 0 0
LOGPOOL_CONSUMERSET 0 0 0 0
LOGPOOL_MGRSET 0 0 0 0
LOGPOOL_CONSUMER 0 0 0 0
LOGPOOLREFCOUNTEDOBJECT_REFDONE 0 0 0 0
HADR_SYNC_COMMIT 0 0 0 0
HADR_AG_MUTEX 0 0 0 0
PWAIT_HADR_SERVER_READY_CONNECTIONS 0 0 0 0
HADR_FILESTREAM_MANAGER 0 0 0 0
HADR_FILESTREAM_BLOCK_FLUSH 0 0 0 0
HADR_FILESTREAM_IOMGR 0 0 0 0
FFT_NSO_FCB 0 0 0 0
FFT_NSO_FCB_PARENT 0 0 0 0
FFT_NSO_FCB_FIND 0 0 0 0
FFT_NSO_FCB_RELEASE_CACHED_ENTRIES 0 0 0 0
FFT_NSO_FILEOBJECT 0 0 0 0
FFT_NSO_DB_LIST 0 0 0 0
FFT_NSO_DB_KILL_FLAG 0 0 0 0
FFT_NSO_TABLE_LIST 0 0 0 0
FFT_STORE_DB 0 0 0 0
FFT_STORE_TABLE 0 0 0 0
FFT_STORE_ROWSET_LIST 0 0 0 0
FFT_NTFS_STORE 0 0 0 0
HADR_FILESTREAM_FILE_REQUEST 0 0 0 0
PWAIT_MD_UPGRADE_CONFIG 0 0 0 0
PWAIT_COOP_SCAN 0 0 0 0
QRY_PARALLEL_THREAD_MUTEX 0 0 0 0
PWAIT_QRY_BPMEMORY 0 0 0 0
WAITFOR_PER_QUEUE 0 0 0 0
CREATE_DATINISERVICE 0 0 0 0
AM_SCHEMAMGR_UNSHARED_CACHE 0 0 0 0
HADR_REPLICAINFO_SYNC 0 0 0 0
HADR_COMPRESSED_CACHE_SYNC 0 0 0 0
HADR_AR_MANAGER_MUTEX 0 0 0 0
HADR_NOTIFICATION_WORKER_TERMINATION_SYNC 0 0 0 0
HADR_NOTIFICATION_DEQUEUE 0 0 0 0
HADR_ARCONTROLLER_NOTIFICATIONS_SUBSCRIBER_LIST 0 0 0 0
HADR_DBR_SUBSCRIBER_FILTER_LIST 0 0 0 0
HADR_DBR_SUBSCRIBER 0 0 0 0
HADR_NOTIFICATION_WORKER_STARTUP_SYNC 0 0 0 0
HADR_NOTIFICATION_WORKER_EXCLUSIVE_ACCESS 0 0 0 0
HADR_RECOVERY_WAIT_FOR_UNDO 0 0 0 0
HADR_DATABASE_WAIT_FOR_RESTART 0 0 0 0
HADR_XRF_STACK_ACCESS 0 0 0 0
HADR_RECOVERY_WAIT_FOR_CONNECTION 0 0 0 0
HADR_TRANSPORT_FLOW_CONTROL 0 0 0 0
HADR_DATABASE_FLOW_CONTROL 0 0 0 0
PWAIT_HADR_POST_ONLINE_COMPLETED 0 0 0 0
HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING 0 0 0 0
XDES_OUT_OF_ORDER_LIST 0 0 0 0
HADR_BACKUP_BULK_LOCK 0 0 0 0
HADR_BACKUP_QUEUE 0 0 0 0
HADR_LOGCAPTURE_WAIT 0 0 0 0
HADR_AR_CRITICAL_SECTION_ENTRY 0 0 0 0
HADR_TDS_LISTENER_SYNC 0 0 0 0
HADR_READ_ALL_NETWORKS 0 0 0 0
HADR_TDS_LISTENER_SYNC_PROCESSING 0 0 0 0
PWAIT_XTP_FSSTORAGE_MAINTENANCE 0 0 0 0
WAIT_XTP_GUEST 0 0 0 0
WAIT_XTP_TASK_SHUTDOWN 0 0 0 0
XTPPROC_PARTITIONED_STACK_CREATE 0 0 0 0
PREEMPTIVE_HADR_LEASE_MECHANISM 0 0 0 0
HADR_TIMER_TASK 0 0 0 0
PWAIT_EVENT_SESSION_INIT_MUTEX 0 0 0 0
PWAIT_REPLICA_ONLINE_INIT_MUTEX 0 0 0 0
HADR_GROUP_COMMIT 0 0 0 0
HADR_SYNCHRONIZING_THROTTLE 0 0 0 0
HADR_DATABASE_VERSIONING_STATE 0 0 0 0
XTPPROC_CACHE_ACCESS 0 0 0 0
SP_SERVER_DIAGNOSTICS_BUFFER_ACCESS 0 0 0 0
RESOURCE_GOVERNOR_IDLE 0 0 0 0
HADR_FILESTREAM_FILE_CLOSE 0 0 0 0
VERSIONING_COMMITTING 0 0 0 0
FILETABLE_SHUTDOWN 0 0 0 0
PRU_ROLLBACK_DEFERRED 0 0 0 0
WAIT_XTP_TRAN_DEPENDENCY 0 0 0 0
DUMP_LOG_COORDINATOR_QUEUE 0 0 0 0
LOWFAIL_MEMMGR_QUEUE 0 0 0 0
ONDEMAND_TASK_QUEUE 1 0 0 0
SOS_VIRTUALMEMORY_LOW 0 0 0 0
SOS_CALLBACK_REMOVAL 0 0 0 0
SOS_MEMORY_TOPLEVELBLOCKALLOCATOR 0 0 0 0
DEBUG 0 0 0 0
REPLICA_WRITES 0 0 0 0
DBMIRRORING_CMD 0 0 0 0
WAIT_FOR_RESULTS 0 0 0 0
DBMIRROR_DBM_MUTEX 0 0 0 0
DBMIRROR_DBM_EVENT 0 0 0 0
DBMIRROR_SEND 0 0 0 0
DBMIRROR_EVENTS_QUEUE 0 0 0 0
DBMIRROR_WORKER_QUEUE 0 0 0 0
HTTP_START 0 0 0 0
HTTP_ENUMERATION 0 0 0 0
SOAP_READ 0 0 0 0
SOAP_WRITE 0 0 0 0
DUMP_LOG_COORDINATOR 0 0 0 0
DISKIO_SUSPEND 0 0 0 0
IMPPROV_IOWAIT 0 0 0 0
DEADLOCK_TASK_SEARCH 0 0 0 0
REPL_SCHEMA_ACCESS 0 0 0 0
REPL_CACHE_ACCESS 0 0 0 0
KSOURCE_WAKEUP 1 0 0 0
SQLSORT_SORTMUTEX 0 0 0 0
SQLSORT_NORMMUTEX 0 0 0 0
SQLTRACE_WAIT_ENTRIES 0 0 0 0
FCB_REPLICA_WRITE 0 0 0 0
FCB_REPLICA_READ 0 0 0 0
EXCHANGE 0 0 0 0
EC 0 0 0 0
TEMPOBJ 0 0 0 0
XACTLOCKINFO 0 0 0 0
LOGMGR 0 0 0 0
SQLTRACE_SHUTDOWN 0 0 0 0
QUERY_TRACEOUT 0 0 0 0
DTC_STATE 0 0 0 0
BROKER_TRANSMITTER 2 0 0 0
BROKER_SERVICE 0 0 0 0
BROKER_SHUTDOWN 0 0 0 0
BROKER_MASTERSTART 1 0 0 0
BROKER_REGISTERALLENDPOINTS 0 0 0 0
DTCPNTSYNC 0 0 0 0
SOSHOST_INTERNAL 0 0 0 0
SOSHOST_SLEEP 0 0 0 0
SOSHOST_WAITFORDONE 0 0 0 0
SOSHOST_MUTEX 0 0 0 0
SOSHOST_EVENT 0 0 0 0
SOSHOST_SEMAPHORE 0 0 0 0
SOSHOST_RWLOCK 0 0 0 0
SOSHOST_TRACELOCK 0 0 0 0
HTREPARTITION 0 0 0 0
HTBUILD 0 0 0 0
HTMEMO 0 0 0 0
HTDELETE 0 0 0 0
HTREINIT 0 0 0 0
BMPREPARTITION 0 0 0 0
BMPALLOCATION 0 0 0 0
BMPREPLICATION 0 0 0 0
BMPBUILD 0 0 0 0
SHUTDOWN 0 0 0 0
SLEEP_TEMPDBSTARTUP 0 0 0 0
DBSTATE 0 0 0 0
SLEEP_MASTERMDREADY 0 0 0 0
SLEEP_MASTERUPGRADED 0 0 0 0
RESOURCE_SEMAPHORE 0 0 0 0
DTC 0 0 0 0
OLEDB 0 0 0 0
FAILPOINT 0 0 0 0
RESOURCE_QUEUE 0 0 0 0
ASYNC_DISKPOOL_LOCK 1 0 0 0
PAGEIOLATCH_DT 0 0 0 0
TRAN_MARKLATCH_NL 0 0 0 0
TRAN_MARKLATCH_KP 0 0 0 0
TRAN_MARKLATCH_SH 0 0 0 0
TRAN_MARKLATCH_UP 0 0 0 0
TRAN_MARKLATCH_EX 0 0 0 0
TRAN_MARKLATCH_DT 0 0 0 0
LCK_M_IS 0 0 0 0
LCK_M_IU 0 0 0 0
LATCH_UP 0 0 0 0
MISCELLANEOUS 0 0 0 0
LCK_M_SCH_S 0 0 0 0
LATCH_DT 0 0 0 0
PAGELATCH_NL 0 0 0 0
PAGELATCH_KP 0 0 0 0
PAGELATCH_DT 0 0 0 0
PAGEIOLATCH_NL 0 0 0 0
PAGEIOLATCH_KP 0 0 0 0
LCK_M_SIU 0 0 0 0
LCK_M_SIX 0 0 0 0
LCK_M_UIX 0 0 0 0
LCK_M_BU 0 0 0 0
LCK_M_RS_S 0 0 0 0
LCK_M_RS_U 0 0 0 0
LCK_M_RIn_NL 0 0 0 0
LCK_M_RIn_S 0 0 0 0
LCK_M_RIn_U 0 0 0 0
LCK_M_RIn_X 0 0 0 0
LCK_M_RX_S 0 0 0 0
LCK_M_RX_U 0 0 0 0
LCK_M_RX_X 0 0 0 0
LATCH_NL 0 0 0 0
LATCH_KP 0 0 0 0
XE_SERVICES_RWLOCK 0 0 0 0
XE_SERVICES_EVENTMANUAL 0 0 0 0
XE_OLS_LOCK 0 0 0 0
SOS_DISPATCHER_MUTEX 0 0 0 0
XE_BUFFERMGR_FREEBUF_EVENT 0 0 0 0
XE_MODULEMGR_SYNC 0 0 0 0
XE_STM_CREATE 0 0 0 0
XE_SESSION_SYNC 0 0 0 0
XE_SESSION_CREATE_SYNC 0 0 0 0
BROKER_TASK_SHUTDOWN 0 0 0 0
BROKER_TASK_SUBMIT 0 0 0 0
SNI_TASK_COMPLETION 1 0 0 0
SNI_LISTENER_ACCESS 0 0 0 0
EXECUTION_PIPE_EVENT_INTERNAL 0 0 0 0
CLR_MEMORY_SPY 0 0 0 0
CLRHOST_STATE_ACCESS 0 0 0 0
ASSEMBLY_LOAD 0 0 0 0
VIA_ACCEPT 0 0 0 0
CHECK_PRINT_RECORD 0 0 0 0
INTERNAL_TESTING 0 0 0 0
SCAN_CHAR_HASH_ARRAY_INITIALIZATION 0 0 0 0
FS_GARBAGE_COLLECTOR_SHUTDOWN 0 0 0 0
FSAGENT 0 0 0 0
FILESTREAM_WORKITEM_QUEUE 0 0 0 0
FILESTREAM_FILE_OBJECT 0 0 0 0
FILESTREAM_FCB 0 0 0 0
FILESTREAM_CACHE 0 0 0 0
ABR 0 0 0 0
WCC 0 0 0 0
DUMPTRIGGER 0 0 0 0
TIMEPRIV_TIMEPERIOD 0 0 0 0
PREEMPTIVE_OS_VERIFYSIGNATURE 0 0 0 0
PREEMPTIVE_OS_AUTHZGETINFORMATIONFROMCONTEXT 0 0 0 0
PREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSID 0 0 0 0
PREEMPTIVE_OS_AUTHZINITIALIZERESOURCEMANAGER 0 0 0 0
PREEMPTIVE_OS_ENCRYPTMESSAGE 0 0 0 0
PREEMPTIVE_OS_FREECREDENTIALSHANDLE 0 0 0 0
PREEMPTIVE_OS_INITIALIZESECURITYCONTEXT 0 0 0 0
PREEMPTIVE_OS_LOGONUSER 0 0 0 0
PREEMPTIVE_OS_QUERYSECURITYCONTEXTTOKEN 0 0 0 0
PREEMPTIVE_OS_ACCEPTSECURITYCONTEXT 0 0 0 0
PREEMPTIVE_OS_ACQUIRECREDENTIALSHANDLE 0 0 0 0
PREEMPTIVE_OS_COMPLETEAUTHTOKEN 0 0 0 0
XE_DISPATCHER_JOIN 0 0 0 0
XE_TIMER_MUTEX 0 0 0 0
XE_TIMER_TASK_DONE 0 0 0 0
XE_DISPATCHER_CONFIG_SESSION_LIST 0 0 0 0
XE_SESSION_FLUSH 0 0 0 0
XE_CALLBACK_LIST 0 0 0 0
NODE_CACHE_MUTEX 0 0 0 0
RG_RECONFIG 0 0 0 0
RESMGR_THROTTLED 0 0 0 0
SOS_MEMORY_USAGE_ADJUSTMENT 0 0 0 0
SECURITY_MUTEX 0 0 0 0
FS_HEADER_RWLOCK 0 0 0 0
FS_LOGTRUNC_RWLOCK 0 0 0 0
FS_FC_RWLOCK 0 0 0 0
FSTR_CONFIG_RWLOCK 0 0 0 0
FSTR_CONFIG_MUTEX 0 0 0 0
FSA_FORCE_OWN_XACT 0 0 0 0
COMMIT_TABLE 0 0 0 0
CXROWSET_SYNC 2 0 0 0
XACT_OWN_TRANSACTION 0 0 0 0
XACT_RECLAIM_SESSION 0 0 0 0
DTC_WAITFOR_OUTCOME 0 0 0 0
DTC_RESOLVE 0 0 0 0
SEC_DROP_TEMP_KEY 0 0 0 0
SRVPROC_SHUTDOWN 0 0 0 0
BROKER_INIT 0 0 0 0
BROKER_CONNECTION_RECEIVE_TASK 0 0 0 0
NET_WAITFOR_PACKET 0 0 0 0
DTC_ABORT_REQUEST 0 0 0 0
DTC_TMDOWN_REQUEST 0 0 0 0
RECOVER_CHANGEDB 0 0 0 0
WORKTBL_DROP 0 0 0 0
SNI_HTTP_WAITFOR_0_DISCON 0 0 0 0
UTIL_PAGE_ALLOC 0 0 0 0
SERVER_IDLE_CHECK 0 0 0 0
DEADLOCK_ENUM_MUTEX 0 0 0 0
VIEW_DEFINITION_MUTEX 0 0 0 0
QUERY_NOTIFICATION_MGR_MUTEX 0 0 0 0
QUERY_NOTIFICATION_TABLE_MGR_MUTEX 0 0 0 0
QUERY_NOTIFICATION_SUBSCRIPTION_MUTEX 0 0 0 0
QUERY_NOTIFICATION_UNITTEST_MUTEX 0 0 0 0
RESOURCE_SEMAPHORE_MUTEX 0 0 0 0
BUILTIN_HASHKEY_MUTEX 0 0 0 0
SOS_PROCESS_AFFINITY_MUTEX 3 0 0 0
MSQL_XACT_MGR_MUTEX 0 0 0 0
MSQL_XACT_MUTEX 0 0 0 0
QRY_MEM_GRANT_INFO_MUTEX 0 0 0 0
SNI_CRITICAL_SECTION 6 0 0 0
SOS_STACKSTORE_INIT_MUTEX 0 0 0 0
SOS_SYNC_TASK_ENQUEUE_EVENT 2 0 0 0
SOS_OBJECT_STORE_DESTROY_MUTEX 0 0 0 0
EE_PMOLOCK 0 0 0 0
QUERY_OPTIMIZER_PRINT_MUTEX 0 0 0 0
DLL_LOADING_MUTEX 0 0 0 0
RESOURCE_SEMAPHORE_QUERY_COMPILE 0 0 0 0
BROKER_ENDPOINT_STATE_MUTEX 0 0 0 0
QUERY_EXECUTION_INDEX_SORT_EVENT_OPEN 0 0 0 0
ERROR_REPORTING_MANAGER 0 0 0 0
EE_SPECPROC_MAP_INIT 0 0 0 0
FULLTEXT GATHERER 0 0 0 0
SEQUENTIAL_GUID 0 0 0 0
MSQL_DQ 0 0 0 0
TRANSACTION_MUTEX 0 0 0 0
SLEEP_MSDBSTARTUP 0 0 0 0
MSSEARCH 0 0 0 0
XACTWORKSPACE_MUTEX 0 0 0 0
WAITSTAT_MUTEX 3 0 0 0
WAITFOR_TASKSHUTDOWN 0 0 0 0
GUARDIAN 0 0 0 0
CLR_TASK_START 0 0 0 0
CLR_JOIN 0 0 0 0
CLR_CRST 0 0 0 0
CLR_SEMAPHORE 0 0 0 0
CLR_MONITOR 0 0 0 0
CLR_RWLOCK_READER 0 0 0 0
CLR_RWLOCK_WRITER 0 0 0 0
SQLCLR_QUANTUM_PUNISHMENT 0 0 0 0
SQLCLR_APPDOMAIN 0 0 0 0
SQLCLR_ASSEMBLY 0 0 0 0
KTM_ENLISTMENT 0 0 0 0
KTM_RECOVERY_RESOLUTION 0 0 0 0
KTM_RECOVERY_MANAGER 0 0 0 0
SQLCLR_DEADLOCK_DETECTION 0 0 0 0
QPJOB_WAITFOR_ABORT 0 0 0 0
QPJOB_KILL 0 0 0 0
BAD_PAGE_PROCESS 0 0 0 0
BACKUP_OPERATOR 0 0 0 0
PRINT_ROLLBACK_PROGRESS 0 0 0 0
ENABLE_VERSIONING 0 0 0 0
DISABLE_VERSIONING 0 0 0 0
REQUEST_DISPENSER_PAUSE 0 0 0 0
DROPTEMP 0 0 0 0
FT_RESTART_CRAWL 0 0 0 0
LOGMGR_RESERVE_APPEND 0 0 0 0
XE_LIVE_TARGET_TVF 0 0 0 0
QDS_TASK_SHUTDOWN 0 0 0 0
QDS_SHUTDOWN_QUEUE 0 0 0 0
PREEMPTIVE_XE_CX_FILE_OPEN 0 0 0 0
XE_CX_FILE_READ 0 0 0 0
WINFAB_API_CALL 0 0 0 0
PREEMPTIVE_XE_CX_HTTP_CALL 0 0 0 0
PWAIT_LOG_CONSOLIDATION_POLL 0 0 0 0
PWAIT_LOG_CONSOLIDATION_IO 0 0 0 0
COLUMNSTORE_BUILD_THROTTLE 0 0 0 0
DBSEEDING_OPERATION 0 0 0 0
DBSEEDING_FLOWCONTROL 0 0 0 0
PHYSICAL_SEEDING_DMV 0 0 0 0
DROP_DATABASE_TIMER_TASK 0 0 0 0
SNI_CONN_DUP 0 0 0 0
SEQUENCE_GENERATION 0 0 0 0
RTDATA_LIST 0 0 0 0
PWAIT_HADR_JOIN 0 0 0 0
WINFAB_REPLICA_BUILD_OPERATION 0 0 0 0
FABRIC_REPLICA_PUBLISHER_EVENT_PUBLISH 0 0 0 0
SQLTRACE_PENDING_BUFFER_WRITERS 0 0 0 0
PREEMPTIVE_OS_PDH_WMI_INIT 0 0 0 0
BROKER_TRANSMISSION_WORK 5 0 0 0
BROKER_TRANSMISSION_OBJECT 0 0 0 0
BROKER_TRANSMISSION_TABLE 1 0 0 0
BROKER_DISPATCHER 0 0 0 0
BROKER_FORWARDER 0 0 0 0
UCS_MANAGER 0 0 0 0
UCS_TRANSPORT 0 0 0 0
UCS_MEMORY_NOTIFICATION 0 0 0 0
UCS_ENDPOINT_CHANGE 0 0 0 0
UCS_TRANSPORT_STREAM_CHANGE 0 0 0 0
QUERY_TASK_ENQUEUE_MUTEX 0 0 0 0
SP_PREEMPTIVE_SERVER_DIAGNOSTICS_SLEEP 0 0 0 0
SP_SERVER_DIAGNOSTICS_INIT_MUTEX 0 0 0 0
DBCC_SCALE_OUT_EXPR_CACHE 0 0 0 0
GDMA_GET_RESOURCE_OWNER 0 0 0 0
UCS_SESSION_REGISTRATION 0 0 0 0
ENABLE_EMPTY_VERSIONING 0 0 0 0
HADR_DB_OP_START_SYNC 0 0 0 0
HADR_DB_OP_COMPLETION_SYNC 0 0 0 0
HADR_LOGPROGRESS_SYNC 0 0 0 0
HADR_TRANSPORT_DBRLIST 0 0 0 0
HADR_CONNECTIVITY_INFO 0 0 0 0
XDESTSVERMGR 0 0 0 0
GHOSTCLEANUPSYNCMGR 0 0 0 0
HADR_AR_UNLOAD_COMPLETED 0 0 0 0
HADR_PARTNER_SYNC 0 0 0 0
HADR_DBSTATECHANGE_SYNC 0 0 0 0
DIRTY_PAGE_SYNC 0 0 0 0
HTTP_STORAGE_CONNECTION 0 0 0 0
SECURITY_CRYPTO_CONTEXT_MUTEX 0 0 0 0
SECURITY_RULETABLE_MUTEX 0 0 0 0
SEMPLAT_DSI_BUILD 0 0 0 0
FILESTREAM_CHUNKER_INIT 0 0 0 0
FILESTREAM_CHUNKER 0 0 0 0
FFT_RSFX_COMM 0 0 0 0
FFT_RSFX_WAIT_FOR_MEMORY 0 0 0 0
FFT_STARTUP_SHUTDOWN 0 0 0 0
PWAIT_XTP_HOST_STORAGE_WAIT 0 0 0 0
HADR_FABRIC_CALLBACK 0 0 0 0
ASYNC_OP_CONTEXT_READ 0 0 0 0
ASYNC_OP_CONTEXT_WRITE 0 0 0 0
ASYNC_OP_COMPLETION 0 0 0 0
FABRIC_REPLICA_PUBLISHER_SUBSCRIBER_LIST 0 0 0 0
FABRIC_REPLICA_CONTROLLER_STATE_AND_CONFIG 0 0 0 0
FABRIC_REPLICA_CONTROLLER_LIST 0 0 0 0
FABRIC_HADR_TRANSPORT_CONNECTION 0 0 0 0
FABRIC_WAIT_FOR_BUILD_REPLICA_EVENT_PROCESSING 0 0 0 0
VDI_CLIENT_GETCOMMAND 0 0 0 0
VDI_CLIENT_COMPLETECOMMAND 0 0 0 0
VDI_CLIENT_OTHER 0 0 0 0
VDI_CLIENT_OPERATION 0 0 0 0
HADR_DBSEEDING 0 0 0 0
HADR_DBSEEDING_LIST 0 0 0 0
SLO_UPDATE 0 0 0 0
WAIT_XTP_RECOVERY 0 0 0 0
WAIT_XTP_OFFLINE_CKPT_NEW_LOG 0 0 0 0
WAIT_XTP_OFFLINE_CKPT_LOG_IO 0 0 0 0
WAIT_XTP_OFFLINE_CKPT_BEFORE_REDO 0 0 0 0
WAIT_XTP_PROCEDURE_ENTRY 0 0 0 0
WAIT_XTP_CKPT_ENABLED 0 0 0 0
WAIT_XTP_CKPT_AGENT_WAKEUP 0 0 0 0
WAIT_XTP_CKPT_CLOSE 0 0 0 0
WAIT_XTP_CKPT_STATE_LOCK 0 0 0 0
WAIT_XTP_ASYNC_TX_COMPLETION 0 0 0 0
LCK_M_SCH_S_LOW_PRIORITY 0 0 0 0
LCK_M_SCH_M_LOW_PRIORITY 0 0 0 0
LCK_M_S_LOW_PRIORITY 0 0 0 0
LCK_M_U_LOW_PRIORITY 0 0 0 0
LCK_M_X_LOW_PRIORITY 0 0 0 0
LCK_M_IS_LOW_PRIORITY 0 0 0 0
LCK_M_IU_LOW_PRIORITY 0 0 0 0
LCK_M_IX_LOW_PRIORITY 0 0 0 0
LCK_M_SIU_LOW_PRIORITY 0 0 0 0
LCK_M_SIX_LOW_PRIORITY 0 0 0 0
LCK_M_UIX_LOW_PRIORITY 0 0 0 0
LCK_M_BU_LOW_PRIORITY 0 0 0 0
LCK_M_RS_S_LOW_PRIORITY 0 0 0 0
LCK_M_RS_U_LOW_PRIORITY 0 0 0 0
LCK_M_RIn_NL_LOW_PRIORITY 0 0 0 0
LCK_M_RIn_S_LOW_PRIORITY 0 0 0 0
LCK_M_RIn_U_LOW_PRIORITY 0 0 0 0
LCK_M_RIn_X_LOW_PRIORITY 0 0 0 0
LCK_M_RX_S_LOW_PRIORITY 0 0 0 0
LCK_M_RX_U_LOW_PRIORITY 0 0 0 0
LCK_M_RX_X_LOW_PRIORITY 0 0 0 0
LCK_M_SCH_S_ABORT_BLOCKERS 0 0 0 0
LCK_M_SCH_M_ABORT_BLOCKERS 0 0 0 0
LCK_M_S_ABORT_BLOCKERS 0 0 0 0
LCK_M_U_ABORT_BLOCKERS 0 0 0 0
LCK_M_X_ABORT_BLOCKERS 0 0 0 0
LCK_M_IS_ABORT_BLOCKERS 0 0 0 0
LCK_M_IU_ABORT_BLOCKERS 0 0 0 0
LCK_M_IX_ABORT_BLOCKERS 0 0 0 0
LCK_M_SIU_ABORT_BLOCKERS 0 0 0 0
LCK_M_SIX_ABORT_BLOCKERS 0 0 0 0
LCK_M_UIX_ABORT_BLOCKERS 0 0 0 0
LCK_M_BU_ABORT_BLOCKERS 0 0 0 0
LCK_M_RS_S_ABORT_BLOCKERS 0 0 0 0
LCK_M_RS_U_ABORT_BLOCKERS 0 0 0 0
LCK_M_RIn_NL_ABORT_BLOCKERS 0 0 0 0
LCK_M_RIn_S_ABORT_BLOCKERS 0 0 0 0
LCK_M_RIn_U_ABORT_BLOCKERS 0 0 0 0
LCK_M_RIn_X_ABORT_BLOCKERS 0 0 0 0
LCK_M_RX_S_ABORT_BLOCKERS 0 0 0 0
LCK_M_RX_U_ABORT_BLOCKERS 0 0 0 0
LCK_M_RX_X_ABORT_BLOCKERS 0 0 0 0
TERMINATE_LISTENER 0 0 0 0
WAIT_SCRIPTDEPLOYMENT_REQUEST 0 0 0 0
WAIT_SCRIPTDEPLOYMENT_WORKER 0 0 0 0
FEATURE_SWITCHES_UPDATE 0 0 0 0
XTP_HOST_DB_COLLECTION 0 0 0 0
XTP_HOST_LOG_ACTIVITY 0 0 0 0
QDS_DYN_VECTOR 0 0 0 0
QDS_STMT 0 0 0 0
QDS_CTXS 0 0 0 0
QDS_BCKG_TASK 0 0 0 0
QDS_DB_DISK 0 0 0 0
QDS_STMT_DISK 0 0 0 0
QDS_ASYNC_PERSIST_TASK 0 0 0 0
QDS_LOADDB 0 0 0 0
QDS_ASYNC_PERSIST_TASK_START 1 0 0 0
QDS_ASYNC_CHECK_CONSISTENCY_TASK 0 0 0 0
April 17, 2015 at 9:29 am
More readable format for those who want to answer:
+-------------------------------------------------+---------------------+--------------+------------------+---------------------+
| wait_type | waiting_tasks_count | wait_time_ms | max_wait_time_ms | signal_wait_time_ms |
+-------------------------------------------------+---------------------+--------------+------------------+---------------------+
| SP_SERVER_DIAGNOSTICS_SLEEP | 7125897 | 5393996047 | 300009 | 5393996047 |
| LAZYWRITER_SLEEP | 882957602 | 5369309001 | 2015 | 5581247 |
| CLR_AUTO_EVENT | 60 | 5317189670 | 683862329 | 0 |
| SLEEP_TASK | 431480021 | 4046775833 | 5000 | 1612697 |
| DISPATCHER_QUEUE_SEMAPHORE | 24340384 | 2904218555 | 7192655 | 220797 |
| QDS_PERSIST_TASK_MAIN_LOOP_SLEEP | 44955 | 2697374948 | 60019 | 564 |
| QDS_CLEANUP_STALE_QUERIES_TASK_MAIN_LOOP_SLEEP | 44955 | 2697374212 | 60015 | 1022 |
| DIRTY_PAGE_POLL | 25645269 | 2697368989 | 296 | 29625 |
| HADR_FILESTREAM_IOMGR_IOCOMPLETION | 5389746 | 2697357940 | 526 | 32898 |
| XE_DISPATCHER_WAIT | 207885 | 2697297089 | 64999 | 0 |
| XE_TIMER_EVENT | 737273 | 2697233893 | 5187 | 2697228158 |
| SQLTRACE_INCREMENTAL_FLUSH_SLEEP | 674098 | 2696996216 | 4172 | 1282 |
| REQUEST_FOR_DEADLOCK_SEARCH | 2687678 | 2696072046 | 5010 | 2696072046 |
| LOGMGR_QUEUE | 582259880 | 2684832861 | 215 | 3462561 |
| FT_IFTS_SCHEDULER_IDLE_WAIT | 44583 | 2675052415 | 60018 | 579 |
| BROKER_EVENTHANDLER | 218 | 2663278164 | 80418650 | 3 |
| CHECKPOINT_QUEUE | 43828 | 2635392326 | 3892035 | 825 |
| BROKER_TO_FLUSH | 1311218 | 1348632581 | 1044 | 15151 |
| WRITELOG | 615569938 | 1335082732 | 6217 | 7634740 |
| ASYNC_NETWORK_IO | 187558183 | 262817225 | 40001 | 931975 |
| PAGEIOLATCH_SH | 34149496 | 221898038 | 10068 | 89443 |
| BACKUPIO | 48345345 | 185274180 | 23748 | 183405 |
| BROKER_TASK_STOP | 28180 | 153280481 | 10016 | 1029 |
| BACKUPBUFFER | 46064072 | 122624828 | 2073 | 371841 |
| ASYNC_IO_COMPLETION | 340 | 115906092 | 5751527 | 3 |
| PAGEIOLATCH_EX | 17255091 | 104964823 | 10035 | 49516 |
| BACKUPTHREAD | 48511 | 48492257 | 1483005 | 701 |
| BROKER_RECEIVE_WAITFOR | 140 | 41450077 | 599985 | 2 |
| TRACEWRITE | 1291950 | 40237343 | 2006 | 1557253 |
| LATCH_SH | 682208 | 11795747 | 219 | 276053 |
| THREADPOOL | 19618 | 6765366 | 2917 | 2 |
| LOGBUFFER | 64552 | 5255801 | 6201 | 12571 |
| PAGEIOLATCH_UP | 216146 | 4930732 | 9643 | 16713 |
| CXPACKET | 74139 | 4202010 | 33156 | 1198 |
| SLEEP_BPOOL_FLUSH | 5598226 | 2024349 | 45 | 42447 |
| SOS_SCHEDULER_YIELD | 51863093 | 1148271 | 214 | 1118358 |
| PAGELATCH_EX | 54465401 | 1088251 | 2341 | 558860 |
| LCK_M_S | 1263 | 673703 | 26982 | 53 |
| PREEMPTIVE_OS_FILEOPS | 25595 | 587409 | 19773 | 0 |
| MSQL_XP | 91056 | 419511 | 6445 | 0 |
| PREEMPTIVE_OS_WRITEFILE | 43377 | 391562 | 1053 | 0 |
| PREEMPTIVE_XE_GETTARGETSTATE | 144125 | 380925 | 263 | 0 |
| LCK_M_IX | 83216 | 313595 | 4502 | 1105 |
| PREEMPTIVE_OS_AUTHENTICATIONOPS | 2508483 | 226960 | 218 | 0 |
| PREEMPTIVE_OS_GETFILEATTRIBUTES | 29193 | 195546 | 1741 | 0 |
| LCK_M_U | 192 | 156326 | 10013 | 5 |
| LATCH_EX | 159197 | 149288 | 139 | 15923 |
| PAGELATCH_UP | 31288 | 115260 | 9505 | 1150 |
| PAGELATCH_SH | 1803906 | 86318 | 5927 | 19589 |
| PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY | 476618 | 77827 | 245 | 0 |
| PREEMPTIVE_OS_CRYPTOPS | 1905092 | 77464 | 232 | 0 |
| PREEMPTIVE_OS_CLOSEHANDLE | 4990 | 58736 | 495 | 0 |
| PREEMPTIVE_OS_CRYPTACQUIRECONTEXT | 477091 | 52559 | 17 | 0 |
| PREEMPTIVE_OS_CREATEFILE | 15237 | 50877 | 467 | 0 |
| PREEMPTIVE_OS_GETVOLUMEPATHNAME | 4120 | 48967 | 10304 | 0 |
| WAITFOR | 4 | 42326 | 30000 | 0 |
| SLEEP_DBSTARTUP | 276 | 27443 | 100 | 8 |
| PREEMPTIVE_OS_AUTHORIZATIONOPS | 659414 | 21778 | 20 | 0 |
| PREEMPTIVE_OS_DELETESECURITYCONTEXT | 654505 | 20065 | 672 | 0 |
| LCK_M_X | 86 | 16112 | 12922 | 12 |
| PREEMPTIVE_SP_SERVER_DIAGNOSTICS | 5 | 15105 | 5047 | 0 |
| PREEMPTIVE_OS_FLUSHFILEBUFFERS | 1673 | 13631 | 547 | 0 |
| PREEMPTIVE_OS_CRYPTIMPORTKEY | 478103 | 12714 | 18 | 0 |
| PREEMPTIVE_OS_DECRYPTMESSAGE | 654533 | 12660 | 24 | 0 |
| IO_COMPLETION | 29212 | 11893 | 314 | 44 |
| WRITE_COMPLETION | 17841 | 11567 | 20 | 26 |
| LCK_M_SCH_M | 3363 | 9670 | 73 | 751 |
| SQLTRACE_FILE_READ_IO_COMPLETION | 1696 | 8694 | 40 | 2 |
| PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE | 476618 | 8383 | 26 | 0 |
| PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT | 4184 | 6441 | 10 | 0 |
| PWAIT_ALL_COMPONENTS_INITIALIZED | 4 | 6399 | 1603 | 0 |
| PREEMPTIVE_OS_QUERYREGISTRY | 44957 | 6390 | 65 | 0 |
| IO_AUDIT_MUTEX | 3381 | 4556 | 46 | 3706 |
| SQLTRACE_FILE_BUFFER | 463 | 2722 | 677 | 45 |
| PREEMPTIVE_OS_REVERTTOSELF | 182711 | 2229 | 12 | 0 |
| PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES | 178606 | 2218 | 12 | 0 |
| CHKPT | 1 | 2148 | 2148 | 0 |
| SLEEP_SYSTEMTASK | 1 | 2147 | 2147 | 0 |
| SLEEP_MASTERDBREADY | 1 | 2135 | 2135 | 0 |
| PREEMPTIVE_OS_GETDISKFREESPACE | 4015 | 1776 | 4 | 0 |
| CMEMTHREAD | 10198 | 1616 | 11 | 1394 |
| PREEMPTIVE_OS_LIBRARYOPS | 1 | 1121 | 1121 | 0 |
| PREEMPTIVE_OS_WAITFORSINGLEOBJECT | 30281 | 926 | 129 | 0 |
| PREEMPTIVE_XE_CALLBACKEXECUTE | 546341 | 829 | 8 | 0 |
| WAIT_XTP_HOST_WAIT | 3 | 762 | 387 | 0 |
| PREEMPTIVE_OS_LOADLIBRARY | 35 | 729 | 46 | 0 |
| PREEMPTIVE_OS_GENERICOPS | 38 | 657 | 424 | 0 |
| XE_BUFFERMGR_ALLPROCESSED_EVENT | 40 | 613 | 563 | 6 |
| SOS_PHYS_PAGE_CACHE | 2021 | 613 | 6 | 142 |
| FT_IFTSHC_MUTEX | 4 | 569 | 568 | 0 |
| PREEMPTIVE_OS_PIPEOPS | 1 | 438 | 438 | 0 |
| PREEMPTIVE_OS_COMOPS | 1 | 337 | 337 | 0 |
| EXECSYNC | 675 | 325 | 4 | 202 |
| PREEMPTIVE_OS_GETPROCADDRESS | 91056 | 295 | 0 | 0 |
| BACKUP | 102 | 285 | 36 | 0 |
| PREEMPTIVE_OS_LOOKUPACCOUNTSID | 83 | 279 | 110 | 0 |
| SQLTRACE_FILE_WRITE_IO_COMPLETION | 42 | 234 | 13 | 0 |
| SLEEP_DCOMSTARTUP | 1 | 174 | 174 | 0 |
| PREEMPTIVE_XE_TARGETINIT | 11 | 117 | 75 | 0 |
| PREEMPTIVE_OS_REPORTEVENT | 368 | 110 | 16 | 0 |
| FFT_RECOVERY | 5 | 73 | 40 | 0 |
| LOGMGR_FLUSH | 16 | 61 | 12 | 0 |
| PREEMPTIVE_OS_MOVEFILE | 24 | 60 | 10 | 0 |
| PREEMPTIVE_OS_DELETEFILE | 10 | 56 | 22 | 0 |
| PREEMPTIVE_OS_CLUSTEROPS | 2 | 41 | 21 | 0 |
| PREEMPTIVE_OS_WRITEFILEGATHER | 7 | 37 | 10 | 0 |
| PREEMPTIVE_OS_DOMAINSERVICESOPS | 1 | 26 | 26 | 0 |
| CLR_MANUAL_EVENT | 20 | 26 | 2 | 0 |
| DAC_INIT | 1 | 26 | 26 | 0 |
| XE_SERVICES_MUTEX | 13 | 20 | 2 | 0 |
| PREEMPTIVE_CLUSAPI_CLUSTERRESOURCECONTROL | 87 | 20 | 3 | 0 |
| QDS_TASK_START | 2 | 19 | 19 | 0 |
| PREEMPTIVE_FILESIZEGET | 63 | 16 | 0 | 0 |
| PREEMPTIVE_XE_SESSIONCOMMIT | 26 | 9 | 8 | 0 |
| PREEMPTIVE_OS_SETFILEVALIDDATA | 6 | 8 | 1 | 0 |
| PARALLEL_BACKUP_QUEUE | 1297 | 6 | 0 | 5 |
| PREEMPTIVE_OS_SQMLAUNCH | 32 | 1 | 0 | 0 |
| PREEMPTIVE_TESTING | 0 | 0 | 0 | 0 |
| PREEMPTIVE_SOSHOST | 0 | 0 | 0 | 0 |
| PREEMPTIVE_SOSTESTING | 0 | 0 | 0 | 0 |
| PREEMPTIVE_XETESTING | 0 | 0 | 0 | 0 |
| PREEMPTIVE_SB_STOPENDPOINT | 1 | 0 | 0 | 0 |
| PREEMPTIVE_STARTRM | 0 | 0 | 0 | 0 |
| PREEMPTIVE_GETRMINFO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_SETRMINFO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_ROLLFORWARDREDO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_ROLLFORWARDUNDO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_RESIZELOG | 0 | 0 | 0 | 0 |
| PREEMPTIVE_REENLIST | 0 | 0 | 0 | 0 |
| PREEMPTIVE_TRANSIMPORT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_UNMARSHALPROPAGATIONTOKEN | 0 | 0 | 0 | 0 |
| PREEMPTIVE_CREATEPARAM | 0 | 0 | 0 | 0 |
| PREEMPTIVE_STREAMFCB_RECOVER | 0 | 0 | 0 | 0 |
| PREEMPTIVE_STREAMFCB_CHECKPOINT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_CLOSEBACKUPMEDIA | 0 | 0 | 0 | 0 |
| PREEMPTIVE_CLOSEBACKUPTAPE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_CLOSEBACKUPVDIDEVICE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_VSSOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_VSS_CREATESNAPSHOT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_VSS_CREATEVOLUMESNAPSHOT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DFSADDLINK | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DFSLINKEXISTCHECK | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DFSLINKHEALTHCHECK | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DFSREMOVELINK | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DFSREMOVEROOT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DFSROOTFOLDERCHECK | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DFSROOTINIT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DFSROOTSHARECHECK | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLE_UNINIT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_FSAOLEDB_ABORTTRANSACTION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_FSAOLEDB_COMMITTRANSACTION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_FSAOLEDB_STARTTRANSACTION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_FSRECOVER_UNCONDITIONALUNDO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_SERVER_STARTUP | 0 | 0 | 0 | 0 |
| PREEMPTIVE_SHAREDMEM_GETDATA | 0 | 0 | 0 | 0 |
| PREEMPTIVE_CONSOLEWRITE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_BACKUPREAD | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_FREELIBRARY | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_DISCONNECTNAMEDPIPE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_PROCESSOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_SECURITYOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_SERVICEOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_SQLCLROPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_WINSOCKOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_GETADDRINFO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_WSASETLASTERROR | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_FORMATMESSAGE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_GETFILESIZE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_GETLONGPATHNAME | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_OPENDIRECTORY | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_REMOVEDIRECTORY | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_SETENDOFFILE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_SETFILEPOINTER | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_MESSAGEQUEUEOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_ODBCOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDBOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_ABORTTRAN | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_ABORTORCOMMITTRAN | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_GETDATASOURCE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_GETLITERALINFO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_GETPROPERTIES | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_GETPROPERTYINFO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_GETSCHEMALOCK | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_JOINTRANSACTION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_RELEASE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_SETPROPERTIES | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_GETCOMPRESSEDFILESIZE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_DEVICEIOCONTROL | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_FINDFILE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_SETNAMEDSECURITYINFO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_COPYFILE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_CREATEDIRECTORY | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_DTCOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DTC_ABORT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DTC_ABORTREQUESTDONE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DTC_BEGINTRANSACTION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DTC_COMMITREQUESTDONE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DTC_ENLIST | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DTC_PREPAREREQUESTDONE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_DEVICEOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_RSFXDEVICEOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_DIRSVC_NETWORKOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_DSGETDCNAME | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_NETGROUPGETUSERS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_NETLOCALGROUPGETMEMBERS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_NETUSERGETGROUPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_NETUSERGETLOCALGROUPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_NETUSERMODALSGET | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_COCREATEINSTANCE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_COGETCLASSOBJECT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_CREATEACCESSOR | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_DELETEROWS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_GETCOMMANDTEXT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_GETDATA | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_GETNEXTROWS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_GETRESULT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_GETROWSBYBOOKMARK | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_LBFLUSH | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_LBLOCKREGION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_LBREADAT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_LBSETSIZE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_LBSTAT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_LBUNLOCKREGION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_LBWRITEAT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_QUERYINTERFACE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_RELEASE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_RELEASEACCESSOR | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_RELEASEROWS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_RELEASESESSION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_RESTARTPOSITION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_SEQSTRMREAD | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_SEQSTRMREADANDWRITE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_SETDATAFAILURE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_SETPARAMETERINFO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_SETPARAMETERPROPERTIES | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_STRMLOCKREGION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_STRMSEEKANDREAD | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_STRMSEEKANDWRITE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_STRMSETSIZE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_STRMSTAT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_STRMUNLOCKREGION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_XE_TARGETFINALIZE | 6 | 0 | 0 | 0 |
| PREEMPTIVE_XE_DISPATCHER | 1 | 0 | 0 | 0 |
| PREEMPTIVE_XE_ENGINEINIT | 0 | 0 | 0 | 0 |
| AUDIT_XE_SESSION_MGR | 0 | 0 | 0 | 0 |
| AUDIT_ON_DEMAND_TARGET_LOCK | 0 | 0 | 0 | 0 |
| PWAIT_PREEMPTIVE_AUDIT_ACCESS_WINDOWSLOG | 0 | 0 | 0 | 0 |
| AUDIT_LOGINCACHE_LOCK | 0 | 0 | 0 | 0 |
| AUDIT_GROUPCACHE_LOCK | 0 | 0 | 0 | 0 |
| FT_METADATA_MUTEX | 0 | 0 | 0 | 0 |
| PREEMPTIVE_XE_TIMERRUN | 1 | 0 | 0 | 0 |
| PREEMPTIVE_SNIOPEN | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DEBUG | 0 | 0 | 0 | 0 |
| PREEMPTIVE_MSS_RELEASE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_LOCKMONITOR | 1 | 0 | 0 | 0 |
| PREEMPTIVE_STRESSDRIVER | 0 | 0 | 0 | 0 |
| CLEAR_DB | 0 | 0 | 0 | 0 |
| PREEMPTIVE_ABR | 0 | 0 | 0 | 0 |
| LOGGENERATION | 0 | 0 | 0 | 0 |
| IO_RETRY | 0 | 0 | 0 | 0 |
| FT_IFTSISM_MUTEX | 0 | 0 | 0 | 0 |
| FT_IFTS_RWLOCK | 0 | 0 | 0 | 0 |
| FT_COMPROWSET_RWLOCK | 0 | 0 | 0 | 0 |
| FT_MASTER_MERGE | 0 | 0 | 0 | 0 |
| TRACE_EVTNOTIF | 0 | 0 | 0 | 0 |
| SOS_SMALL_PAGE_ALLOC | 0 | 0 | 0 | 0 |
| MD_LAZYCACHE_RWLOCK | 0 | 0 | 0 | 0 |
| MD_AGENT_YIELD | 0 | 0 | 0 | 0 |
| IOAFF_RANGE_QUEUE | 0 | 0 | 0 | 0 |
| REPL_HISTORYCACHE_ACCESS | 0 | 0 | 0 | 0 |
| REPL_TRANHASHTABLE_ACCESS | 0 | 0 | 0 | 0 |
| REPL_TRANTEXTINFO_ACCESS | 0 | 0 | 0 | 0 |
| REPL_TRANFSINFO_ACCESS | 0 | 0 | 0 | 0 |
| SERVER_RECONFIGURE | 0 | 0 | 0 | 0 |
| CHANGE_TRACKING_WAITFORCHANGES | 0 | 0 | 0 | 0 |
| PWAIT_MD_RELATION_CACHE | 0 | 0 | 0 | 0 |
| PWAIT_MD_SERVER_CACHE | 0 | 0 | 0 | 0 |
| PWAIT_MD_LOGIN_STATS | 0 | 0 | 0 | 0 |
| DISPATCHER_PRIORITY_QUEUE_SEMAPHORE | 0 | 0 | 0 | 0 |
| FT_PROPERTYLIST_CACHE | 0 | 0 | 0 | 0 |
| PERFORMANCE_COUNTERS_RWLOCK | 2 | 0 | 0 | 0 |
| SECURITY_KEYRING_RWLOCK | 0 | 0 | 0 | 0 |
| AM_INDBUILD_ALLOCATION | 0 | 0 | 0 | 0 |
| STARTUP_DEPENDENCY_MANAGER | 0 | 0 | 0 | 0 |
| PWAIT_SECURITY_CACHE_INVALIDATION | 0 | 0 | 0 | 0 |
| XDES_HISTORY | 0 | 0 | 0 | 0 |
| XDES_SNAPSHOT | 0 | 0 | 0 | 0 |
| FT_MASTER_MERGE_COORDINATOR | 0 | 0 | 0 | 0 |
| PWAIT_RESOURCE_SEMAPHORE_FT_PARALLEL_QUERY_SYNC | 0 | 0 | 0 | 0 |
| REDO_THREAD_PENDING_WORK | 0 | 0 | 0 | 0 |
| REDO_THREAD_SYNC | 0 | 0 | 0 | 0 |
| COUNTRECOVERYMGR | 0 | 0 | 0 | 0 |
| HADR_DB_COMMAND | 0 | 0 | 0 | 0 |
| HADR_TRANSPORT_SESSION | 0 | 0 | 0 | 0 |
| HADR_CLUSAPI_CALL | 0 | 0 | 0 | 0 |
| PWAIT_HADR_CHANGE_NOTIFIER_TERMINATION_SYNC | 0 | 0 | 0 | 0 |
| PWAIT_HADR_ACTION_COMPLETED | 0 | 0 | 0 | 0 |
| PWAIT_HADR_OFFLINE_COMPLETED | 0 | 0 | 0 | 0 |
| PWAIT_HADR_ONLINE_COMPLETED | 0 | 0 | 0 | 0 |
| PWAIT_HADR_FAILOVER_COMPLETED | 0 | 0 | 0 | 0 |
| PWAIT_HADR_WORKITEM_COMPLETED | 0 | 0 | 0 | 0 |
| HADR_WORK_POOL | 0 | 0 | 0 | 0 |
| HADR_WORK_QUEUE | 0 | 0 | 0 | 0 |
| HADR_LOGCAPTURE_SYNC | 0 | 0 | 0 | 0 |
| PWAIT_HADR_CLUSTER_INTEGRATION | 0 | 0 | 0 | 0 |
| LOGCAPTURE_LOGPOOLTRUNCPOINT | 0 | 0 | 0 | 0 |
| LOGPOOL_CACHESIZE | 0 | 0 | 0 | 0 |
| LOGPOOL_FREEPOOLS | 0 | 0 | 0 | 0 |
| LOGPOOL_REPLACEMENTSET | 0 | 0 | 0 | 0 |
| LOGPOOL_CONSUMERSET | 0 | 0 | 0 | 0 |
| LOGPOOL_MGRSET | 0 | 0 | 0 | 0 |
| LOGPOOL_CONSUMER | 0 | 0 | 0 | 0 |
| LOGPOOLREFCOUNTEDOBJECT_REFDONE | 0 | 0 | 0 | 0 |
| HADR_SYNC_COMMIT | 0 | 0 | 0 | 0 |
| HADR_AG_MUTEX | 0 | 0 | 0 | 0 |
| PWAIT_HADR_SERVER_READY_CONNECTIONS | 0 | 0 | 0 | 0 |
| HADR_FILESTREAM_MANAGER | 0 | 0 | 0 | 0 |
| HADR_FILESTREAM_BLOCK_FLUSH | 0 | 0 | 0 | 0 |
| HADR_FILESTREAM_IOMGR | 0 | 0 | 0 | 0 |
| FFT_NSO_FCB | 0 | 0 | 0 | 0 |
| FFT_NSO_FCB_PARENT | 0 | 0 | 0 | 0 |
| FFT_NSO_FCB_FIND | 0 | 0 | 0 | 0 |
| FFT_NSO_FCB_RELEASE_CACHED_ENTRIES | 0 | 0 | 0 | 0 |
| FFT_NSO_FILEOBJECT | 0 | 0 | 0 | 0 |
| FFT_NSO_DB_LIST | 0 | 0 | 0 | 0 |
| FFT_NSO_DB_KILL_FLAG | 0 | 0 | 0 | 0 |
| FFT_NSO_TABLE_LIST | 0 | 0 | 0 | 0 |
| FFT_STORE_DB | 0 | 0 | 0 | 0 |
| FFT_STORE_TABLE | 0 | 0 | 0 | 0 |
| FFT_STORE_ROWSET_LIST | 0 | 0 | 0 | 0 |
| FFT_NTFS_STORE | 0 | 0 | 0 | 0 |
| HADR_FILESTREAM_FILE_REQUEST | 0 | 0 | 0 | 0 |
| PWAIT_MD_UPGRADE_CONFIG | 0 | 0 | 0 | 0 |
| PWAIT_COOP_SCAN | 0 | 0 | 0 | 0 |
| QRY_PARALLEL_THREAD_MUTEX | 0 | 0 | 0 | 0 |
| PWAIT_QRY_BPMEMORY | 0 | 0 | 0 | 0 |
| WAITFOR_PER_QUEUE | 0 | 0 | 0 | 0 |
| CREATE_DATINISERVICE | 0 | 0 | 0 | 0 |
| AM_SCHEMAMGR_UNSHARED_CACHE | 0 | 0 | 0 | 0 |
| HADR_REPLICAINFO_SYNC | 0 | 0 | 0 | 0 |
| HADR_COMPRESSED_CACHE_SYNC | 0 | 0 | 0 | 0 |
| HADR_AR_MANAGER_MUTEX | 0 | 0 | 0 | 0 |
| HADR_NOTIFICATION_WORKER_TERMINATION_SYNC | 0 | 0 | 0 | 0 |
| HADR_NOTIFICATION_DEQUEUE | 0 | 0 | 0 | 0 |
| HADR_ARCONTROLLER_NOTIFICATIONS_SUBSCRIBER_LIST | 0 | 0 | 0 | 0 |
| HADR_DBR_SUBSCRIBER_FILTER_LIST | 0 | 0 | 0 | 0 |
| HADR_DBR_SUBSCRIBER | 0 | 0 | 0 | 0 |
| HADR_NOTIFICATION_WORKER_STARTUP_SYNC | 0 | 0 | 0 | 0 |
| HADR_NOTIFICATION_WORKER_EXCLUSIVE_ACCESS | 0 | 0 | 0 | 0 |
| HADR_RECOVERY_WAIT_FOR_UNDO | 0 | 0 | 0 | 0 |
| HADR_DATABASE_WAIT_FOR_RESTART | 0 | 0 | 0 | 0 |
| HADR_XRF_STACK_ACCESS | 0 | 0 | 0 | 0 |
| HADR_RECOVERY_WAIT_FOR_CONNECTION | 0 | 0 | 0 | 0 |
| HADR_TRANSPORT_FLOW_CONTROL | 0 | 0 | 0 | 0 |
| HADR_DATABASE_FLOW_CONTROL | 0 | 0 | 0 | 0 |
| PWAIT_HADR_POST_ONLINE_COMPLETED | 0 | 0 | 0 | 0 |
| HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING | 0 | 0 | 0 | 0 |
| XDES_OUT_OF_ORDER_LIST | 0 | 0 | 0 | 0 |
| HADR_BACKUP_BULK_LOCK | 0 | 0 | 0 | 0 |
| HADR_BACKUP_QUEUE | 0 | 0 | 0 | 0 |
| HADR_LOGCAPTURE_WAIT | 0 | 0 | 0 | 0 |
| HADR_AR_CRITICAL_SECTION_ENTRY | 0 | 0 | 0 | 0 |
| HADR_TDS_LISTENER_SYNC | 0 | 0 | 0 | 0 |
| HADR_READ_ALL_NETWORKS | 0 | 0 | 0 | 0 |
| HADR_TDS_LISTENER_SYNC_PROCESSING | 0 | 0 | 0 | 0 |
| PWAIT_XTP_FSSTORAGE_MAINTENANCE | 0 | 0 | 0 | 0 |
| WAIT_XTP_GUEST | 0 | 0 | 0 | 0 |
| WAIT_XTP_TASK_SHUTDOWN | 0 | 0 | 0 | 0 |
| XTPPROC_PARTITIONED_STACK_CREATE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_HADR_LEASE_MECHANISM | 0 | 0 | 0 | 0 |
| HADR_TIMER_TASK | 0 | 0 | 0 | 0 |
| PWAIT_EVENT_SESSION_INIT_MUTEX | 0 | 0 | 0 | 0 |
| PWAIT_REPLICA_ONLINE_INIT_MUTEX | 0 | 0 | 0 | 0 |
| HADR_GROUP_COMMIT | 0 | 0 | 0 | 0 |
| HADR_SYNCHRONIZING_THROTTLE | 0 | 0 | 0 | 0 |
| HADR_DATABASE_VERSIONING_STATE | 0 | 0 | 0 | 0 |
| XTPPROC_CACHE_ACCESS | 0 | 0 | 0 | 0 |
| SP_SERVER_DIAGNOSTICS_BUFFER_ACCESS | 0 | 0 | 0 | 0 |
| RESOURCE_GOVERNOR_IDLE | 0 | 0 | 0 | 0 |
| HADR_FILESTREAM_FILE_CLOSE | 0 | 0 | 0 | 0 |
| VERSIONING_COMMITTING | 0 | 0 | 0 | 0 |
| FILETABLE_SHUTDOWN | 0 | 0 | 0 | 0 |
| PRU_ROLLBACK_DEFERRED | 0 | 0 | 0 | 0 |
| WAIT_XTP_TRAN_DEPENDENCY | 0 | 0 | 0 | 0 |
| DUMP_LOG_COORDINATOR_QUEUE | 0 | 0 | 0 | 0 |
| LOWFAIL_MEMMGR_QUEUE | 0 | 0 | 0 | 0 |
| ONDEMAND_TASK_QUEUE | 1 | 0 | 0 | 0 |
| SOS_VIRTUALMEMORY_LOW | 0 | 0 | 0 | 0 |
| SOS_CALLBACK_REMOVAL | 0 | 0 | 0 | 0 |
| SOS_MEMORY_TOPLEVELBLOCKALLOCATOR | 0 | 0 | 0 | 0 |
| DEBUG | 0 | 0 | 0 | 0 |
| REPLICA_WRITES | 0 | 0 | 0 | 0 |
| DBMIRRORING_CMD | 0 | 0 | 0 | 0 |
| WAIT_FOR_RESULTS | 0 | 0 | 0 | 0 |
| DBMIRROR_DBM_MUTEX | 0 | 0 | 0 | 0 |
| DBMIRROR_DBM_EVENT | 0 | 0 | 0 | 0 |
| DBMIRROR_SEND | 0 | 0 | 0 | 0 |
| DBMIRROR_EVENTS_QUEUE | 0 | 0 | 0 | 0 |
| DBMIRROR_WORKER_QUEUE | 0 | 0 | 0 | 0 |
| HTTP_START | 0 | 0 | 0 | 0 |
| HTTP_ENUMERATION | 0 | 0 | 0 | 0 |
| SOAP_READ | 0 | 0 | 0 | 0 |
| SOAP_WRITE | 0 | 0 | 0 | 0 |
| DUMP_LOG_COORDINATOR | 0 | 0 | 0 | 0 |
| DISKIO_SUSPEND | 0 | 0 | 0 | 0 |
| IMPPROV_IOWAIT | 0 | 0 | 0 | 0 |
| DEADLOCK_TASK_SEARCH | 0 | 0 | 0 | 0 |
| REPL_SCHEMA_ACCESS | 0 | 0 | 0 | 0 |
| REPL_CACHE_ACCESS | 0 | 0 | 0 | 0 |
| KSOURCE_WAKEUP | 1 | 0 | 0 | 0 |
| SQLSORT_SORTMUTEX | 0 | 0 | 0 | 0 |
| SQLSORT_NORMMUTEX | 0 | 0 | 0 | 0 |
| SQLTRACE_WAIT_ENTRIES | 0 | 0 | 0 | 0 |
| FCB_REPLICA_WRITE | 0 | 0 | 0 | 0 |
| FCB_REPLICA_READ | 0 | 0 | 0 | 0 |
| EXCHANGE | 0 | 0 | 0 | 0 |
| EC | 0 | 0 | 0 | 0 |
| TEMPOBJ | 0 | 0 | 0 | 0 |
| XACTLOCKINFO | 0 | 0 | 0 | 0 |
| LOGMGR | 0 | 0 | 0 | 0 |
| SQLTRACE_SHUTDOWN | 0 | 0 | 0 | 0 |
| QUERY_TRACEOUT | 0 | 0 | 0 | 0 |
| DTC_STATE | 0 | 0 | 0 | 0 |
| BROKER_TRANSMITTER | 2 | 0 | 0 | 0 |
| BROKER_SERVICE | 0 | 0 | 0 | 0 |
| BROKER_SHUTDOWN | 0 | 0 | 0 | 0 |
| BROKER_MASTERSTART | 1 | 0 | 0 | 0 |
| BROKER_REGISTERALLENDPOINTS | 0 | 0 | 0 | 0 |
| DTCPNTSYNC | 0 | 0 | 0 | 0 |
| SOSHOST_INTERNAL | 0 | 0 | 0 | 0 |
| SOSHOST_SLEEP | 0 | 0 | 0 | 0 |
| SOSHOST_WAITFORDONE | 0 | 0 | 0 | 0 |
| SOSHOST_MUTEX | 0 | 0 | 0 | 0 |
| SOSHOST_EVENT | 0 | 0 | 0 | 0 |
| SOSHOST_SEMAPHORE | 0 | 0 | 0 | 0 |
| SOSHOST_RWLOCK | 0 | 0 | 0 | 0 |
| SOSHOST_TRACELOCK | 0 | 0 | 0 | 0 |
| HTREPARTITION | 0 | 0 | 0 | 0 |
| HTBUILD | 0 | 0 | 0 | 0 |
| HTMEMO | 0 | 0 | 0 | 0 |
| HTDELETE | 0 | 0 | 0 | 0 |
| HTREINIT | 0 | 0 | 0 | 0 |
| BMPREPARTITION | 0 | 0 | 0 | 0 |
| BMPALLOCATION | 0 | 0 | 0 | 0 |
| BMPREPLICATION | 0 | 0 | 0 | 0 |
| BMPBUILD | 0 | 0 | 0 | 0 |
| SHUTDOWN | 0 | 0 | 0 | 0 |
| SLEEP_TEMPDBSTARTUP | 0 | 0 | 0 | 0 |
| DBSTATE | 0 | 0 | 0 | 0 |
| SLEEP_MASTERMDREADY | 0 | 0 | 0 | 0 |
| SLEEP_MASTERUPGRADED | 0 | 0 | 0 | 0 |
| RESOURCE_SEMAPHORE | 0 | 0 | 0 | 0 |
| DTC | 0 | 0 | 0 | 0 |
| OLEDB | 0 | 0 | 0 | 0 |
| FAILPOINT | 0 | 0 | 0 | 0 |
| RESOURCE_QUEUE | 0 | 0 | 0 | 0 |
| ASYNC_DISKPOOL_LOCK | 1 | 0 | 0 | 0 |
| PAGEIOLATCH_DT | 0 | 0 | 0 | 0 |
| TRAN_MARKLATCH_NL | 0 | 0 | 0 | 0 |
| TRAN_MARKLATCH_KP | 0 | 0 | 0 | 0 |
| TRAN_MARKLATCH_SH | 0 | 0 | 0 | 0 |
| TRAN_MARKLATCH_UP | 0 | 0 | 0 | 0 |
| TRAN_MARKLATCH_EX | 0 | 0 | 0 | 0 |
| TRAN_MARKLATCH_DT | 0 | 0 | 0 | 0 |
| LCK_M_IS | 0 | 0 | 0 | 0 |
| LCK_M_IU | 0 | 0 | 0 | 0 |
| LATCH_UP | 0 | 0 | 0 | 0 |
| MISCELLANEOUS | 0 | 0 | 0 | 0 |
| LCK_M_SCH_S | 0 | 0 | 0 | 0 |
| LATCH_DT | 0 | 0 | 0 | 0 |
| PAGELATCH_NL | 0 | 0 | 0 | 0 |
| PAGELATCH_KP | 0 | 0 | 0 | 0 |
| PAGELATCH_DT | 0 | 0 | 0 | 0 |
| PAGEIOLATCH_NL | 0 | 0 | 0 | 0 |
| PAGEIOLATCH_KP | 0 | 0 | 0 | 0 |
| LCK_M_SIU | 0 | 0 | 0 | 0 |
| LCK_M_SIX | 0 | 0 | 0 | 0 |
| LCK_M_UIX | 0 | 0 | 0 | 0 |
| LCK_M_BU | 0 | 0 | 0 | 0 |
| LCK_M_RS_S | 0 | 0 | 0 | 0 |
| LCK_M_RS_U | 0 | 0 | 0 | 0 |
| LCK_M_RIn_NL | 0 | 0 | 0 | 0 |
| LCK_M_RIn_S | 0 | 0 | 0 | 0 |
| LCK_M_RIn_U | 0 | 0 | 0 | 0 |
| LCK_M_RIn_X | 0 | 0 | 0 | 0 |
| LCK_M_RX_S | 0 | 0 | 0 | 0 |
| LCK_M_RX_U | 0 | 0 | 0 | 0 |
| LCK_M_RX_X | 0 | 0 | 0 | 0 |
| LATCH_NL | 0 | 0 | 0 | 0 |
| LATCH_KP | 0 | 0 | 0 | 0 |
| XE_SERVICES_RWLOCK | 0 | 0 | 0 | 0 |
| XE_SERVICES_EVENTMANUAL | 0 | 0 | 0 | 0 |
| XE_OLS_LOCK | 0 | 0 | 0 | 0 |
| SOS_DISPATCHER_MUTEX | 0 | 0 | 0 | 0 |
| XE_BUFFERMGR_FREEBUF_EVENT | 0 | 0 | 0 | 0 |
| XE_MODULEMGR_SYNC | 0 | 0 | 0 | 0 |
| XE_STM_CREATE | 0 | 0 | 0 | 0 |
| XE_SESSION_SYNC | 0 | 0 | 0 | 0 |
| XE_SESSION_CREATE_SYNC | 0 | 0 | 0 | 0 |
| BROKER_TASK_SHUTDOWN | 0 | 0 | 0 | 0 |
| BROKER_TASK_SUBMIT | 0 | 0 | 0 | 0 |
| SNI_TASK_COMPLETION | 1 | 0 | 0 | 0 |
| SNI_LISTENER_ACCESS | 0 | 0 | 0 | 0 |
| EXECUTION_PIPE_EVENT_INTERNAL | 0 | 0 | 0 | 0 |
| CLR_MEMORY_SPY | 0 | 0 | 0 | 0 |
| CLRHOST_STATE_ACCESS | 0 | 0 | 0 | 0 |
| ASSEMBLY_LOAD | 0 | 0 | 0 | 0 |
| VIA_ACCEPT | 0 | 0 | 0 | 0 |
| CHECK_PRINT_RECORD | 0 | 0 | 0 | 0 |
| INTERNAL_TESTING | 0 | 0 | 0 | 0 |
| SCAN_CHAR_HASH_ARRAY_INITIALIZATION | 0 | 0 | 0 | 0 |
| FS_GARBAGE_COLLECTOR_SHUTDOWN | 0 | 0 | 0 | 0 |
| FSAGENT | 0 | 0 | 0 | 0 |
| FILESTREAM_WORKITEM_QUEUE | 0 | 0 | 0 | 0 |
| FILESTREAM_FILE_OBJECT | 0 | 0 | 0 | 0 |
| FILESTREAM_FCB | 0 | 0 | 0 | 0 |
| FILESTREAM_CACHE | 0 | 0 | 0 | 0 |
| ABR | 0 | 0 | 0 | 0 |
| WCC | 0 | 0 | 0 | 0 |
| DUMPTRIGGER | 0 | 0 | 0 | 0 |
| TIMEPRIV_TIMEPERIOD | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_VERIFYSIGNATURE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_AUTHZGETINFORMATIONFROMCONTEXT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSID | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_AUTHZINITIALIZERESOURCEMANAGER | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_ENCRYPTMESSAGE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_FREECREDENTIALSHANDLE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_INITIALIZESECURITYCONTEXT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_LOGONUSER | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_QUERYSECURITYCONTEXTTOKEN | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_ACCEPTSECURITYCONTEXT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_ACQUIRECREDENTIALSHANDLE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_COMPLETEAUTHTOKEN | 0 | 0 | 0 | 0 |
| XE_DISPATCHER_JOIN | 0 | 0 | 0 | 0 |
| XE_TIMER_MUTEX | 0 | 0 | 0 | 0 |
| XE_TIMER_TASK_DONE | 0 | 0 | 0 | 0 |
| XE_DISPATCHER_CONFIG_SESSION_LIST | 0 | 0 | 0 | 0 |
| XE_SESSION_FLUSH | 0 | 0 | 0 | 0 |
| XE_CALLBACK_LIST | 0 | 0 | 0 | 0 |
| NODE_CACHE_MUTEX | 0 | 0 | 0 | 0 |
| RG_RECONFIG | 0 | 0 | 0 | 0 |
| RESMGR_THROTTLED | 0 | 0 | 0 | 0 |
| SOS_MEMORY_USAGE_ADJUSTMENT | 0 | 0 | 0 | 0 |
| SECURITY_MUTEX | 0 | 0 | 0 | 0 |
| FS_HEADER_RWLOCK | 0 | 0 | 0 | 0 |
| FS_LOGTRUNC_RWLOCK | 0 | 0 | 0 | 0 |
| FS_FC_RWLOCK | 0 | 0 | 0 | 0 |
| FSTR_CONFIG_RWLOCK | 0 | 0 | 0 | 0 |
| FSTR_CONFIG_MUTEX | 0 | 0 | 0 | 0 |
| FSA_FORCE_OWN_XACT | 0 | 0 | 0 | 0 |
| COMMIT_TABLE | 0 | 0 | 0 | 0 |
| CXROWSET_SYNC | 2 | 0 | 0 | 0 |
| XACT_OWN_TRANSACTION | 0 | 0 | 0 | 0 |
| XACT_RECLAIM_SESSION | 0 | 0 | 0 | 0 |
| DTC_WAITFOR_OUTCOME | 0 | 0 | 0 | 0 |
| DTC_RESOLVE | 0 | 0 | 0 | 0 |
| SEC_DROP_TEMP_KEY | 0 | 0 | 0 | 0 |
| SRVPROC_SHUTDOWN | 0 | 0 | 0 | 0 |
| BROKER_INIT | 0 | 0 | 0 | 0 |
| BROKER_CONNECTION_RECEIVE_TASK | 0 | 0 | 0 | 0 |
| NET_WAITFOR_PACKET | 0 | 0 | 0 | 0 |
| DTC_ABORT_REQUEST | 0 | 0 | 0 | 0 |
| DTC_TMDOWN_REQUEST | 0 | 0 | 0 | 0 |
| RECOVER_CHANGEDB | 0 | 0 | 0 | 0 |
| WORKTBL_DROP | 0 | 0 | 0 | 0 |
| SNI_HTTP_WAITFOR_0_DISCON | 0 | 0 | 0 | 0 |
| UTIL_PAGE_ALLOC | 0 | 0 | 0 | 0 |
| SERVER_IDLE_CHECK | 0 | 0 | 0 | 0 |
| DEADLOCK_ENUM_MUTEX | 0 | 0 | 0 | 0 |
| VIEW_DEFINITION_MUTEX | 0 | 0 | 0 | 0 |
| QUERY_NOTIFICATION_MGR_MUTEX | 0 | 0 | 0 | 0 |
| QUERY_NOTIFICATION_TABLE_MGR_MUTEX | 0 | 0 | 0 | 0 |
| QUERY_NOTIFICATION_SUBSCRIPTION_MUTEX | 0 | 0 | 0 | 0 |
| QUERY_NOTIFICATION_UNITTEST_MUTEX | 0 | 0 | 0 | 0 |
| RESOURCE_SEMAPHORE_MUTEX | 0 | 0 | 0 | 0 |
| BUILTIN_HASHKEY_MUTEX | 0 | 0 | 0 | 0 |
| SOS_PROCESS_AFFINITY_MUTEX | 3 | 0 | 0 | 0 |
| MSQL_XACT_MGR_MUTEX | 0 | 0 | 0 | 0 |
| MSQL_XACT_MUTEX | 0 | 0 | 0 | 0 |
| QRY_MEM_GRANT_INFO_MUTEX | 0 | 0 | 0 | 0 |
| SNI_CRITICAL_SECTION | 6 | 0 | 0 | 0 |
| SOS_STACKSTORE_INIT_MUTEX | 0 | 0 | 0 | 0 |
| SOS_SYNC_TASK_ENQUEUE_EVENT | 2 | 0 | 0 | 0 |
| SOS_OBJECT_STORE_DESTROY_MUTEX | 0 | 0 | 0 | 0 |
| EE_PMOLOCK | 0 | 0 | 0 | 0 |
| QUERY_OPTIMIZER_PRINT_MUTEX | 0 | 0 | 0 | 0 |
| DLL_LOADING_MUTEX | 0 | 0 | 0 | 0 |
| RESOURCE_SEMAPHORE_QUERY_COMPILE | 0 | 0 | 0 | 0 |
| BROKER_ENDPOINT_STATE_MUTEX | 0 | 0 | 0 | 0 |
| QUERY_EXECUTION_INDEX_SORT_EVENT_OPEN | 0 | 0 | 0 | 0 |
| ERROR_REPORTING_MANAGER | 0 | 0 | 0 | 0 |
| EE_SPECPROC_MAP_INIT | 0 | 0 | 0 | 0 |
| FULLTEXT GATHERER | 0 | 0 | 0 | 0 |
| SEQUENTIAL_GUID | 0 | 0 | 0 | 0 |
| MSQL_DQ | 0 | 0 | 0 | 0 |
| TRANSACTION_MUTEX | 0 | 0 | 0 | 0 |
| SLEEP_MSDBSTARTUP | 0 | 0 | 0 | 0 |
| MSSEARCH | 0 | 0 | 0 | 0 |
| XACTWORKSPACE_MUTEX | 0 | 0 | 0 | 0 |
| WAITSTAT_MUTEX | 3 | 0 | 0 | 0 |
| WAITFOR_TASKSHUTDOWN | 0 | 0 | 0 | 0 |
| GUARDIAN | 0 | 0 | 0 | 0 |
| CLR_TASK_START | 0 | 0 | 0 | 0 |
| CLR_JOIN | 0 | 0 | 0 | 0 |
| CLR_CRST | 0 | 0 | 0 | 0 |
| CLR_SEMAPHORE | 0 | 0 | 0 | 0 |
| CLR_MONITOR | 0 | 0 | 0 | 0 |
| CLR_RWLOCK_READER | 0 | 0 | 0 | 0 |
| CLR_RWLOCK_WRITER | 0 | 0 | 0 | 0 |
| SQLCLR_QUANTUM_PUNISHMENT | 0 | 0 | 0 | 0 |
| SQLCLR_APPDOMAIN | 0 | 0 | 0 | 0 |
| SQLCLR_ASSEMBLY | 0 | 0 | 0 | 0 |
| KTM_ENLISTMENT | 0 | 0 | 0 | 0 |
| KTM_RECOVERY_RESOLUTION | 0 | 0 | 0 | 0 |
| KTM_RECOVERY_MANAGER | 0 | 0 | 0 | 0 |
| SQLCLR_DEADLOCK_DETECTION | 0 | 0 | 0 | 0 |
| QPJOB_WAITFOR_ABORT | 0 | 0 | 0 | 0 |
| QPJOB_KILL | 0 | 0 | 0 | 0 |
| BAD_PAGE_PROCESS | 0 | 0 | 0 | 0 |
| BACKUP_OPERATOR | 0 | 0 | 0 | 0 |
| PRINT_ROLLBACK_PROGRESS | 0 | 0 | 0 | 0 |
| ENABLE_VERSIONING | 0 | 0 | 0 | 0 |
| DISABLE_VERSIONING | 0 | 0 | 0 | 0 |
| REQUEST_DISPENSER_PAUSE | 0 | 0 | 0 | 0 |
| DROPTEMP | 0 | 0 | 0 | 0 |
| FT_RESTART_CRAWL | 0 | 0 | 0 | 0 |
| LOGMGR_RESERVE_APPEND | 0 | 0 | 0 | 0 |
| XE_LIVE_TARGET_TVF | 0 | 0 | 0 | 0 |
| QDS_TASK_SHUTDOWN | 0 | 0 | 0 | 0 |
| QDS_SHUTDOWN_QUEUE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_XE_CX_FILE_OPEN | 0 | 0 | 0 | 0 |
| XE_CX_FILE_READ | 0 | 0 | 0 | 0 |
| WINFAB_API_CALL | 0 | 0 | 0 | 0 |
| PREEMPTIVE_XE_CX_HTTP_CALL | 0 | 0 | 0 | 0 |
| PWAIT_LOG_CONSOLIDATION_POLL | 0 | 0 | 0 | 0 |
| PWAIT_LOG_CONSOLIDATION_IO | 0 | 0 | 0 | 0 |
| COLUMNSTORE_BUILD_THROTTLE | 0 | 0 | 0 | 0 |
| DBSEEDING_OPERATION | 0 | 0 | 0 | 0 |
| DBSEEDING_FLOWCONTROL | 0 | 0 | 0 | 0 |
| PHYSICAL_SEEDING_DMV | 0 | 0 | 0 | 0 |
| DROP_DATABASE_TIMER_TASK | 0 | 0 | 0 | 0 |
| SNI_CONN_DUP | 0 | 0 | 0 | 0 |
| SEQUENCE_GENERATION | 0 | 0 | 0 | 0 |
| RTDATA_LIST | 0 | 0 | 0 | 0 |
| PWAIT_HADR_JOIN | 0 | 0 | 0 | 0 |
| WINFAB_REPLICA_BUILD_OPERATION | 0 | 0 | 0 | 0 |
| FABRIC_REPLICA_PUBLISHER_EVENT_PUBLISH | 0 | 0 | 0 | 0 |
| SQLTRACE_PENDING_BUFFER_WRITERS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_PDH_WMI_INIT | 0 | 0 | 0 | 0 |
| BROKER_TRANSMISSION_WORK | 5 | 0 | 0 | 0 |
| BROKER_TRANSMISSION_OBJECT | 0 | 0 | 0 | 0 |
| BROKER_TRANSMISSION_TABLE | 1 | 0 | 0 | 0 |
| BROKER_DISPATCHER | 0 | 0 | 0 | 0 |
| BROKER_FORWARDER | 0 | 0 | 0 | 0 |
| UCS_MANAGER | 0 | 0 | 0 | 0 |
| UCS_TRANSPORT | 0 | 0 | 0 | 0 |
| UCS_MEMORY_NOTIFICATION | 0 | 0 | 0 | 0 |
| UCS_ENDPOINT_CHANGE | 0 | 0 | 0 | 0 |
| UCS_TRANSPORT_STREAM_CHANGE | 0 | 0 | 0 | 0 |
| QUERY_TASK_ENQUEUE_MUTEX | 0 | 0 | 0 | 0 |
| SP_PREEMPTIVE_SERVER_DIAGNOSTICS_SLEEP | 0 | 0 | 0 | 0 |
| SP_SERVER_DIAGNOSTICS_INIT_MUTEX | 0 | 0 | 0 | 0 |
| DBCC_SCALE_OUT_EXPR_CACHE | 0 | 0 | 0 | 0 |
| GDMA_GET_RESOURCE_OWNER | 0 | 0 | 0 | 0 |
| UCS_SESSION_REGISTRATION | 0 | 0 | 0 | 0 |
| ENABLE_EMPTY_VERSIONING | 0 | 0 | 0 | 0 |
| HADR_DB_OP_START_SYNC | 0 | 0 | 0 | 0 |
| HADR_DB_OP_COMPLETION_SYNC | 0 | 0 | 0 | 0 |
| HADR_LOGPROGRESS_SYNC | 0 | 0 | 0 | 0 |
| HADR_TRANSPORT_DBRLIST | 0 | 0 | 0 | 0 |
| HADR_CONNECTIVITY_INFO | 0 | 0 | 0 | 0 |
| XDESTSVERMGR | 0 | 0 | 0 | 0 |
| GHOSTCLEANUPSYNCMGR | 0 | 0 | 0 | 0 |
| HADR_AR_UNLOAD_COMPLETED | 0 | 0 | 0 | 0 |
| HADR_PARTNER_SYNC | 0 | 0 | 0 | 0 |
| HADR_DBSTATECHANGE_SYNC | 0 | 0 | 0 | 0 |
| DIRTY_PAGE_SYNC | 0 | 0 | 0 | 0 |
| HTTP_STORAGE_CONNECTION | 0 | 0 | 0 | 0 |
| SECURITY_CRYPTO_CONTEXT_MUTEX | 0 | 0 | 0 | 0 |
| SECURITY_RULETABLE_MUTEX | 0 | 0 | 0 | 0 |
| SEMPLAT_DSI_BUILD | 0 | 0 | 0 | 0 |
| FILESTREAM_CHUNKER_INIT | 0 | 0 | 0 | 0 |
| FILESTREAM_CHUNKER | 0 | 0 | 0 | 0 |
| FFT_RSFX_COMM | 0 | 0 | 0 | 0 |
| FFT_RSFX_WAIT_FOR_MEMORY | 0 | 0 | 0 | 0 |
| FFT_STARTUP_SHUTDOWN | 0 | 0 | 0 | 0 |
| PWAIT_XTP_HOST_STORAGE_WAIT | 0 | 0 | 0 | 0 |
| HADR_FABRIC_CALLBACK | 0 | 0 | 0 | 0 |
| ASYNC_OP_CONTEXT_READ | 0 | 0 | 0 | 0 |
| ASYNC_OP_CONTEXT_WRITE | 0 | 0 | 0 | 0 |
| ASYNC_OP_COMPLETION | 0 | 0 | 0 | 0 |
| FABRIC_REPLICA_PUBLISHER_SUBSCRIBER_LIST | 0 | 0 | 0 | 0 |
| FABRIC_REPLICA_CONTROLLER_STATE_AND_CONFIG | 0 | 0 | 0 | 0 |
| FABRIC_REPLICA_CONTROLLER_LIST | 0 | 0 | 0 | 0 |
| FABRIC_HADR_TRANSPORT_CONNECTION | 0 | 0 | 0 | 0 |
| FABRIC_WAIT_FOR_BUILD_REPLICA_EVENT_PROCESSING | 0 | 0 | 0 | 0 |
| VDI_CLIENT_GETCOMMAND | 0 | 0 | 0 | 0 |
| VDI_CLIENT_COMPLETECOMMAND | 0 | 0 | 0 | 0 |
| VDI_CLIENT_OTHER | 0 | 0 | 0 | 0 |
| VDI_CLIENT_OPERATION | 0 | 0 | 0 | 0 |
| HADR_DBSEEDING | 0 | 0 | 0 | 0 |
| HADR_DBSEEDING_LIST | 0 | 0 | 0 | 0 |
| SLO_UPDATE | 0 | 0 | 0 | 0 |
| WAIT_XTP_RECOVERY | 0 | 0 | 0 | 0 |
| WAIT_XTP_OFFLINE_CKPT_NEW_LOG | 0 | 0 | 0 | 0 |
| WAIT_XTP_OFFLINE_CKPT_LOG_IO | 0 | 0 | 0 | 0 |
| WAIT_XTP_OFFLINE_CKPT_BEFORE_REDO | 0 | 0 | 0 | 0 |
| WAIT_XTP_PROCEDURE_ENTRY | 0 | 0 | 0 | 0 |
| WAIT_XTP_CKPT_ENABLED | 0 | 0 | 0 | 0 |
| WAIT_XTP_CKPT_AGENT_WAKEUP | 0 | 0 | 0 | 0 |
| WAIT_XTP_CKPT_CLOSE | 0 | 0 | 0 | 0 |
| WAIT_XTP_CKPT_STATE_LOCK | 0 | 0 | 0 | 0 |
| WAIT_XTP_ASYNC_TX_COMPLETION | 0 | 0 | 0 | 0 |
| LCK_M_SCH_S_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_SCH_M_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_S_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_U_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_X_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_IS_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_IU_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_IX_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_SIU_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_SIX_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_UIX_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_BU_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_RS_S_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_RS_U_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_RIn_NL_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_RIn_S_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_RIn_U_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_RIn_X_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_RX_S_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_RX_U_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_RX_X_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_SCH_S_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_SCH_M_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_S_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_U_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_X_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_IS_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_IU_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_IX_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_SIU_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_SIX_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_UIX_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_BU_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_RS_S_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_RS_U_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_RIn_NL_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_RIn_S_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_RIn_U_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_RIn_X_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_RX_S_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_RX_U_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_RX_X_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| TERMINATE_LISTENER | 0 | 0 | 0 | 0 |
| WAIT_SCRIPTDEPLOYMENT_REQUEST | 0 | 0 | 0 | 0 |
| WAIT_SCRIPTDEPLOYMENT_WORKER | 0 | 0 | 0 | 0 |
| FEATURE_SWITCHES_UPDATE | 0 | 0 | 0 | 0 |
| XTP_HOST_DB_COLLECTION | 0 | 0 | 0 | 0 |
| XTP_HOST_LOG_ACTIVITY | 0 | 0 | 0 | 0 |
| QDS_DYN_VECTOR | 0 | 0 | 0 | 0 |
| QDS_STMT | 0 | 0 | 0 | 0 |
| QDS_CTXS | 0 | 0 | 0 | 0 |
| QDS_BCKG_TASK | 0 | 0 | 0 | 0 |
| QDS_DB_DISK | 0 | 0 | 0 | 0 |
| QDS_STMT_DISK | 0 | 0 | 0 | 0 |
| QDS_ASYNC_PERSIST_TASK | 0 | 0 | 0 | 0 |
| QDS_LOADDB | 0 | 0 | 0 | 0 |
| QDS_ASYNC_PERSIST_TASK_START | 1 | 0 | 0 | 0 |
| QDS_ASYNC_CHECK_CONSISTENCY_TASK | 0 | 0 | 0 | 0 |
+-------------------------------------------------+---------------------+--------------+------------------+---------------------+
-- Gianluca Sartori
April 17, 2015 at 9:36 am
spaghettidba (4/17/2015)
More readable format for those who want to answer:
+-------------------------------------------------+---------------------+--------------+------------------+---------------------+
| wait_type | waiting_tasks_count | wait_time_ms | max_wait_time_ms | signal_wait_time_ms |
+-------------------------------------------------+---------------------+--------------+------------------+---------------------+
| SP_SERVER_DIAGNOSTICS_SLEEP | 7125897 | 5393996047 | 300009 | 5393996047 |
| LAZYWRITER_SLEEP | 882957602 | 5369309001 | 2015 | 5581247 |
| CLR_AUTO_EVENT | 60 | 5317189670 | 683862329 | 0 |
| SLEEP_TASK | 431480021 | 4046775833 | 5000 | 1612697 |
| DISPATCHER_QUEUE_SEMAPHORE | 24340384 | 2904218555 | 7192655 | 220797 |
| QDS_PERSIST_TASK_MAIN_LOOP_SLEEP | 44955 | 2697374948 | 60019 | 564 |
| QDS_CLEANUP_STALE_QUERIES_TASK_MAIN_LOOP_SLEEP | 44955 | 2697374212 | 60015 | 1022 |
| DIRTY_PAGE_POLL | 25645269 | 2697368989 | 296 | 29625 |
| HADR_FILESTREAM_IOMGR_IOCOMPLETION | 5389746 | 2697357940 | 526 | 32898 |
| XE_DISPATCHER_WAIT | 207885 | 2697297089 | 64999 | 0 |
| XE_TIMER_EVENT | 737273 | 2697233893 | 5187 | 2697228158 |
| SQLTRACE_INCREMENTAL_FLUSH_SLEEP | 674098 | 2696996216 | 4172 | 1282 |
| REQUEST_FOR_DEADLOCK_SEARCH | 2687678 | 2696072046 | 5010 | 2696072046 |
| LOGMGR_QUEUE | 582259880 | 2684832861 | 215 | 3462561 |
| FT_IFTS_SCHEDULER_IDLE_WAIT | 44583 | 2675052415 | 60018 | 579 |
| BROKER_EVENTHANDLER | 218 | 2663278164 | 80418650 | 3 |
| CHECKPOINT_QUEUE | 43828 | 2635392326 | 3892035 | 825 |
| BROKER_TO_FLUSH | 1311218 | 1348632581 | 1044 | 15151 |
| WRITELOG | 615569938 | 1335082732 | 6217 | 7634740 |
| ASYNC_NETWORK_IO | 187558183 | 262817225 | 40001 | 931975 |
| PAGEIOLATCH_SH | 34149496 | 221898038 | 10068 | 89443 |
| BACKUPIO | 48345345 | 185274180 | 23748 | 183405 |
| BROKER_TASK_STOP | 28180 | 153280481 | 10016 | 1029 |
| BACKUPBUFFER | 46064072 | 122624828 | 2073 | 371841 |
| ASYNC_IO_COMPLETION | 340 | 115906092 | 5751527 | 3 |
| PAGEIOLATCH_EX | 17255091 | 104964823 | 10035 | 49516 |
| BACKUPTHREAD | 48511 | 48492257 | 1483005 | 701 |
| BROKER_RECEIVE_WAITFOR | 140 | 41450077 | 599985 | 2 |
| TRACEWRITE | 1291950 | 40237343 | 2006 | 1557253 |
| LATCH_SH | 682208 | 11795747 | 219 | 276053 |
| THREADPOOL | 19618 | 6765366 | 2917 | 2 |
| LOGBUFFER | 64552 | 5255801 | 6201 | 12571 |
| PAGEIOLATCH_UP | 216146 | 4930732 | 9643 | 16713 |
| CXPACKET | 74139 | 4202010 | 33156 | 1198 |
| SLEEP_BPOOL_FLUSH | 5598226 | 2024349 | 45 | 42447 |
| SOS_SCHEDULER_YIELD | 51863093 | 1148271 | 214 | 1118358 |
| PAGELATCH_EX | 54465401 | 1088251 | 2341 | 558860 |
| LCK_M_S | 1263 | 673703 | 26982 | 53 |
| PREEMPTIVE_OS_FILEOPS | 25595 | 587409 | 19773 | 0 |
| MSQL_XP | 91056 | 419511 | 6445 | 0 |
| PREEMPTIVE_OS_WRITEFILE | 43377 | 391562 | 1053 | 0 |
| PREEMPTIVE_XE_GETTARGETSTATE | 144125 | 380925 | 263 | 0 |
| LCK_M_IX | 83216 | 313595 | 4502 | 1105 |
| PREEMPTIVE_OS_AUTHENTICATIONOPS | 2508483 | 226960 | 218 | 0 |
| PREEMPTIVE_OS_GETFILEATTRIBUTES | 29193 | 195546 | 1741 | 0 |
| LCK_M_U | 192 | 156326 | 10013 | 5 |
| LATCH_EX | 159197 | 149288 | 139 | 15923 |
| PAGELATCH_UP | 31288 | 115260 | 9505 | 1150 |
| PAGELATCH_SH | 1803906 | 86318 | 5927 | 19589 |
| PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY | 476618 | 77827 | 245 | 0 |
| PREEMPTIVE_OS_CRYPTOPS | 1905092 | 77464 | 232 | 0 |
| PREEMPTIVE_OS_CLOSEHANDLE | 4990 | 58736 | 495 | 0 |
| PREEMPTIVE_OS_CRYPTACQUIRECONTEXT | 477091 | 52559 | 17 | 0 |
| PREEMPTIVE_OS_CREATEFILE | 15237 | 50877 | 467 | 0 |
| PREEMPTIVE_OS_GETVOLUMEPATHNAME | 4120 | 48967 | 10304 | 0 |
| WAITFOR | 4 | 42326 | 30000 | 0 |
| SLEEP_DBSTARTUP | 276 | 27443 | 100 | 8 |
| PREEMPTIVE_OS_AUTHORIZATIONOPS | 659414 | 21778 | 20 | 0 |
| PREEMPTIVE_OS_DELETESECURITYCONTEXT | 654505 | 20065 | 672 | 0 |
| LCK_M_X | 86 | 16112 | 12922 | 12 |
| PREEMPTIVE_SP_SERVER_DIAGNOSTICS | 5 | 15105 | 5047 | 0 |
| PREEMPTIVE_OS_FLUSHFILEBUFFERS | 1673 | 13631 | 547 | 0 |
| PREEMPTIVE_OS_CRYPTIMPORTKEY | 478103 | 12714 | 18 | 0 |
| PREEMPTIVE_OS_DECRYPTMESSAGE | 654533 | 12660 | 24 | 0 |
| IO_COMPLETION | 29212 | 11893 | 314 | 44 |
| WRITE_COMPLETION | 17841 | 11567 | 20 | 26 |
| LCK_M_SCH_M | 3363 | 9670 | 73 | 751 |
| SQLTRACE_FILE_READ_IO_COMPLETION | 1696 | 8694 | 40 | 2 |
| PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE | 476618 | 8383 | 26 | 0 |
| PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT | 4184 | 6441 | 10 | 0 |
| PWAIT_ALL_COMPONENTS_INITIALIZED | 4 | 6399 | 1603 | 0 |
| PREEMPTIVE_OS_QUERYREGISTRY | 44957 | 6390 | 65 | 0 |
| IO_AUDIT_MUTEX | 3381 | 4556 | 46 | 3706 |
| SQLTRACE_FILE_BUFFER | 463 | 2722 | 677 | 45 |
| PREEMPTIVE_OS_REVERTTOSELF | 182711 | 2229 | 12 | 0 |
| PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES | 178606 | 2218 | 12 | 0 |
| CHKPT | 1 | 2148 | 2148 | 0 |
| SLEEP_SYSTEMTASK | 1 | 2147 | 2147 | 0 |
| SLEEP_MASTERDBREADY | 1 | 2135 | 2135 | 0 |
| PREEMPTIVE_OS_GETDISKFREESPACE | 4015 | 1776 | 4 | 0 |
| CMEMTHREAD | 10198 | 1616 | 11 | 1394 |
| PREEMPTIVE_OS_LIBRARYOPS | 1 | 1121 | 1121 | 0 |
| PREEMPTIVE_OS_WAITFORSINGLEOBJECT | 30281 | 926 | 129 | 0 |
| PREEMPTIVE_XE_CALLBACKEXECUTE | 546341 | 829 | 8 | 0 |
| WAIT_XTP_HOST_WAIT | 3 | 762 | 387 | 0 |
| PREEMPTIVE_OS_LOADLIBRARY | 35 | 729 | 46 | 0 |
| PREEMPTIVE_OS_GENERICOPS | 38 | 657 | 424 | 0 |
| XE_BUFFERMGR_ALLPROCESSED_EVENT | 40 | 613 | 563 | 6 |
| SOS_PHYS_PAGE_CACHE | 2021 | 613 | 6 | 142 |
| FT_IFTSHC_MUTEX | 4 | 569 | 568 | 0 |
| PREEMPTIVE_OS_PIPEOPS | 1 | 438 | 438 | 0 |
| PREEMPTIVE_OS_COMOPS | 1 | 337 | 337 | 0 |
| EXECSYNC | 675 | 325 | 4 | 202 |
| PREEMPTIVE_OS_GETPROCADDRESS | 91056 | 295 | 0 | 0 |
| BACKUP | 102 | 285 | 36 | 0 |
| PREEMPTIVE_OS_LOOKUPACCOUNTSID | 83 | 279 | 110 | 0 |
| SQLTRACE_FILE_WRITE_IO_COMPLETION | 42 | 234 | 13 | 0 |
| SLEEP_DCOMSTARTUP | 1 | 174 | 174 | 0 |
| PREEMPTIVE_XE_TARGETINIT | 11 | 117 | 75 | 0 |
| PREEMPTIVE_OS_REPORTEVENT | 368 | 110 | 16 | 0 |
| FFT_RECOVERY | 5 | 73 | 40 | 0 |
| LOGMGR_FLUSH | 16 | 61 | 12 | 0 |
| PREEMPTIVE_OS_MOVEFILE | 24 | 60 | 10 | 0 |
| PREEMPTIVE_OS_DELETEFILE | 10 | 56 | 22 | 0 |
| PREEMPTIVE_OS_CLUSTEROPS | 2 | 41 | 21 | 0 |
| PREEMPTIVE_OS_WRITEFILEGATHER | 7 | 37 | 10 | 0 |
| PREEMPTIVE_OS_DOMAINSERVICESOPS | 1 | 26 | 26 | 0 |
| CLR_MANUAL_EVENT | 20 | 26 | 2 | 0 |
| DAC_INIT | 1 | 26 | 26 | 0 |
| XE_SERVICES_MUTEX | 13 | 20 | 2 | 0 |
| PREEMPTIVE_CLUSAPI_CLUSTERRESOURCECONTROL | 87 | 20 | 3 | 0 |
| QDS_TASK_START | 2 | 19 | 19 | 0 |
| PREEMPTIVE_FILESIZEGET | 63 | 16 | 0 | 0 |
| PREEMPTIVE_XE_SESSIONCOMMIT | 26 | 9 | 8 | 0 |
| PREEMPTIVE_OS_SETFILEVALIDDATA | 6 | 8 | 1 | 0 |
| PARALLEL_BACKUP_QUEUE | 1297 | 6 | 0 | 5 |
| PREEMPTIVE_OS_SQMLAUNCH | 32 | 1 | 0 | 0 |
| PREEMPTIVE_TESTING | 0 | 0 | 0 | 0 |
| PREEMPTIVE_SOSHOST | 0 | 0 | 0 | 0 |
| PREEMPTIVE_SOSTESTING | 0 | 0 | 0 | 0 |
| PREEMPTIVE_XETESTING | 0 | 0 | 0 | 0 |
| PREEMPTIVE_SB_STOPENDPOINT | 1 | 0 | 0 | 0 |
| PREEMPTIVE_STARTRM | 0 | 0 | 0 | 0 |
| PREEMPTIVE_GETRMINFO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_SETRMINFO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_ROLLFORWARDREDO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_ROLLFORWARDUNDO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_RESIZELOG | 0 | 0 | 0 | 0 |
| PREEMPTIVE_REENLIST | 0 | 0 | 0 | 0 |
| PREEMPTIVE_TRANSIMPORT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_UNMARSHALPROPAGATIONTOKEN | 0 | 0 | 0 | 0 |
| PREEMPTIVE_CREATEPARAM | 0 | 0 | 0 | 0 |
| PREEMPTIVE_STREAMFCB_RECOVER | 0 | 0 | 0 | 0 |
| PREEMPTIVE_STREAMFCB_CHECKPOINT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_CLOSEBACKUPMEDIA | 0 | 0 | 0 | 0 |
| PREEMPTIVE_CLOSEBACKUPTAPE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_CLOSEBACKUPVDIDEVICE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_VSSOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_VSS_CREATESNAPSHOT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_VSS_CREATEVOLUMESNAPSHOT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DFSADDLINK | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DFSLINKEXISTCHECK | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DFSLINKHEALTHCHECK | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DFSREMOVELINK | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DFSREMOVEROOT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DFSROOTFOLDERCHECK | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DFSROOTINIT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DFSROOTSHARECHECK | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLE_UNINIT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_FSAOLEDB_ABORTTRANSACTION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_FSAOLEDB_COMMITTRANSACTION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_FSAOLEDB_STARTTRANSACTION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_FSRECOVER_UNCONDITIONALUNDO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_SERVER_STARTUP | 0 | 0 | 0 | 0 |
| PREEMPTIVE_SHAREDMEM_GETDATA | 0 | 0 | 0 | 0 |
| PREEMPTIVE_CONSOLEWRITE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_BACKUPREAD | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_FREELIBRARY | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_DISCONNECTNAMEDPIPE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_PROCESSOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_SECURITYOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_SERVICEOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_SQLCLROPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_WINSOCKOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_GETADDRINFO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_WSASETLASTERROR | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_FORMATMESSAGE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_GETFILESIZE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_GETLONGPATHNAME | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_OPENDIRECTORY | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_REMOVEDIRECTORY | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_SETENDOFFILE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_SETFILEPOINTER | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_MESSAGEQUEUEOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_ODBCOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDBOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_ABORTTRAN | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_ABORTORCOMMITTRAN | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_GETDATASOURCE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_GETLITERALINFO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_GETPROPERTIES | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_GETPROPERTYINFO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_GETSCHEMALOCK | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_JOINTRANSACTION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_RELEASE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OLEDB_SETPROPERTIES | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_GETCOMPRESSEDFILESIZE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_DEVICEIOCONTROL | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_FINDFILE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_SETNAMEDSECURITYINFO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_COPYFILE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_CREATEDIRECTORY | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_DTCOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DTC_ABORT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DTC_ABORTREQUESTDONE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DTC_BEGINTRANSACTION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DTC_COMMITREQUESTDONE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DTC_ENLIST | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DTC_PREPAREREQUESTDONE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_DEVICEOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_RSFXDEVICEOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_DIRSVC_NETWORKOPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_DSGETDCNAME | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_NETGROUPGETUSERS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_NETLOCALGROUPGETMEMBERS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_NETUSERGETGROUPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_NETUSERGETLOCALGROUPS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_NETUSERMODALSGET | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_COCREATEINSTANCE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_COGETCLASSOBJECT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_CREATEACCESSOR | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_DELETEROWS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_GETCOMMANDTEXT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_GETDATA | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_GETNEXTROWS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_GETRESULT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_GETROWSBYBOOKMARK | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_LBFLUSH | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_LBLOCKREGION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_LBREADAT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_LBSETSIZE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_LBSTAT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_LBUNLOCKREGION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_LBWRITEAT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_QUERYINTERFACE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_RELEASE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_RELEASEACCESSOR | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_RELEASEROWS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_RELEASESESSION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_RESTARTPOSITION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_SEQSTRMREAD | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_SEQSTRMREADANDWRITE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_SETDATAFAILURE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_SETPARAMETERINFO | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_SETPARAMETERPROPERTIES | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_STRMLOCKREGION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_STRMSEEKANDREAD | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_STRMSEEKANDWRITE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_STRMSETSIZE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_STRMSTAT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_COM_STRMUNLOCKREGION | 0 | 0 | 0 | 0 |
| PREEMPTIVE_XE_TARGETFINALIZE | 6 | 0 | 0 | 0 |
| PREEMPTIVE_XE_DISPATCHER | 1 | 0 | 0 | 0 |
| PREEMPTIVE_XE_ENGINEINIT | 0 | 0 | 0 | 0 |
| AUDIT_XE_SESSION_MGR | 0 | 0 | 0 | 0 |
| AUDIT_ON_DEMAND_TARGET_LOCK | 0 | 0 | 0 | 0 |
| PWAIT_PREEMPTIVE_AUDIT_ACCESS_WINDOWSLOG | 0 | 0 | 0 | 0 |
| AUDIT_LOGINCACHE_LOCK | 0 | 0 | 0 | 0 |
| AUDIT_GROUPCACHE_LOCK | 0 | 0 | 0 | 0 |
| FT_METADATA_MUTEX | 0 | 0 | 0 | 0 |
| PREEMPTIVE_XE_TIMERRUN | 1 | 0 | 0 | 0 |
| PREEMPTIVE_SNIOPEN | 0 | 0 | 0 | 0 |
| PREEMPTIVE_DEBUG | 0 | 0 | 0 | 0 |
| PREEMPTIVE_MSS_RELEASE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_LOCKMONITOR | 1 | 0 | 0 | 0 |
| PREEMPTIVE_STRESSDRIVER | 0 | 0 | 0 | 0 |
| CLEAR_DB | 0 | 0 | 0 | 0 |
| PREEMPTIVE_ABR | 0 | 0 | 0 | 0 |
| LOGGENERATION | 0 | 0 | 0 | 0 |
| IO_RETRY | 0 | 0 | 0 | 0 |
| FT_IFTSISM_MUTEX | 0 | 0 | 0 | 0 |
| FT_IFTS_RWLOCK | 0 | 0 | 0 | 0 |
| FT_COMPROWSET_RWLOCK | 0 | 0 | 0 | 0 |
| FT_MASTER_MERGE | 0 | 0 | 0 | 0 |
| TRACE_EVTNOTIF | 0 | 0 | 0 | 0 |
| SOS_SMALL_PAGE_ALLOC | 0 | 0 | 0 | 0 |
| MD_LAZYCACHE_RWLOCK | 0 | 0 | 0 | 0 |
| MD_AGENT_YIELD | 0 | 0 | 0 | 0 |
| IOAFF_RANGE_QUEUE | 0 | 0 | 0 | 0 |
| REPL_HISTORYCACHE_ACCESS | 0 | 0 | 0 | 0 |
| REPL_TRANHASHTABLE_ACCESS | 0 | 0 | 0 | 0 |
| REPL_TRANTEXTINFO_ACCESS | 0 | 0 | 0 | 0 |
| REPL_TRANFSINFO_ACCESS | 0 | 0 | 0 | 0 |
| SERVER_RECONFIGURE | 0 | 0 | 0 | 0 |
| CHANGE_TRACKING_WAITFORCHANGES | 0 | 0 | 0 | 0 |
| PWAIT_MD_RELATION_CACHE | 0 | 0 | 0 | 0 |
| PWAIT_MD_SERVER_CACHE | 0 | 0 | 0 | 0 |
| PWAIT_MD_LOGIN_STATS | 0 | 0 | 0 | 0 |
| DISPATCHER_PRIORITY_QUEUE_SEMAPHORE | 0 | 0 | 0 | 0 |
| FT_PROPERTYLIST_CACHE | 0 | 0 | 0 | 0 |
| PERFORMANCE_COUNTERS_RWLOCK | 2 | 0 | 0 | 0 |
| SECURITY_KEYRING_RWLOCK | 0 | 0 | 0 | 0 |
| AM_INDBUILD_ALLOCATION | 0 | 0 | 0 | 0 |
| STARTUP_DEPENDENCY_MANAGER | 0 | 0 | 0 | 0 |
| PWAIT_SECURITY_CACHE_INVALIDATION | 0 | 0 | 0 | 0 |
| XDES_HISTORY | 0 | 0 | 0 | 0 |
| XDES_SNAPSHOT | 0 | 0 | 0 | 0 |
| FT_MASTER_MERGE_COORDINATOR | 0 | 0 | 0 | 0 |
| PWAIT_RESOURCE_SEMAPHORE_FT_PARALLEL_QUERY_SYNC | 0 | 0 | 0 | 0 |
| REDO_THREAD_PENDING_WORK | 0 | 0 | 0 | 0 |
| REDO_THREAD_SYNC | 0 | 0 | 0 | 0 |
| COUNTRECOVERYMGR | 0 | 0 | 0 | 0 |
| HADR_DB_COMMAND | 0 | 0 | 0 | 0 |
| HADR_TRANSPORT_SESSION | 0 | 0 | 0 | 0 |
| HADR_CLUSAPI_CALL | 0 | 0 | 0 | 0 |
| PWAIT_HADR_CHANGE_NOTIFIER_TERMINATION_SYNC | 0 | 0 | 0 | 0 |
| PWAIT_HADR_ACTION_COMPLETED | 0 | 0 | 0 | 0 |
| PWAIT_HADR_OFFLINE_COMPLETED | 0 | 0 | 0 | 0 |
| PWAIT_HADR_ONLINE_COMPLETED | 0 | 0 | 0 | 0 |
| PWAIT_HADR_FAILOVER_COMPLETED | 0 | 0 | 0 | 0 |
| PWAIT_HADR_WORKITEM_COMPLETED | 0 | 0 | 0 | 0 |
| HADR_WORK_POOL | 0 | 0 | 0 | 0 |
| HADR_WORK_QUEUE | 0 | 0 | 0 | 0 |
| HADR_LOGCAPTURE_SYNC | 0 | 0 | 0 | 0 |
| PWAIT_HADR_CLUSTER_INTEGRATION | 0 | 0 | 0 | 0 |
| LOGCAPTURE_LOGPOOLTRUNCPOINT | 0 | 0 | 0 | 0 |
| LOGPOOL_CACHESIZE | 0 | 0 | 0 | 0 |
| LOGPOOL_FREEPOOLS | 0 | 0 | 0 | 0 |
| LOGPOOL_REPLACEMENTSET | 0 | 0 | 0 | 0 |
| LOGPOOL_CONSUMERSET | 0 | 0 | 0 | 0 |
| LOGPOOL_MGRSET | 0 | 0 | 0 | 0 |
| LOGPOOL_CONSUMER | 0 | 0 | 0 | 0 |
| LOGPOOLREFCOUNTEDOBJECT_REFDONE | 0 | 0 | 0 | 0 |
| HADR_SYNC_COMMIT | 0 | 0 | 0 | 0 |
| HADR_AG_MUTEX | 0 | 0 | 0 | 0 |
| PWAIT_HADR_SERVER_READY_CONNECTIONS | 0 | 0 | 0 | 0 |
| HADR_FILESTREAM_MANAGER | 0 | 0 | 0 | 0 |
| HADR_FILESTREAM_BLOCK_FLUSH | 0 | 0 | 0 | 0 |
| HADR_FILESTREAM_IOMGR | 0 | 0 | 0 | 0 |
| FFT_NSO_FCB | 0 | 0 | 0 | 0 |
| FFT_NSO_FCB_PARENT | 0 | 0 | 0 | 0 |
| FFT_NSO_FCB_FIND | 0 | 0 | 0 | 0 |
| FFT_NSO_FCB_RELEASE_CACHED_ENTRIES | 0 | 0 | 0 | 0 |
| FFT_NSO_FILEOBJECT | 0 | 0 | 0 | 0 |
| FFT_NSO_DB_LIST | 0 | 0 | 0 | 0 |
| FFT_NSO_DB_KILL_FLAG | 0 | 0 | 0 | 0 |
| FFT_NSO_TABLE_LIST | 0 | 0 | 0 | 0 |
| FFT_STORE_DB | 0 | 0 | 0 | 0 |
| FFT_STORE_TABLE | 0 | 0 | 0 | 0 |
| FFT_STORE_ROWSET_LIST | 0 | 0 | 0 | 0 |
| FFT_NTFS_STORE | 0 | 0 | 0 | 0 |
| HADR_FILESTREAM_FILE_REQUEST | 0 | 0 | 0 | 0 |
| PWAIT_MD_UPGRADE_CONFIG | 0 | 0 | 0 | 0 |
| PWAIT_COOP_SCAN | 0 | 0 | 0 | 0 |
| QRY_PARALLEL_THREAD_MUTEX | 0 | 0 | 0 | 0 |
| PWAIT_QRY_BPMEMORY | 0 | 0 | 0 | 0 |
| WAITFOR_PER_QUEUE | 0 | 0 | 0 | 0 |
| CREATE_DATINISERVICE | 0 | 0 | 0 | 0 |
| AM_SCHEMAMGR_UNSHARED_CACHE | 0 | 0 | 0 | 0 |
| HADR_REPLICAINFO_SYNC | 0 | 0 | 0 | 0 |
| HADR_COMPRESSED_CACHE_SYNC | 0 | 0 | 0 | 0 |
| HADR_AR_MANAGER_MUTEX | 0 | 0 | 0 | 0 |
| HADR_NOTIFICATION_WORKER_TERMINATION_SYNC | 0 | 0 | 0 | 0 |
| HADR_NOTIFICATION_DEQUEUE | 0 | 0 | 0 | 0 |
| HADR_ARCONTROLLER_NOTIFICATIONS_SUBSCRIBER_LIST | 0 | 0 | 0 | 0 |
| HADR_DBR_SUBSCRIBER_FILTER_LIST | 0 | 0 | 0 | 0 |
| HADR_DBR_SUBSCRIBER | 0 | 0 | 0 | 0 |
| HADR_NOTIFICATION_WORKER_STARTUP_SYNC | 0 | 0 | 0 | 0 |
| HADR_NOTIFICATION_WORKER_EXCLUSIVE_ACCESS | 0 | 0 | 0 | 0 |
| HADR_RECOVERY_WAIT_FOR_UNDO | 0 | 0 | 0 | 0 |
| HADR_DATABASE_WAIT_FOR_RESTART | 0 | 0 | 0 | 0 |
| HADR_XRF_STACK_ACCESS | 0 | 0 | 0 | 0 |
| HADR_RECOVERY_WAIT_FOR_CONNECTION | 0 | 0 | 0 | 0 |
| HADR_TRANSPORT_FLOW_CONTROL | 0 | 0 | 0 | 0 |
| HADR_DATABASE_FLOW_CONTROL | 0 | 0 | 0 | 0 |
| PWAIT_HADR_POST_ONLINE_COMPLETED | 0 | 0 | 0 | 0 |
| HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING | 0 | 0 | 0 | 0 |
| XDES_OUT_OF_ORDER_LIST | 0 | 0 | 0 | 0 |
| HADR_BACKUP_BULK_LOCK | 0 | 0 | 0 | 0 |
| HADR_BACKUP_QUEUE | 0 | 0 | 0 | 0 |
| HADR_LOGCAPTURE_WAIT | 0 | 0 | 0 | 0 |
| HADR_AR_CRITICAL_SECTION_ENTRY | 0 | 0 | 0 | 0 |
| HADR_TDS_LISTENER_SYNC | 0 | 0 | 0 | 0 |
| HADR_READ_ALL_NETWORKS | 0 | 0 | 0 | 0 |
| HADR_TDS_LISTENER_SYNC_PROCESSING | 0 | 0 | 0 | 0 |
| PWAIT_XTP_FSSTORAGE_MAINTENANCE | 0 | 0 | 0 | 0 |
| WAIT_XTP_GUEST | 0 | 0 | 0 | 0 |
| WAIT_XTP_TASK_SHUTDOWN | 0 | 0 | 0 | 0 |
| XTPPROC_PARTITIONED_STACK_CREATE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_HADR_LEASE_MECHANISM | 0 | 0 | 0 | 0 |
| HADR_TIMER_TASK | 0 | 0 | 0 | 0 |
| PWAIT_EVENT_SESSION_INIT_MUTEX | 0 | 0 | 0 | 0 |
| PWAIT_REPLICA_ONLINE_INIT_MUTEX | 0 | 0 | 0 | 0 |
| HADR_GROUP_COMMIT | 0 | 0 | 0 | 0 |
| HADR_SYNCHRONIZING_THROTTLE | 0 | 0 | 0 | 0 |
| HADR_DATABASE_VERSIONING_STATE | 0 | 0 | 0 | 0 |
| XTPPROC_CACHE_ACCESS | 0 | 0 | 0 | 0 |
| SP_SERVER_DIAGNOSTICS_BUFFER_ACCESS | 0 | 0 | 0 | 0 |
| RESOURCE_GOVERNOR_IDLE | 0 | 0 | 0 | 0 |
| HADR_FILESTREAM_FILE_CLOSE | 0 | 0 | 0 | 0 |
| VERSIONING_COMMITTING | 0 | 0 | 0 | 0 |
| FILETABLE_SHUTDOWN | 0 | 0 | 0 | 0 |
| PRU_ROLLBACK_DEFERRED | 0 | 0 | 0 | 0 |
| WAIT_XTP_TRAN_DEPENDENCY | 0 | 0 | 0 | 0 |
| DUMP_LOG_COORDINATOR_QUEUE | 0 | 0 | 0 | 0 |
| LOWFAIL_MEMMGR_QUEUE | 0 | 0 | 0 | 0 |
| ONDEMAND_TASK_QUEUE | 1 | 0 | 0 | 0 |
| SOS_VIRTUALMEMORY_LOW | 0 | 0 | 0 | 0 |
| SOS_CALLBACK_REMOVAL | 0 | 0 | 0 | 0 |
| SOS_MEMORY_TOPLEVELBLOCKALLOCATOR | 0 | 0 | 0 | 0 |
| DEBUG | 0 | 0 | 0 | 0 |
| REPLICA_WRITES | 0 | 0 | 0 | 0 |
| DBMIRRORING_CMD | 0 | 0 | 0 | 0 |
| WAIT_FOR_RESULTS | 0 | 0 | 0 | 0 |
| DBMIRROR_DBM_MUTEX | 0 | 0 | 0 | 0 |
| DBMIRROR_DBM_EVENT | 0 | 0 | 0 | 0 |
| DBMIRROR_SEND | 0 | 0 | 0 | 0 |
| DBMIRROR_EVENTS_QUEUE | 0 | 0 | 0 | 0 |
| DBMIRROR_WORKER_QUEUE | 0 | 0 | 0 | 0 |
| HTTP_START | 0 | 0 | 0 | 0 |
| HTTP_ENUMERATION | 0 | 0 | 0 | 0 |
| SOAP_READ | 0 | 0 | 0 | 0 |
| SOAP_WRITE | 0 | 0 | 0 | 0 |
| DUMP_LOG_COORDINATOR | 0 | 0 | 0 | 0 |
| DISKIO_SUSPEND | 0 | 0 | 0 | 0 |
| IMPPROV_IOWAIT | 0 | 0 | 0 | 0 |
| DEADLOCK_TASK_SEARCH | 0 | 0 | 0 | 0 |
| REPL_SCHEMA_ACCESS | 0 | 0 | 0 | 0 |
| REPL_CACHE_ACCESS | 0 | 0 | 0 | 0 |
| KSOURCE_WAKEUP | 1 | 0 | 0 | 0 |
| SQLSORT_SORTMUTEX | 0 | 0 | 0 | 0 |
| SQLSORT_NORMMUTEX | 0 | 0 | 0 | 0 |
| SQLTRACE_WAIT_ENTRIES | 0 | 0 | 0 | 0 |
| FCB_REPLICA_WRITE | 0 | 0 | 0 | 0 |
| FCB_REPLICA_READ | 0 | 0 | 0 | 0 |
| EXCHANGE | 0 | 0 | 0 | 0 |
| EC | 0 | 0 | 0 | 0 |
| TEMPOBJ | 0 | 0 | 0 | 0 |
| XACTLOCKINFO | 0 | 0 | 0 | 0 |
| LOGMGR | 0 | 0 | 0 | 0 |
| SQLTRACE_SHUTDOWN | 0 | 0 | 0 | 0 |
| QUERY_TRACEOUT | 0 | 0 | 0 | 0 |
| DTC_STATE | 0 | 0 | 0 | 0 |
| BROKER_TRANSMITTER | 2 | 0 | 0 | 0 |
| BROKER_SERVICE | 0 | 0 | 0 | 0 |
| BROKER_SHUTDOWN | 0 | 0 | 0 | 0 |
| BROKER_MASTERSTART | 1 | 0 | 0 | 0 |
| BROKER_REGISTERALLENDPOINTS | 0 | 0 | 0 | 0 |
| DTCPNTSYNC | 0 | 0 | 0 | 0 |
| SOSHOST_INTERNAL | 0 | 0 | 0 | 0 |
| SOSHOST_SLEEP | 0 | 0 | 0 | 0 |
| SOSHOST_WAITFORDONE | 0 | 0 | 0 | 0 |
| SOSHOST_MUTEX | 0 | 0 | 0 | 0 |
| SOSHOST_EVENT | 0 | 0 | 0 | 0 |
| SOSHOST_SEMAPHORE | 0 | 0 | 0 | 0 |
| SOSHOST_RWLOCK | 0 | 0 | 0 | 0 |
| SOSHOST_TRACELOCK | 0 | 0 | 0 | 0 |
| HTREPARTITION | 0 | 0 | 0 | 0 |
| HTBUILD | 0 | 0 | 0 | 0 |
| HTMEMO | 0 | 0 | 0 | 0 |
| HTDELETE | 0 | 0 | 0 | 0 |
| HTREINIT | 0 | 0 | 0 | 0 |
| BMPREPARTITION | 0 | 0 | 0 | 0 |
| BMPALLOCATION | 0 | 0 | 0 | 0 |
| BMPREPLICATION | 0 | 0 | 0 | 0 |
| BMPBUILD | 0 | 0 | 0 | 0 |
| SHUTDOWN | 0 | 0 | 0 | 0 |
| SLEEP_TEMPDBSTARTUP | 0 | 0 | 0 | 0 |
| DBSTATE | 0 | 0 | 0 | 0 |
| SLEEP_MASTERMDREADY | 0 | 0 | 0 | 0 |
| SLEEP_MASTERUPGRADED | 0 | 0 | 0 | 0 |
| RESOURCE_SEMAPHORE | 0 | 0 | 0 | 0 |
| DTC | 0 | 0 | 0 | 0 |
| OLEDB | 0 | 0 | 0 | 0 |
| FAILPOINT | 0 | 0 | 0 | 0 |
| RESOURCE_QUEUE | 0 | 0 | 0 | 0 |
| ASYNC_DISKPOOL_LOCK | 1 | 0 | 0 | 0 |
| PAGEIOLATCH_DT | 0 | 0 | 0 | 0 |
| TRAN_MARKLATCH_NL | 0 | 0 | 0 | 0 |
| TRAN_MARKLATCH_KP | 0 | 0 | 0 | 0 |
| TRAN_MARKLATCH_SH | 0 | 0 | 0 | 0 |
| TRAN_MARKLATCH_UP | 0 | 0 | 0 | 0 |
| TRAN_MARKLATCH_EX | 0 | 0 | 0 | 0 |
| TRAN_MARKLATCH_DT | 0 | 0 | 0 | 0 |
| LCK_M_IS | 0 | 0 | 0 | 0 |
| LCK_M_IU | 0 | 0 | 0 | 0 |
| LATCH_UP | 0 | 0 | 0 | 0 |
| MISCELLANEOUS | 0 | 0 | 0 | 0 |
| LCK_M_SCH_S | 0 | 0 | 0 | 0 |
| LATCH_DT | 0 | 0 | 0 | 0 |
| PAGELATCH_NL | 0 | 0 | 0 | 0 |
| PAGELATCH_KP | 0 | 0 | 0 | 0 |
| PAGELATCH_DT | 0 | 0 | 0 | 0 |
| PAGEIOLATCH_NL | 0 | 0 | 0 | 0 |
| PAGEIOLATCH_KP | 0 | 0 | 0 | 0 |
| LCK_M_SIU | 0 | 0 | 0 | 0 |
| LCK_M_SIX | 0 | 0 | 0 | 0 |
| LCK_M_UIX | 0 | 0 | 0 | 0 |
| LCK_M_BU | 0 | 0 | 0 | 0 |
| LCK_M_RS_S | 0 | 0 | 0 | 0 |
| LCK_M_RS_U | 0 | 0 | 0 | 0 |
| LCK_M_RIn_NL | 0 | 0 | 0 | 0 |
| LCK_M_RIn_S | 0 | 0 | 0 | 0 |
| LCK_M_RIn_U | 0 | 0 | 0 | 0 |
| LCK_M_RIn_X | 0 | 0 | 0 | 0 |
| LCK_M_RX_S | 0 | 0 | 0 | 0 |
| LCK_M_RX_U | 0 | 0 | 0 | 0 |
| LCK_M_RX_X | 0 | 0 | 0 | 0 |
| LATCH_NL | 0 | 0 | 0 | 0 |
| LATCH_KP | 0 | 0 | 0 | 0 |
| XE_SERVICES_RWLOCK | 0 | 0 | 0 | 0 |
| XE_SERVICES_EVENTMANUAL | 0 | 0 | 0 | 0 |
| XE_OLS_LOCK | 0 | 0 | 0 | 0 |
| SOS_DISPATCHER_MUTEX | 0 | 0 | 0 | 0 |
| XE_BUFFERMGR_FREEBUF_EVENT | 0 | 0 | 0 | 0 |
| XE_MODULEMGR_SYNC | 0 | 0 | 0 | 0 |
| XE_STM_CREATE | 0 | 0 | 0 | 0 |
| XE_SESSION_SYNC | 0 | 0 | 0 | 0 |
| XE_SESSION_CREATE_SYNC | 0 | 0 | 0 | 0 |
| BROKER_TASK_SHUTDOWN | 0 | 0 | 0 | 0 |
| BROKER_TASK_SUBMIT | 0 | 0 | 0 | 0 |
| SNI_TASK_COMPLETION | 1 | 0 | 0 | 0 |
| SNI_LISTENER_ACCESS | 0 | 0 | 0 | 0 |
| EXECUTION_PIPE_EVENT_INTERNAL | 0 | 0 | 0 | 0 |
| CLR_MEMORY_SPY | 0 | 0 | 0 | 0 |
| CLRHOST_STATE_ACCESS | 0 | 0 | 0 | 0 |
| ASSEMBLY_LOAD | 0 | 0 | 0 | 0 |
| VIA_ACCEPT | 0 | 0 | 0 | 0 |
| CHECK_PRINT_RECORD | 0 | 0 | 0 | 0 |
| INTERNAL_TESTING | 0 | 0 | 0 | 0 |
| SCAN_CHAR_HASH_ARRAY_INITIALIZATION | 0 | 0 | 0 | 0 |
| FS_GARBAGE_COLLECTOR_SHUTDOWN | 0 | 0 | 0 | 0 |
| FSAGENT | 0 | 0 | 0 | 0 |
| FILESTREAM_WORKITEM_QUEUE | 0 | 0 | 0 | 0 |
| FILESTREAM_FILE_OBJECT | 0 | 0 | 0 | 0 |
| FILESTREAM_FCB | 0 | 0 | 0 | 0 |
| FILESTREAM_CACHE | 0 | 0 | 0 | 0 |
| ABR | 0 | 0 | 0 | 0 |
| WCC | 0 | 0 | 0 | 0 |
| DUMPTRIGGER | 0 | 0 | 0 | 0 |
| TIMEPRIV_TIMEPERIOD | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_VERIFYSIGNATURE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_AUTHZGETINFORMATIONFROMCONTEXT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSID | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_AUTHZINITIALIZERESOURCEMANAGER | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_ENCRYPTMESSAGE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_FREECREDENTIALSHANDLE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_INITIALIZESECURITYCONTEXT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_LOGONUSER | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_QUERYSECURITYCONTEXTTOKEN | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_ACCEPTSECURITYCONTEXT | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_ACQUIRECREDENTIALSHANDLE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_COMPLETEAUTHTOKEN | 0 | 0 | 0 | 0 |
| XE_DISPATCHER_JOIN | 0 | 0 | 0 | 0 |
| XE_TIMER_MUTEX | 0 | 0 | 0 | 0 |
| XE_TIMER_TASK_DONE | 0 | 0 | 0 | 0 |
| XE_DISPATCHER_CONFIG_SESSION_LIST | 0 | 0 | 0 | 0 |
| XE_SESSION_FLUSH | 0 | 0 | 0 | 0 |
| XE_CALLBACK_LIST | 0 | 0 | 0 | 0 |
| NODE_CACHE_MUTEX | 0 | 0 | 0 | 0 |
| RG_RECONFIG | 0 | 0 | 0 | 0 |
| RESMGR_THROTTLED | 0 | 0 | 0 | 0 |
| SOS_MEMORY_USAGE_ADJUSTMENT | 0 | 0 | 0 | 0 |
| SECURITY_MUTEX | 0 | 0 | 0 | 0 |
| FS_HEADER_RWLOCK | 0 | 0 | 0 | 0 |
| FS_LOGTRUNC_RWLOCK | 0 | 0 | 0 | 0 |
| FS_FC_RWLOCK | 0 | 0 | 0 | 0 |
| FSTR_CONFIG_RWLOCK | 0 | 0 | 0 | 0 |
| FSTR_CONFIG_MUTEX | 0 | 0 | 0 | 0 |
| FSA_FORCE_OWN_XACT | 0 | 0 | 0 | 0 |
| COMMIT_TABLE | 0 | 0 | 0 | 0 |
| CXROWSET_SYNC | 2 | 0 | 0 | 0 |
| XACT_OWN_TRANSACTION | 0 | 0 | 0 | 0 |
| XACT_RECLAIM_SESSION | 0 | 0 | 0 | 0 |
| DTC_WAITFOR_OUTCOME | 0 | 0 | 0 | 0 |
| DTC_RESOLVE | 0 | 0 | 0 | 0 |
| SEC_DROP_TEMP_KEY | 0 | 0 | 0 | 0 |
| SRVPROC_SHUTDOWN | 0 | 0 | 0 | 0 |
| BROKER_INIT | 0 | 0 | 0 | 0 |
| BROKER_CONNECTION_RECEIVE_TASK | 0 | 0 | 0 | 0 |
| NET_WAITFOR_PACKET | 0 | 0 | 0 | 0 |
| DTC_ABORT_REQUEST | 0 | 0 | 0 | 0 |
| DTC_TMDOWN_REQUEST | 0 | 0 | 0 | 0 |
| RECOVER_CHANGEDB | 0 | 0 | 0 | 0 |
| WORKTBL_DROP | 0 | 0 | 0 | 0 |
| SNI_HTTP_WAITFOR_0_DISCON | 0 | 0 | 0 | 0 |
| UTIL_PAGE_ALLOC | 0 | 0 | 0 | 0 |
| SERVER_IDLE_CHECK | 0 | 0 | 0 | 0 |
| DEADLOCK_ENUM_MUTEX | 0 | 0 | 0 | 0 |
| VIEW_DEFINITION_MUTEX | 0 | 0 | 0 | 0 |
| QUERY_NOTIFICATION_MGR_MUTEX | 0 | 0 | 0 | 0 |
| QUERY_NOTIFICATION_TABLE_MGR_MUTEX | 0 | 0 | 0 | 0 |
| QUERY_NOTIFICATION_SUBSCRIPTION_MUTEX | 0 | 0 | 0 | 0 |
| QUERY_NOTIFICATION_UNITTEST_MUTEX | 0 | 0 | 0 | 0 |
| RESOURCE_SEMAPHORE_MUTEX | 0 | 0 | 0 | 0 |
| BUILTIN_HASHKEY_MUTEX | 0 | 0 | 0 | 0 |
| SOS_PROCESS_AFFINITY_MUTEX | 3 | 0 | 0 | 0 |
| MSQL_XACT_MGR_MUTEX | 0 | 0 | 0 | 0 |
| MSQL_XACT_MUTEX | 0 | 0 | 0 | 0 |
| QRY_MEM_GRANT_INFO_MUTEX | 0 | 0 | 0 | 0 |
| SNI_CRITICAL_SECTION | 6 | 0 | 0 | 0 |
| SOS_STACKSTORE_INIT_MUTEX | 0 | 0 | 0 | 0 |
| SOS_SYNC_TASK_ENQUEUE_EVENT | 2 | 0 | 0 | 0 |
| SOS_OBJECT_STORE_DESTROY_MUTEX | 0 | 0 | 0 | 0 |
| EE_PMOLOCK | 0 | 0 | 0 | 0 |
| QUERY_OPTIMIZER_PRINT_MUTEX | 0 | 0 | 0 | 0 |
| DLL_LOADING_MUTEX | 0 | 0 | 0 | 0 |
| RESOURCE_SEMAPHORE_QUERY_COMPILE | 0 | 0 | 0 | 0 |
| BROKER_ENDPOINT_STATE_MUTEX | 0 | 0 | 0 | 0 |
| QUERY_EXECUTION_INDEX_SORT_EVENT_OPEN | 0 | 0 | 0 | 0 |
| ERROR_REPORTING_MANAGER | 0 | 0 | 0 | 0 |
| EE_SPECPROC_MAP_INIT | 0 | 0 | 0 | 0 |
| FULLTEXT GATHERER | 0 | 0 | 0 | 0 |
| SEQUENTIAL_GUID | 0 | 0 | 0 | 0 |
| MSQL_DQ | 0 | 0 | 0 | 0 |
| TRANSACTION_MUTEX | 0 | 0 | 0 | 0 |
| SLEEP_MSDBSTARTUP | 0 | 0 | 0 | 0 |
| MSSEARCH | 0 | 0 | 0 | 0 |
| XACTWORKSPACE_MUTEX | 0 | 0 | 0 | 0 |
| WAITSTAT_MUTEX | 3 | 0 | 0 | 0 |
| WAITFOR_TASKSHUTDOWN | 0 | 0 | 0 | 0 |
| GUARDIAN | 0 | 0 | 0 | 0 |
| CLR_TASK_START | 0 | 0 | 0 | 0 |
| CLR_JOIN | 0 | 0 | 0 | 0 |
| CLR_CRST | 0 | 0 | 0 | 0 |
| CLR_SEMAPHORE | 0 | 0 | 0 | 0 |
| CLR_MONITOR | 0 | 0 | 0 | 0 |
| CLR_RWLOCK_READER | 0 | 0 | 0 | 0 |
| CLR_RWLOCK_WRITER | 0 | 0 | 0 | 0 |
| SQLCLR_QUANTUM_PUNISHMENT | 0 | 0 | 0 | 0 |
| SQLCLR_APPDOMAIN | 0 | 0 | 0 | 0 |
| SQLCLR_ASSEMBLY | 0 | 0 | 0 | 0 |
| KTM_ENLISTMENT | 0 | 0 | 0 | 0 |
| KTM_RECOVERY_RESOLUTION | 0 | 0 | 0 | 0 |
| KTM_RECOVERY_MANAGER | 0 | 0 | 0 | 0 |
| SQLCLR_DEADLOCK_DETECTION | 0 | 0 | 0 | 0 |
| QPJOB_WAITFOR_ABORT | 0 | 0 | 0 | 0 |
| QPJOB_KILL | 0 | 0 | 0 | 0 |
| BAD_PAGE_PROCESS | 0 | 0 | 0 | 0 |
| BACKUP_OPERATOR | 0 | 0 | 0 | 0 |
| PRINT_ROLLBACK_PROGRESS | 0 | 0 | 0 | 0 |
| ENABLE_VERSIONING | 0 | 0 | 0 | 0 |
| DISABLE_VERSIONING | 0 | 0 | 0 | 0 |
| REQUEST_DISPENSER_PAUSE | 0 | 0 | 0 | 0 |
| DROPTEMP | 0 | 0 | 0 | 0 |
| FT_RESTART_CRAWL | 0 | 0 | 0 | 0 |
| LOGMGR_RESERVE_APPEND | 0 | 0 | 0 | 0 |
| XE_LIVE_TARGET_TVF | 0 | 0 | 0 | 0 |
| QDS_TASK_SHUTDOWN | 0 | 0 | 0 | 0 |
| QDS_SHUTDOWN_QUEUE | 0 | 0 | 0 | 0 |
| PREEMPTIVE_XE_CX_FILE_OPEN | 0 | 0 | 0 | 0 |
| XE_CX_FILE_READ | 0 | 0 | 0 | 0 |
| WINFAB_API_CALL | 0 | 0 | 0 | 0 |
| PREEMPTIVE_XE_CX_HTTP_CALL | 0 | 0 | 0 | 0 |
| PWAIT_LOG_CONSOLIDATION_POLL | 0 | 0 | 0 | 0 |
| PWAIT_LOG_CONSOLIDATION_IO | 0 | 0 | 0 | 0 |
| COLUMNSTORE_BUILD_THROTTLE | 0 | 0 | 0 | 0 |
| DBSEEDING_OPERATION | 0 | 0 | 0 | 0 |
| DBSEEDING_FLOWCONTROL | 0 | 0 | 0 | 0 |
| PHYSICAL_SEEDING_DMV | 0 | 0 | 0 | 0 |
| DROP_DATABASE_TIMER_TASK | 0 | 0 | 0 | 0 |
| SNI_CONN_DUP | 0 | 0 | 0 | 0 |
| SEQUENCE_GENERATION | 0 | 0 | 0 | 0 |
| RTDATA_LIST | 0 | 0 | 0 | 0 |
| PWAIT_HADR_JOIN | 0 | 0 | 0 | 0 |
| WINFAB_REPLICA_BUILD_OPERATION | 0 | 0 | 0 | 0 |
| FABRIC_REPLICA_PUBLISHER_EVENT_PUBLISH | 0 | 0 | 0 | 0 |
| SQLTRACE_PENDING_BUFFER_WRITERS | 0 | 0 | 0 | 0 |
| PREEMPTIVE_OS_PDH_WMI_INIT | 0 | 0 | 0 | 0 |
| BROKER_TRANSMISSION_WORK | 5 | 0 | 0 | 0 |
| BROKER_TRANSMISSION_OBJECT | 0 | 0 | 0 | 0 |
| BROKER_TRANSMISSION_TABLE | 1 | 0 | 0 | 0 |
| BROKER_DISPATCHER | 0 | 0 | 0 | 0 |
| BROKER_FORWARDER | 0 | 0 | 0 | 0 |
| UCS_MANAGER | 0 | 0 | 0 | 0 |
| UCS_TRANSPORT | 0 | 0 | 0 | 0 |
| UCS_MEMORY_NOTIFICATION | 0 | 0 | 0 | 0 |
| UCS_ENDPOINT_CHANGE | 0 | 0 | 0 | 0 |
| UCS_TRANSPORT_STREAM_CHANGE | 0 | 0 | 0 | 0 |
| QUERY_TASK_ENQUEUE_MUTEX | 0 | 0 | 0 | 0 |
| SP_PREEMPTIVE_SERVER_DIAGNOSTICS_SLEEP | 0 | 0 | 0 | 0 |
| SP_SERVER_DIAGNOSTICS_INIT_MUTEX | 0 | 0 | 0 | 0 |
| DBCC_SCALE_OUT_EXPR_CACHE | 0 | 0 | 0 | 0 |
| GDMA_GET_RESOURCE_OWNER | 0 | 0 | 0 | 0 |
| UCS_SESSION_REGISTRATION | 0 | 0 | 0 | 0 |
| ENABLE_EMPTY_VERSIONING | 0 | 0 | 0 | 0 |
| HADR_DB_OP_START_SYNC | 0 | 0 | 0 | 0 |
| HADR_DB_OP_COMPLETION_SYNC | 0 | 0 | 0 | 0 |
| HADR_LOGPROGRESS_SYNC | 0 | 0 | 0 | 0 |
| HADR_TRANSPORT_DBRLIST | 0 | 0 | 0 | 0 |
| HADR_CONNECTIVITY_INFO | 0 | 0 | 0 | 0 |
| XDESTSVERMGR | 0 | 0 | 0 | 0 |
| GHOSTCLEANUPSYNCMGR | 0 | 0 | 0 | 0 |
| HADR_AR_UNLOAD_COMPLETED | 0 | 0 | 0 | 0 |
| HADR_PARTNER_SYNC | 0 | 0 | 0 | 0 |
| HADR_DBSTATECHANGE_SYNC | 0 | 0 | 0 | 0 |
| DIRTY_PAGE_SYNC | 0 | 0 | 0 | 0 |
| HTTP_STORAGE_CONNECTION | 0 | 0 | 0 | 0 |
| SECURITY_CRYPTO_CONTEXT_MUTEX | 0 | 0 | 0 | 0 |
| SECURITY_RULETABLE_MUTEX | 0 | 0 | 0 | 0 |
| SEMPLAT_DSI_BUILD | 0 | 0 | 0 | 0 |
| FILESTREAM_CHUNKER_INIT | 0 | 0 | 0 | 0 |
| FILESTREAM_CHUNKER | 0 | 0 | 0 | 0 |
| FFT_RSFX_COMM | 0 | 0 | 0 | 0 |
| FFT_RSFX_WAIT_FOR_MEMORY | 0 | 0 | 0 | 0 |
| FFT_STARTUP_SHUTDOWN | 0 | 0 | 0 | 0 |
| PWAIT_XTP_HOST_STORAGE_WAIT | 0 | 0 | 0 | 0 |
| HADR_FABRIC_CALLBACK | 0 | 0 | 0 | 0 |
| ASYNC_OP_CONTEXT_READ | 0 | 0 | 0 | 0 |
| ASYNC_OP_CONTEXT_WRITE | 0 | 0 | 0 | 0 |
| ASYNC_OP_COMPLETION | 0 | 0 | 0 | 0 |
| FABRIC_REPLICA_PUBLISHER_SUBSCRIBER_LIST | 0 | 0 | 0 | 0 |
| FABRIC_REPLICA_CONTROLLER_STATE_AND_CONFIG | 0 | 0 | 0 | 0 |
| FABRIC_REPLICA_CONTROLLER_LIST | 0 | 0 | 0 | 0 |
| FABRIC_HADR_TRANSPORT_CONNECTION | 0 | 0 | 0 | 0 |
| FABRIC_WAIT_FOR_BUILD_REPLICA_EVENT_PROCESSING | 0 | 0 | 0 | 0 |
| VDI_CLIENT_GETCOMMAND | 0 | 0 | 0 | 0 |
| VDI_CLIENT_COMPLETECOMMAND | 0 | 0 | 0 | 0 |
| VDI_CLIENT_OTHER | 0 | 0 | 0 | 0 |
| VDI_CLIENT_OPERATION | 0 | 0 | 0 | 0 |
| HADR_DBSEEDING | 0 | 0 | 0 | 0 |
| HADR_DBSEEDING_LIST | 0 | 0 | 0 | 0 |
| SLO_UPDATE | 0 | 0 | 0 | 0 |
| WAIT_XTP_RECOVERY | 0 | 0 | 0 | 0 |
| WAIT_XTP_OFFLINE_CKPT_NEW_LOG | 0 | 0 | 0 | 0 |
| WAIT_XTP_OFFLINE_CKPT_LOG_IO | 0 | 0 | 0 | 0 |
| WAIT_XTP_OFFLINE_CKPT_BEFORE_REDO | 0 | 0 | 0 | 0 |
| WAIT_XTP_PROCEDURE_ENTRY | 0 | 0 | 0 | 0 |
| WAIT_XTP_CKPT_ENABLED | 0 | 0 | 0 | 0 |
| WAIT_XTP_CKPT_AGENT_WAKEUP | 0 | 0 | 0 | 0 |
| WAIT_XTP_CKPT_CLOSE | 0 | 0 | 0 | 0 |
| WAIT_XTP_CKPT_STATE_LOCK | 0 | 0 | 0 | 0 |
| WAIT_XTP_ASYNC_TX_COMPLETION | 0 | 0 | 0 | 0 |
| LCK_M_SCH_S_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_SCH_M_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_S_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_U_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_X_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_IS_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_IU_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_IX_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_SIU_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_SIX_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_UIX_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_BU_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_RS_S_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_RS_U_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_RIn_NL_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_RIn_S_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_RIn_U_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_RIn_X_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_RX_S_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_RX_U_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_RX_X_LOW_PRIORITY | 0 | 0 | 0 | 0 |
| LCK_M_SCH_S_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_SCH_M_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_S_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_U_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_X_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_IS_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_IU_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_IX_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_SIU_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_SIX_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_UIX_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_BU_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_RS_S_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_RS_U_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_RIn_NL_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_RIn_S_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_RIn_U_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_RIn_X_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_RX_S_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_RX_U_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| LCK_M_RX_X_ABORT_BLOCKERS | 0 | 0 | 0 | 0 |
| TERMINATE_LISTENER | 0 | 0 | 0 | 0 |
| WAIT_SCRIPTDEPLOYMENT_REQUEST | 0 | 0 | 0 | 0 |
| WAIT_SCRIPTDEPLOYMENT_WORKER | 0 | 0 | 0 | 0 |
| FEATURE_SWITCHES_UPDATE | 0 | 0 | 0 | 0 |
| XTP_HOST_DB_COLLECTION | 0 | 0 | 0 | 0 |
| XTP_HOST_LOG_ACTIVITY | 0 | 0 | 0 | 0 |
| QDS_DYN_VECTOR | 0 | 0 | 0 | 0 |
| QDS_STMT | 0 | 0 | 0 | 0 |
| QDS_CTXS | 0 | 0 | 0 | 0 |
| QDS_BCKG_TASK | 0 | 0 | 0 | 0 |
| QDS_DB_DISK | 0 | 0 | 0 | 0 |
| QDS_STMT_DISK | 0 | 0 | 0 | 0 |
| QDS_ASYNC_PERSIST_TASK | 0 | 0 | 0 | 0 |
| QDS_LOADDB | 0 | 0 | 0 | 0 |
| QDS_ASYNC_PERSIST_TASK_START | 1 | 0 | 0 | 0 |
| QDS_ASYNC_CHECK_CONSISTENCY_TASK | 0 | 0 | 0 | 0 |
+-------------------------------------------------+---------------------+--------------+------------------+---------------------+
Shit sorry. Working from home with RDP to server. at 11pm. I took short cut. Thanks for formatting the output.
April 17, 2015 at 9:50 am
From a quick glance at those stats, I would check the storage layer during backups. The max wait time for PAGEIOLATCH_SH and PAGEIOLATCH_EX is about 10 seconds, which is ungodly.
April 17, 2015 at 9:59 am
When querying the wait stats, the real key is going to be getting them before and after the backup to understand where and why things are running slow. Also, to get rid of the noise, you might try using the query posted here[/url].
Of the first four interesting waits you have, writelog, async_network_io, pageiolatch_sh, and backupio, three are IO related. It suggests (doesn't say) that the problem might be disk related (not the async_network_io, that's a wait from the client side of things, possibly suggesting that there's a problem with client not consuming rows fast enough). There are several others all indicating the same thing.
I'd run the query before and after the backup to get a sense of exactly what's happening there.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 18, 2015 at 1:37 pm
baabhu (4/16/2015)
Server has a memory of 384 GB ram and we configured 372 GB ram in the SQLserver maximum memory.
I'd be granting a lot more than 12GB to the OS for a machine of this spec
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply