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.
0101Maximum recovery interval in minutes3
0102Allow updates to system tables1
0103Number of user connections allowed2
0106Number of locks for all users2
0107Number of open database objects2
0109Default fill factor percentage2
0114Disallow returning results from triggers3
1115Allow triggers to be invoked within triggers1
1116Allow recursion for server level triggers1
1117Allow remote access0
0124default language1
0400Allow cross db ownership chaining1
0503Maximum worker threads3
4096505Network packet size3
1518show advanced options1
0542Create DTC transaction for remote procedures1
0544c2 audit mode2
10331126default full-text language3
20491127two digit year cutoff3
01505Memory for index create sorts (kBytes)3
01517Priority boost2
101519remote login timeout1
6001520remote query timeout1
-11531cursor threshold3
01532set working set size2
01534user options1
01535affinity mask3
655361536Maximum size of a text field in replication.1
01537Tape retention period in days3
51538cost threshold for parallelism3
01539maximum degree of parallelism3
10241540minimum memory per query (kBytes)3
-11541maximum time to wait for query memory (s)3
01543Minimum size of server memory (MB)3
3809281544Maximum size of server memory (MB)3
01545Maximum estimated cost allowed by query governor3
01546User mode scheduler uses lightweight pooling2
01547scan for startup stored procedures2
01549affinity64 mask3
01550affinity I/O mask2
01551affinity64 I/O mask2
01555Transform noise words for full-text query3
01556Use precomputed rank for full-text query3
601557DB connection timeout for full-text protocol handler (s)3
01562CLR user code execution enabled in the server1
41563Maximum crawl ranges allowed in full-text indexing3
01564Number of reserved full-text notifications buffers3
1001565Max number of full-text notifications buffers3
01566Number of reserved full-text crawl buffers3
1001567Max number of full-text crawl buffers3
11568Enable or disable the default trace3
11569Blocked process reporting threshold3
01570Recovery policy for DTC transactions with unknown outcome3
11576Dedicated Admin Connections are allowed from remote clients1
01577Common Criteria compliance mode enabled2
01578Enable or disable EKM provider3
11579Enable compression of backups by default1
01580Sets the FILESTREAM access level1
01581When this option is set, plan cache size is further reduced for single-use adhoc OLTP workload.3
01582Default hash bucket count for the access check result security cache3
01583Default quota for the access check result security cache3
01584Enable checksum of backups by default1
116384Enable or disable Agent XPs3
116386Enable or disable Database Mail XPs3
116387Enable or disable SMO and DMO XPs3
016388Enable or disable Ole Automation Procedures3
016390Enable or disable command shell3
016391Enable or disable Ad Hoc Distributed Queries3
016392Enable or disable Replication XPs3
016393Enables contained databases and contained authentication1
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_SQLBUFFERPOOL1996308965242888797512
MEMORYCLERK_SQLCLR9450368102120
MEMORYCLERK_SOSMEMMANAGER13943801244876149448
OBJECTSTORE_LOCK_MANAGER105062410506240
MEMORYCLERK_SQLSTORENG979209792
MEMORYCLERK_XE_BUFFER588858880
MEMORYCLERK_XE_BUFFER294429440
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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_msdesc.
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_typewaiting_tasks_countwait_time_msmax_wait_time_mssignal_wait_time_ms
SP_SERVER_DIAGNOSTICS_SLEEP712589753939960473000095393996047
LAZYWRITER_SLEEP882957602536930900120155581247
CLR_AUTO_EVENT6053171896706838623290
SLEEP_TASK431480021404677583350001612697
DISPATCHER_QUEUE_SEMAPHORE2434038429042185557192655220797
QDS_PERSIST_TASK_MAIN_LOOP_SLEEP44955269737494860019564
QDS_CLEANUP_STALE_QUERIES_TASK_MAIN_LOOP_SLEEP449552697374212600151022
DIRTY_PAGE_POLL25645269269736898929629625
HADR_FILESTREAM_IOMGR_IOCOMPLETION5389746269735794052632898
XE_DISPATCHER_WAIT2078852697297089649990
XE_TIMER_EVENT737273269723389351872697228158
SQLTRACE_INCREMENTAL_FLUSH_SLEEP674098269699621641721282
REQUEST_FOR_DEADLOCK_SEARCH2687678269607204650102696072046
LOGMGR_QUEUE58225988026848328612153462561
FT_IFTS_SCHEDULER_IDLE_WAIT44583267505241560018579
BROKER_EVENTHANDLER2182663278164804186503
CHECKPOINT_QUEUE4382826353923263892035825
BROKER_TO_FLUSH13112181348632581104415151
WRITELOG615569938133508273262177634740
ASYNC_NETWORK_IO18755818326281722540001931975
PAGEIOLATCH_SH341494962218980381006889443
BACKUPIO4834534518527418023748183405
BROKER_TASK_STOP28180153280481100161029
BACKUPBUFFER460640721226248282073371841
ASYNC_IO_COMPLETION34011590609257515273
PAGEIOLATCH_EX172550911049648231003549516
BACKUPTHREAD48511484922571483005701
BROKER_RECEIVE_WAITFOR140414500775999852
TRACEWRITE12919504023734320061557253
LATCH_SH68220811795747219276053
THREADPOOL19618676536629172
LOGBUFFER645525255801620112571
PAGEIOLATCH_UP2161464930732964316713
CXPACKET741394202010331561198
SLEEP_BPOOL_FLUSH559822620243494542447
SOS_SCHEDULER_YIELD5186309311482712141118358
PAGELATCH_EX5446540110882512341558860
LCK_M_S12636737032698253
PREEMPTIVE_OS_FILEOPS25595587409197730
MSQL_XP9105641951164450
PREEMPTIVE_OS_WRITEFILE4337739156210530
PREEMPTIVE_XE_GETTARGETSTATE1441253809252630
LCK_M_IX8321631359545021105
PREEMPTIVE_OS_AUTHENTICATIONOPS25084832269602180
PREEMPTIVE_OS_GETFILEATTRIBUTES2919319554617410
LCK_M_U192156326100135
LATCH_EX15919714928813915923
PAGELATCH_UP3128811526095051150
PAGELATCH_SH180390686318592719589
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY476618778272450
PREEMPTIVE_OS_CRYPTOPS1905092774642320
PREEMPTIVE_OS_CLOSEHANDLE4990587364950
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT47709152559170
PREEMPTIVE_OS_CREATEFILE15237508774670
PREEMPTIVE_OS_GETVOLUMEPATHNAME412048967103040
WAITFOR442326300000
SLEEP_DBSTARTUP276274431008
PREEMPTIVE_OS_AUTHORIZATIONOPS65941421778200
PREEMPTIVE_OS_DELETESECURITYCONTEXT654505200656720
LCK_M_X86161121292212
PREEMPTIVE_SP_SERVER_DIAGNOSTICS51510550470
PREEMPTIVE_OS_FLUSHFILEBUFFERS1673136315470
PREEMPTIVE_OS_CRYPTIMPORTKEY47810312714180
PREEMPTIVE_OS_DECRYPTMESSAGE65453312660240
IO_COMPLETION292121189331444
WRITE_COMPLETION17841115672026
LCK_M_SCH_M3363967073751
SQLTRACE_FILE_READ_IO_COMPLETION16968694402
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE4766188383260
PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT41846441100
PWAIT_ALL_COMPONENTS_INITIALIZED4639916030
PREEMPTIVE_OS_QUERYREGISTRY449576390650
IO_AUDIT_MUTEX33814556463706
SQLTRACE_FILE_BUFFER463272267745
PREEMPTIVE_OS_REVERTTOSELF1827112229120
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES1786062218120
CHKPT1214821480
SLEEP_SYSTEMTASK1214721470
SLEEP_MASTERDBREADY1213521350
PREEMPTIVE_OS_GETDISKFREESPACE4015177640
CMEMTHREAD101981616111394
PREEMPTIVE_OS_LIBRARYOPS1112111210
PREEMPTIVE_OS_WAITFORSINGLEOBJECT302819261290
PREEMPTIVE_XE_CALLBACKEXECUTE54634182980
WAIT_XTP_HOST_WAIT37623870
PREEMPTIVE_OS_LOADLIBRARY35729460
PREEMPTIVE_OS_GENERICOPS386574240
XE_BUFFERMGR_ALLPROCESSED_EVENT406135636
SOS_PHYS_PAGE_CACHE20216136142
FT_IFTSHC_MUTEX45695680
PREEMPTIVE_OS_PIPEOPS14384380
PREEMPTIVE_OS_COMOPS13373370
EXECSYNC6753254202
PREEMPTIVE_OS_GETPROCADDRESS9105629500
BACKUP102285360
PREEMPTIVE_OS_LOOKUPACCOUNTSID832791100
SQLTRACE_FILE_WRITE_IO_COMPLETION42234130
SLEEP_DCOMSTARTUP11741740
PREEMPTIVE_XE_TARGETINIT11117750
PREEMPTIVE_OS_REPORTEVENT368110160
FFT_RECOVERY573400
LOGMGR_FLUSH1661120
PREEMPTIVE_OS_MOVEFILE2460100
PREEMPTIVE_OS_DELETEFILE1056220
PREEMPTIVE_OS_CLUSTEROPS241210
PREEMPTIVE_OS_WRITEFILEGATHER737100
PREEMPTIVE_OS_DOMAINSERVICESOPS126260
CLR_MANUAL_EVENT202620
DAC_INIT126260
XE_SERVICES_MUTEX132020
PREEMPTIVE_CLUSAPI_CLUSTERRESOURCECONTROL872030
QDS_TASK_START219190
PREEMPTIVE_FILESIZEGET631600
PREEMPTIVE_XE_SESSIONCOMMIT26980
PREEMPTIVE_OS_SETFILEVALIDDATA6810
PARALLEL_BACKUP_QUEUE1297605
PREEMPTIVE_OS_SQMLAUNCH32100
PREEMPTIVE_TESTING0000
PREEMPTIVE_SOSHOST0000
PREEMPTIVE_SOSTESTING0000
PREEMPTIVE_XETESTING0000
PREEMPTIVE_SB_STOPENDPOINT1000
PREEMPTIVE_STARTRM0000
PREEMPTIVE_GETRMINFO0000
PREEMPTIVE_SETRMINFO0000
PREEMPTIVE_ROLLFORWARDREDO0000
PREEMPTIVE_ROLLFORWARDUNDO0000
PREEMPTIVE_RESIZELOG0000
PREEMPTIVE_REENLIST0000
PREEMPTIVE_TRANSIMPORT0000
PREEMPTIVE_UNMARSHALPROPAGATIONTOKEN0000
PREEMPTIVE_CREATEPARAM0000
PREEMPTIVE_STREAMFCB_RECOVER0000
PREEMPTIVE_STREAMFCB_CHECKPOINT0000
PREEMPTIVE_CLOSEBACKUPMEDIA0000
PREEMPTIVE_CLOSEBACKUPTAPE0000
PREEMPTIVE_CLOSEBACKUPVDIDEVICE0000
PREEMPTIVE_OS_VSSOPS0000
PREEMPTIVE_VSS_CREATESNAPSHOT0000
PREEMPTIVE_VSS_CREATEVOLUMESNAPSHOT0000
PREEMPTIVE_DFSADDLINK0000
PREEMPTIVE_DFSLINKEXISTCHECK0000
PREEMPTIVE_DFSLINKHEALTHCHECK0000
PREEMPTIVE_DFSREMOVELINK0000
PREEMPTIVE_DFSREMOVEROOT0000
PREEMPTIVE_DFSROOTFOLDERCHECK0000
PREEMPTIVE_DFSROOTINIT0000
PREEMPTIVE_DFSROOTSHARECHECK0000
PREEMPTIVE_OLE_UNINIT0000
PREEMPTIVE_FSAOLEDB_ABORTTRANSACTION0000
PREEMPTIVE_FSAOLEDB_COMMITTRANSACTION0000
PREEMPTIVE_FSAOLEDB_STARTTRANSACTION0000
PREEMPTIVE_FSRECOVER_UNCONDITIONALUNDO0000
PREEMPTIVE_SERVER_STARTUP0000
PREEMPTIVE_SHAREDMEM_GETDATA0000
PREEMPTIVE_CONSOLEWRITE0000
PREEMPTIVE_OS_BACKUPREAD0000
PREEMPTIVE_OS_FREELIBRARY0000
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0000
PREEMPTIVE_OS_PROCESSOPS0000
PREEMPTIVE_OS_SECURITYOPS0000
PREEMPTIVE_OS_SERVICEOPS0000
PREEMPTIVE_OS_SQLCLROPS0000
PREEMPTIVE_OS_WINSOCKOPS0000
PREEMPTIVE_OS_GETADDRINFO0000
PREEMPTIVE_OS_WSASETLASTERROR0000
PREEMPTIVE_OS_FORMATMESSAGE0000
PREEMPTIVE_OS_GETFILESIZE0000
PREEMPTIVE_OS_GETLONGPATHNAME0000
PREEMPTIVE_OS_OPENDIRECTORY0000
PREEMPTIVE_OS_REMOVEDIRECTORY0000
PREEMPTIVE_OS_SETENDOFFILE0000
PREEMPTIVE_OS_SETFILEPOINTER0000
PREEMPTIVE_OS_MESSAGEQUEUEOPS0000
PREEMPTIVE_ODBCOPS0000
PREEMPTIVE_OLEDBOPS0000
PREEMPTIVE_OLEDB_ABORTTRAN0000
PREEMPTIVE_OLEDB_ABORTORCOMMITTRAN0000
PREEMPTIVE_OLEDB_GETDATASOURCE0000
PREEMPTIVE_OLEDB_GETLITERALINFO0000
PREEMPTIVE_OLEDB_GETPROPERTIES0000
PREEMPTIVE_OLEDB_GETPROPERTYINFO0000
PREEMPTIVE_OLEDB_GETSCHEMALOCK0000
PREEMPTIVE_OLEDB_JOINTRANSACTION0000
PREEMPTIVE_OLEDB_RELEASE0000
PREEMPTIVE_OLEDB_SETPROPERTIES0000
PREEMPTIVE_OS_GETCOMPRESSEDFILESIZE0000
PREEMPTIVE_OS_DEVICEIOCONTROL0000
PREEMPTIVE_OS_FINDFILE0000
PREEMPTIVE_OS_SETNAMEDSECURITYINFO0000
PREEMPTIVE_OS_COPYFILE0000
PREEMPTIVE_OS_CREATEDIRECTORY0000
PREEMPTIVE_OS_DTCOPS0000
PREEMPTIVE_DTC_ABORT0000
PREEMPTIVE_DTC_ABORTREQUESTDONE0000
PREEMPTIVE_DTC_BEGINTRANSACTION0000
PREEMPTIVE_DTC_COMMITREQUESTDONE0000
PREEMPTIVE_DTC_ENLIST0000
PREEMPTIVE_DTC_PREPAREREQUESTDONE0000
PREEMPTIVE_OS_DEVICEOPS0000
PREEMPTIVE_OS_RSFXDEVICEOPS0000
PREEMPTIVE_OS_DIRSVC_NETWORKOPS0000
PREEMPTIVE_OS_DSGETDCNAME0000
PREEMPTIVE_OS_NETGROUPGETUSERS0000
PREEMPTIVE_OS_NETLOCALGROUPGETMEMBERS0000
PREEMPTIVE_OS_NETUSERGETGROUPS0000
PREEMPTIVE_OS_NETUSERGETLOCALGROUPS0000
PREEMPTIVE_OS_NETUSERMODALSGET0000
PREEMPTIVE_COM_COCREATEINSTANCE0000
PREEMPTIVE_COM_COGETCLASSOBJECT0000
PREEMPTIVE_COM_CREATEACCESSOR0000
PREEMPTIVE_COM_DELETEROWS0000
PREEMPTIVE_COM_GETCOMMANDTEXT0000
PREEMPTIVE_COM_GETDATA0000
PREEMPTIVE_COM_GETNEXTROWS0000
PREEMPTIVE_COM_GETRESULT0000
PREEMPTIVE_COM_GETROWSBYBOOKMARK0000
PREEMPTIVE_COM_LBFLUSH0000
PREEMPTIVE_COM_LBLOCKREGION0000
PREEMPTIVE_COM_LBREADAT0000
PREEMPTIVE_COM_LBSETSIZE0000
PREEMPTIVE_COM_LBSTAT0000
PREEMPTIVE_COM_LBUNLOCKREGION0000
PREEMPTIVE_COM_LBWRITEAT0000
PREEMPTIVE_COM_QUERYINTERFACE0000
PREEMPTIVE_COM_RELEASE0000
PREEMPTIVE_COM_RELEASEACCESSOR0000
PREEMPTIVE_COM_RELEASEROWS0000
PREEMPTIVE_COM_RELEASESESSION0000
PREEMPTIVE_COM_RESTARTPOSITION0000
PREEMPTIVE_COM_SEQSTRMREAD0000
PREEMPTIVE_COM_SEQSTRMREADANDWRITE0000
PREEMPTIVE_COM_SETDATAFAILURE0000
PREEMPTIVE_COM_SETPARAMETERINFO0000
PREEMPTIVE_COM_SETPARAMETERPROPERTIES0000
PREEMPTIVE_COM_STRMLOCKREGION0000
PREEMPTIVE_COM_STRMSEEKANDREAD0000
PREEMPTIVE_COM_STRMSEEKANDWRITE0000
PREEMPTIVE_COM_STRMSETSIZE0000
PREEMPTIVE_COM_STRMSTAT0000
PREEMPTIVE_COM_STRMUNLOCKREGION0000
PREEMPTIVE_XE_TARGETFINALIZE6000
PREEMPTIVE_XE_DISPATCHER1000
PREEMPTIVE_XE_ENGINEINIT0000
AUDIT_XE_SESSION_MGR0000
AUDIT_ON_DEMAND_TARGET_LOCK0000
PWAIT_PREEMPTIVE_AUDIT_ACCESS_WINDOWSLOG0000
AUDIT_LOGINCACHE_LOCK0000
AUDIT_GROUPCACHE_LOCK0000
FT_METADATA_MUTEX0000
PREEMPTIVE_XE_TIMERRUN1000
PREEMPTIVE_SNIOPEN0000
PREEMPTIVE_DEBUG0000
PREEMPTIVE_MSS_RELEASE0000
PREEMPTIVE_LOCKMONITOR1000
PREEMPTIVE_STRESSDRIVER0000
CLEAR_DB0000
PREEMPTIVE_ABR0000
LOGGENERATION0000
IO_RETRY0000
FT_IFTSISM_MUTEX0000
FT_IFTS_RWLOCK0000
FT_COMPROWSET_RWLOCK0000
FT_MASTER_MERGE0000
TRACE_EVTNOTIF0000
SOS_SMALL_PAGE_ALLOC0000
MD_LAZYCACHE_RWLOCK0000
MD_AGENT_YIELD0000
IOAFF_RANGE_QUEUE0000
REPL_HISTORYCACHE_ACCESS0000
REPL_TRANHASHTABLE_ACCESS0000
REPL_TRANTEXTINFO_ACCESS0000
REPL_TRANFSINFO_ACCESS0000
SERVER_RECONFIGURE0000
CHANGE_TRACKING_WAITFORCHANGES0000
PWAIT_MD_RELATION_CACHE0000
PWAIT_MD_SERVER_CACHE0000
PWAIT_MD_LOGIN_STATS0000
DISPATCHER_PRIORITY_QUEUE_SEMAPHORE0000
FT_PROPERTYLIST_CACHE0000
PERFORMANCE_COUNTERS_RWLOCK2000
SECURITY_KEYRING_RWLOCK0000
AM_INDBUILD_ALLOCATION0000
STARTUP_DEPENDENCY_MANAGER0000
PWAIT_SECURITY_CACHE_INVALIDATION0000
XDES_HISTORY0000
XDES_SNAPSHOT0000
FT_MASTER_MERGE_COORDINATOR0000
PWAIT_RESOURCE_SEMAPHORE_FT_PARALLEL_QUERY_SYNC0000
REDO_THREAD_PENDING_WORK0000
REDO_THREAD_SYNC0000
COUNTRECOVERYMGR0000
HADR_DB_COMMAND0000
HADR_TRANSPORT_SESSION0000
HADR_CLUSAPI_CALL0000
PWAIT_HADR_CHANGE_NOTIFIER_TERMINATION_SYNC0000
PWAIT_HADR_ACTION_COMPLETED0000
PWAIT_HADR_OFFLINE_COMPLETED0000
PWAIT_HADR_ONLINE_COMPLETED0000
PWAIT_HADR_FAILOVER_COMPLETED0000
PWAIT_HADR_WORKITEM_COMPLETED0000
HADR_WORK_POOL0000
HADR_WORK_QUEUE0000
HADR_LOGCAPTURE_SYNC0000
PWAIT_HADR_CLUSTER_INTEGRATION0000
LOGCAPTURE_LOGPOOLTRUNCPOINT0000
LOGPOOL_CACHESIZE0000
LOGPOOL_FREEPOOLS0000
LOGPOOL_REPLACEMENTSET0000
LOGPOOL_CONSUMERSET0000
LOGPOOL_MGRSET0000
LOGPOOL_CONSUMER0000
LOGPOOLREFCOUNTEDOBJECT_REFDONE0000
HADR_SYNC_COMMIT0000
HADR_AG_MUTEX0000
PWAIT_HADR_SERVER_READY_CONNECTIONS0000
HADR_FILESTREAM_MANAGER0000
HADR_FILESTREAM_BLOCK_FLUSH0000
HADR_FILESTREAM_IOMGR0000
FFT_NSO_FCB0000
FFT_NSO_FCB_PARENT0000
FFT_NSO_FCB_FIND0000
FFT_NSO_FCB_RELEASE_CACHED_ENTRIES0000
FFT_NSO_FILEOBJECT0000
FFT_NSO_DB_LIST0000
FFT_NSO_DB_KILL_FLAG0000
FFT_NSO_TABLE_LIST0000
FFT_STORE_DB0000
FFT_STORE_TABLE0000
FFT_STORE_ROWSET_LIST0000
FFT_NTFS_STORE0000
HADR_FILESTREAM_FILE_REQUEST0000
PWAIT_MD_UPGRADE_CONFIG0000
PWAIT_COOP_SCAN0000
QRY_PARALLEL_THREAD_MUTEX0000
PWAIT_QRY_BPMEMORY0000
WAITFOR_PER_QUEUE0000
CREATE_DATINISERVICE0000
AM_SCHEMAMGR_UNSHARED_CACHE0000
HADR_REPLICAINFO_SYNC0000
HADR_COMPRESSED_CACHE_SYNC0000
HADR_AR_MANAGER_MUTEX0000
HADR_NOTIFICATION_WORKER_TERMINATION_SYNC0000
HADR_NOTIFICATION_DEQUEUE0000
HADR_ARCONTROLLER_NOTIFICATIONS_SUBSCRIBER_LIST0000
HADR_DBR_SUBSCRIBER_FILTER_LIST0000
HADR_DBR_SUBSCRIBER0000
HADR_NOTIFICATION_WORKER_STARTUP_SYNC0000
HADR_NOTIFICATION_WORKER_EXCLUSIVE_ACCESS0000
HADR_RECOVERY_WAIT_FOR_UNDO0000
HADR_DATABASE_WAIT_FOR_RESTART0000
HADR_XRF_STACK_ACCESS0000
HADR_RECOVERY_WAIT_FOR_CONNECTION0000
HADR_TRANSPORT_FLOW_CONTROL0000
HADR_DATABASE_FLOW_CONTROL0000
PWAIT_HADR_POST_ONLINE_COMPLETED0000
HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING0000
XDES_OUT_OF_ORDER_LIST0000
HADR_BACKUP_BULK_LOCK0000
HADR_BACKUP_QUEUE0000
HADR_LOGCAPTURE_WAIT0000
HADR_AR_CRITICAL_SECTION_ENTRY0000
HADR_TDS_LISTENER_SYNC0000
HADR_READ_ALL_NETWORKS0000
HADR_TDS_LISTENER_SYNC_PROCESSING0000
PWAIT_XTP_FSSTORAGE_MAINTENANCE0000
WAIT_XTP_GUEST0000
WAIT_XTP_TASK_SHUTDOWN0000
XTPPROC_PARTITIONED_STACK_CREATE0000
PREEMPTIVE_HADR_LEASE_MECHANISM0000
HADR_TIMER_TASK0000
PWAIT_EVENT_SESSION_INIT_MUTEX0000
PWAIT_REPLICA_ONLINE_INIT_MUTEX0000
HADR_GROUP_COMMIT0000
HADR_SYNCHRONIZING_THROTTLE0000
HADR_DATABASE_VERSIONING_STATE0000
XTPPROC_CACHE_ACCESS0000
SP_SERVER_DIAGNOSTICS_BUFFER_ACCESS0000
RESOURCE_GOVERNOR_IDLE0000
HADR_FILESTREAM_FILE_CLOSE0000
VERSIONING_COMMITTING0000
FILETABLE_SHUTDOWN0000
PRU_ROLLBACK_DEFERRED0000
WAIT_XTP_TRAN_DEPENDENCY0000
DUMP_LOG_COORDINATOR_QUEUE0000
LOWFAIL_MEMMGR_QUEUE0000
ONDEMAND_TASK_QUEUE1000
SOS_VIRTUALMEMORY_LOW0000
SOS_CALLBACK_REMOVAL0000
SOS_MEMORY_TOPLEVELBLOCKALLOCATOR0000
DEBUG0000
REPLICA_WRITES0000
DBMIRRORING_CMD0000
WAIT_FOR_RESULTS0000
DBMIRROR_DBM_MUTEX0000
DBMIRROR_DBM_EVENT0000
DBMIRROR_SEND0000
DBMIRROR_EVENTS_QUEUE0000
DBMIRROR_WORKER_QUEUE0000
HTTP_START0000
HTTP_ENUMERATION0000
SOAP_READ0000
SOAP_WRITE0000
DUMP_LOG_COORDINATOR0000
DISKIO_SUSPEND0000
IMPPROV_IOWAIT0000
DEADLOCK_TASK_SEARCH0000
REPL_SCHEMA_ACCESS0000
REPL_CACHE_ACCESS0000
KSOURCE_WAKEUP1000
SQLSORT_SORTMUTEX0000
SQLSORT_NORMMUTEX0000
SQLTRACE_WAIT_ENTRIES0000
FCB_REPLICA_WRITE0000
FCB_REPLICA_READ0000
EXCHANGE0000
EC0000
TEMPOBJ0000
XACTLOCKINFO0000
LOGMGR0000
SQLTRACE_SHUTDOWN0000
QUERY_TRACEOUT0000
DTC_STATE0000
BROKER_TRANSMITTER2000
BROKER_SERVICE0000
BROKER_SHUTDOWN0000
BROKER_MASTERSTART1000
BROKER_REGISTERALLENDPOINTS0000
DTCPNTSYNC0000
SOSHOST_INTERNAL0000
SOSHOST_SLEEP0000
SOSHOST_WAITFORDONE0000
SOSHOST_MUTEX0000
SOSHOST_EVENT0000
SOSHOST_SEMAPHORE0000
SOSHOST_RWLOCK0000
SOSHOST_TRACELOCK0000
HTREPARTITION0000
HTBUILD0000
HTMEMO0000
HTDELETE0000
HTREINIT0000
BMPREPARTITION0000
BMPALLOCATION0000
BMPREPLICATION0000
BMPBUILD0000
SHUTDOWN0000
SLEEP_TEMPDBSTARTUP0000
DBSTATE0000
SLEEP_MASTERMDREADY0000
SLEEP_MASTERUPGRADED0000
RESOURCE_SEMAPHORE0000
DTC0000
OLEDB0000
FAILPOINT0000
RESOURCE_QUEUE0000
ASYNC_DISKPOOL_LOCK1000
PAGEIOLATCH_DT0000
TRAN_MARKLATCH_NL0000
TRAN_MARKLATCH_KP0000
TRAN_MARKLATCH_SH0000
TRAN_MARKLATCH_UP0000
TRAN_MARKLATCH_EX0000
TRAN_MARKLATCH_DT0000
LCK_M_IS0000
LCK_M_IU0000
LATCH_UP0000
MISCELLANEOUS0000
LCK_M_SCH_S0000
LATCH_DT0000
PAGELATCH_NL0000
PAGELATCH_KP0000
PAGELATCH_DT0000
PAGEIOLATCH_NL0000
PAGEIOLATCH_KP0000
LCK_M_SIU0000
LCK_M_SIX0000
LCK_M_UIX0000
LCK_M_BU0000
LCK_M_RS_S0000
LCK_M_RS_U0000
LCK_M_RIn_NL0000
LCK_M_RIn_S0000
LCK_M_RIn_U0000
LCK_M_RIn_X0000
LCK_M_RX_S0000
LCK_M_RX_U0000
LCK_M_RX_X0000
LATCH_NL0000
LATCH_KP0000
XE_SERVICES_RWLOCK0000
XE_SERVICES_EVENTMANUAL0000
XE_OLS_LOCK0000
SOS_DISPATCHER_MUTEX0000
XE_BUFFERMGR_FREEBUF_EVENT0000
XE_MODULEMGR_SYNC0000
XE_STM_CREATE0000
XE_SESSION_SYNC0000
XE_SESSION_CREATE_SYNC0000
BROKER_TASK_SHUTDOWN0000
BROKER_TASK_SUBMIT0000
SNI_TASK_COMPLETION1000
SNI_LISTENER_ACCESS0000
EXECUTION_PIPE_EVENT_INTERNAL0000
CLR_MEMORY_SPY0000
CLRHOST_STATE_ACCESS0000
ASSEMBLY_LOAD0000
VIA_ACCEPT0000
CHECK_PRINT_RECORD0000
INTERNAL_TESTING0000
SCAN_CHAR_HASH_ARRAY_INITIALIZATION0000
FS_GARBAGE_COLLECTOR_SHUTDOWN0000
FSAGENT0000
FILESTREAM_WORKITEM_QUEUE0000
FILESTREAM_FILE_OBJECT0000
FILESTREAM_FCB0000
FILESTREAM_CACHE0000
ABR0000
WCC0000
DUMPTRIGGER0000
TIMEPRIV_TIMEPERIOD0000
PREEMPTIVE_OS_VERIFYSIGNATURE0000
PREEMPTIVE_OS_AUTHZGETINFORMATIONFROMCONTEXT0000
PREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSID0000
PREEMPTIVE_OS_AUTHZINITIALIZERESOURCEMANAGER0000
PREEMPTIVE_OS_ENCRYPTMESSAGE0000
PREEMPTIVE_OS_FREECREDENTIALSHANDLE0000
PREEMPTIVE_OS_INITIALIZESECURITYCONTEXT0000
PREEMPTIVE_OS_LOGONUSER0000
PREEMPTIVE_OS_QUERYSECURITYCONTEXTTOKEN0000
PREEMPTIVE_OS_ACCEPTSECURITYCONTEXT0000
PREEMPTIVE_OS_ACQUIRECREDENTIALSHANDLE0000
PREEMPTIVE_OS_COMPLETEAUTHTOKEN0000
XE_DISPATCHER_JOIN0000
XE_TIMER_MUTEX0000
XE_TIMER_TASK_DONE0000
XE_DISPATCHER_CONFIG_SESSION_LIST0000
XE_SESSION_FLUSH0000
XE_CALLBACK_LIST0000
NODE_CACHE_MUTEX0000
RG_RECONFIG0000
RESMGR_THROTTLED0000
SOS_MEMORY_USAGE_ADJUSTMENT0000
SECURITY_MUTEX0000
FS_HEADER_RWLOCK0000
FS_LOGTRUNC_RWLOCK0000
FS_FC_RWLOCK0000
FSTR_CONFIG_RWLOCK0000
FSTR_CONFIG_MUTEX0000
FSA_FORCE_OWN_XACT0000
COMMIT_TABLE0000
CXROWSET_SYNC2000
XACT_OWN_TRANSACTION0000
XACT_RECLAIM_SESSION0000
DTC_WAITFOR_OUTCOME0000
DTC_RESOLVE0000
SEC_DROP_TEMP_KEY0000
SRVPROC_SHUTDOWN0000
BROKER_INIT0000
BROKER_CONNECTION_RECEIVE_TASK0000
NET_WAITFOR_PACKET0000
DTC_ABORT_REQUEST0000
DTC_TMDOWN_REQUEST0000
RECOVER_CHANGEDB0000
WORKTBL_DROP0000
SNI_HTTP_WAITFOR_0_DISCON0000
UTIL_PAGE_ALLOC0000
SERVER_IDLE_CHECK0000
DEADLOCK_ENUM_MUTEX0000
VIEW_DEFINITION_MUTEX0000
QUERY_NOTIFICATION_MGR_MUTEX0000
QUERY_NOTIFICATION_TABLE_MGR_MUTEX0000
QUERY_NOTIFICATION_SUBSCRIPTION_MUTEX0000
QUERY_NOTIFICATION_UNITTEST_MUTEX0000
RESOURCE_SEMAPHORE_MUTEX0000
BUILTIN_HASHKEY_MUTEX0000
SOS_PROCESS_AFFINITY_MUTEX3000
MSQL_XACT_MGR_MUTEX0000
MSQL_XACT_MUTEX0000
QRY_MEM_GRANT_INFO_MUTEX0000
SNI_CRITICAL_SECTION6000
SOS_STACKSTORE_INIT_MUTEX0000
SOS_SYNC_TASK_ENQUEUE_EVENT2000
SOS_OBJECT_STORE_DESTROY_MUTEX0000
EE_PMOLOCK0000
QUERY_OPTIMIZER_PRINT_MUTEX0000
DLL_LOADING_MUTEX0000
RESOURCE_SEMAPHORE_QUERY_COMPILE0000
BROKER_ENDPOINT_STATE_MUTEX0000
QUERY_EXECUTION_INDEX_SORT_EVENT_OPEN0000
ERROR_REPORTING_MANAGER0000
EE_SPECPROC_MAP_INIT0000
FULLTEXT GATHERER0000
SEQUENTIAL_GUID0000
MSQL_DQ0000
TRANSACTION_MUTEX0000
SLEEP_MSDBSTARTUP0000
MSSEARCH0000
XACTWORKSPACE_MUTEX0000
WAITSTAT_MUTEX3000
WAITFOR_TASKSHUTDOWN0000
GUARDIAN0000
CLR_TASK_START0000
CLR_JOIN0000
CLR_CRST0000
CLR_SEMAPHORE0000
CLR_MONITOR0000
CLR_RWLOCK_READER0000
CLR_RWLOCK_WRITER0000
SQLCLR_QUANTUM_PUNISHMENT0000
SQLCLR_APPDOMAIN0000
SQLCLR_ASSEMBLY0000
KTM_ENLISTMENT0000
KTM_RECOVERY_RESOLUTION0000
KTM_RECOVERY_MANAGER0000
SQLCLR_DEADLOCK_DETECTION0000
QPJOB_WAITFOR_ABORT0000
QPJOB_KILL0000
BAD_PAGE_PROCESS0000
BACKUP_OPERATOR0000
PRINT_ROLLBACK_PROGRESS0000
ENABLE_VERSIONING0000
DISABLE_VERSIONING0000
REQUEST_DISPENSER_PAUSE0000
DROPTEMP0000
FT_RESTART_CRAWL0000
LOGMGR_RESERVE_APPEND0000
XE_LIVE_TARGET_TVF0000
QDS_TASK_SHUTDOWN0000
QDS_SHUTDOWN_QUEUE0000
PREEMPTIVE_XE_CX_FILE_OPEN0000
XE_CX_FILE_READ0000
WINFAB_API_CALL0000
PREEMPTIVE_XE_CX_HTTP_CALL0000
PWAIT_LOG_CONSOLIDATION_POLL0000
PWAIT_LOG_CONSOLIDATION_IO0000
COLUMNSTORE_BUILD_THROTTLE0000
DBSEEDING_OPERATION0000
DBSEEDING_FLOWCONTROL0000
PHYSICAL_SEEDING_DMV0000
DROP_DATABASE_TIMER_TASK0000
SNI_CONN_DUP0000
SEQUENCE_GENERATION0000
RTDATA_LIST0000
PWAIT_HADR_JOIN0000
WINFAB_REPLICA_BUILD_OPERATION0000
FABRIC_REPLICA_PUBLISHER_EVENT_PUBLISH0000
SQLTRACE_PENDING_BUFFER_WRITERS0000
PREEMPTIVE_OS_PDH_WMI_INIT0000
BROKER_TRANSMISSION_WORK5000
BROKER_TRANSMISSION_OBJECT0000
BROKER_TRANSMISSION_TABLE1000
BROKER_DISPATCHER0000
BROKER_FORWARDER0000
UCS_MANAGER0000
UCS_TRANSPORT0000
UCS_MEMORY_NOTIFICATION0000
UCS_ENDPOINT_CHANGE0000
UCS_TRANSPORT_STREAM_CHANGE0000
QUERY_TASK_ENQUEUE_MUTEX0000
SP_PREEMPTIVE_SERVER_DIAGNOSTICS_SLEEP0000
SP_SERVER_DIAGNOSTICS_INIT_MUTEX0000
DBCC_SCALE_OUT_EXPR_CACHE0000
GDMA_GET_RESOURCE_OWNER0000
UCS_SESSION_REGISTRATION0000
ENABLE_EMPTY_VERSIONING0000
HADR_DB_OP_START_SYNC0000
HADR_DB_OP_COMPLETION_SYNC0000
HADR_LOGPROGRESS_SYNC0000
HADR_TRANSPORT_DBRLIST0000
HADR_CONNECTIVITY_INFO0000
XDESTSVERMGR0000
GHOSTCLEANUPSYNCMGR0000
HADR_AR_UNLOAD_COMPLETED0000
HADR_PARTNER_SYNC0000
HADR_DBSTATECHANGE_SYNC0000
DIRTY_PAGE_SYNC0000
HTTP_STORAGE_CONNECTION0000
SECURITY_CRYPTO_CONTEXT_MUTEX0000
SECURITY_RULETABLE_MUTEX0000
SEMPLAT_DSI_BUILD0000
FILESTREAM_CHUNKER_INIT0000
FILESTREAM_CHUNKER0000
FFT_RSFX_COMM0000
FFT_RSFX_WAIT_FOR_MEMORY0000
FFT_STARTUP_SHUTDOWN0000
PWAIT_XTP_HOST_STORAGE_WAIT0000
HADR_FABRIC_CALLBACK0000
ASYNC_OP_CONTEXT_READ0000
ASYNC_OP_CONTEXT_WRITE0000
ASYNC_OP_COMPLETION0000
FABRIC_REPLICA_PUBLISHER_SUBSCRIBER_LIST0000
FABRIC_REPLICA_CONTROLLER_STATE_AND_CONFIG0000
FABRIC_REPLICA_CONTROLLER_LIST0000
FABRIC_HADR_TRANSPORT_CONNECTION0000
FABRIC_WAIT_FOR_BUILD_REPLICA_EVENT_PROCESSING0000
VDI_CLIENT_GETCOMMAND0000
VDI_CLIENT_COMPLETECOMMAND0000
VDI_CLIENT_OTHER0000
VDI_CLIENT_OPERATION0000
HADR_DBSEEDING0000
HADR_DBSEEDING_LIST0000
SLO_UPDATE0000
WAIT_XTP_RECOVERY0000
WAIT_XTP_OFFLINE_CKPT_NEW_LOG0000
WAIT_XTP_OFFLINE_CKPT_LOG_IO0000
WAIT_XTP_OFFLINE_CKPT_BEFORE_REDO0000
WAIT_XTP_PROCEDURE_ENTRY0000
WAIT_XTP_CKPT_ENABLED0000
WAIT_XTP_CKPT_AGENT_WAKEUP0000
WAIT_XTP_CKPT_CLOSE0000
WAIT_XTP_CKPT_STATE_LOCK0000
WAIT_XTP_ASYNC_TX_COMPLETION0000
LCK_M_SCH_S_LOW_PRIORITY0000
LCK_M_SCH_M_LOW_PRIORITY0000
LCK_M_S_LOW_PRIORITY0000
LCK_M_U_LOW_PRIORITY0000
LCK_M_X_LOW_PRIORITY0000
LCK_M_IS_LOW_PRIORITY0000
LCK_M_IU_LOW_PRIORITY0000
LCK_M_IX_LOW_PRIORITY0000
LCK_M_SIU_LOW_PRIORITY0000
LCK_M_SIX_LOW_PRIORITY0000
LCK_M_UIX_LOW_PRIORITY0000
LCK_M_BU_LOW_PRIORITY0000
LCK_M_RS_S_LOW_PRIORITY0000
LCK_M_RS_U_LOW_PRIORITY0000
LCK_M_RIn_NL_LOW_PRIORITY0000
LCK_M_RIn_S_LOW_PRIORITY0000
LCK_M_RIn_U_LOW_PRIORITY0000
LCK_M_RIn_X_LOW_PRIORITY0000
LCK_M_RX_S_LOW_PRIORITY0000
LCK_M_RX_U_LOW_PRIORITY0000
LCK_M_RX_X_LOW_PRIORITY0000
LCK_M_SCH_S_ABORT_BLOCKERS0000
LCK_M_SCH_M_ABORT_BLOCKERS0000
LCK_M_S_ABORT_BLOCKERS0000
LCK_M_U_ABORT_BLOCKERS0000
LCK_M_X_ABORT_BLOCKERS0000
LCK_M_IS_ABORT_BLOCKERS0000
LCK_M_IU_ABORT_BLOCKERS0000
LCK_M_IX_ABORT_BLOCKERS0000
LCK_M_SIU_ABORT_BLOCKERS0000
LCK_M_SIX_ABORT_BLOCKERS0000
LCK_M_UIX_ABORT_BLOCKERS0000
LCK_M_BU_ABORT_BLOCKERS0000
LCK_M_RS_S_ABORT_BLOCKERS0000
LCK_M_RS_U_ABORT_BLOCKERS0000
LCK_M_RIn_NL_ABORT_BLOCKERS0000
LCK_M_RIn_S_ABORT_BLOCKERS0000
LCK_M_RIn_U_ABORT_BLOCKERS0000
LCK_M_RIn_X_ABORT_BLOCKERS0000
LCK_M_RX_S_ABORT_BLOCKERS0000
LCK_M_RX_U_ABORT_BLOCKERS0000
LCK_M_RX_X_ABORT_BLOCKERS0000
TERMINATE_LISTENER0000
WAIT_SCRIPTDEPLOYMENT_REQUEST0000
WAIT_SCRIPTDEPLOYMENT_WORKER0000
FEATURE_SWITCHES_UPDATE0000
XTP_HOST_DB_COLLECTION0000
XTP_HOST_LOG_ACTIVITY0000
QDS_DYN_VECTOR0000
QDS_STMT0000
QDS_CTXS0000
QDS_BCKG_TASK0000
QDS_DB_DISK0000
QDS_STMT_DISK0000
QDS_ASYNC_PERSIST_TASK0000
QDS_LOADDB0000
QDS_ASYNC_PERSIST_TASK_START1000
QDS_ASYNC_CHECK_CONSISTENCY_TASK0000
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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