Wait Statistics

All wait types anonymously reported by miniDBA. Use this view to find how common a wait type is plus it's expected average and max values.
Wait Type Avg % Of Waits Number Of Servers Avg Wait Time Max Wait Time Description
LCK_M_SCH_M 0.0897249 626 / 832 (75%) 4008.033 1690684 Occurs when a task is waiting to acquire a Schema Modify lock. For a lock compatibility matrix, see sys.dm_tran_locks (Transact-SQL).
LCK_M_S 1.655237 637 / 832 (77%) 21141.61 2.482695E+07 Occurs when a task is waiting to acquire a Shared lock. For a lock compatibility matrix, see sys.dm_tran_locks (Transact-SQL).
LATCH_SH 0.05450811 620 / 832 (75%) 28.77139 6173 Occurs when waiting for an SH (share) latch. This does not include buffer latches or transaction mark latches. A listing of LATCH_* waits is available in sys.dm_os_latch_stats. Note that sys.dm_os_latch_stats groups LATCH_NL, LATCH_SH, LATCH_UP, LATCH_EX, and LATCH_DT waits together.
LATCH_EX 2.03234 621 / 832 (75%) 30.64855 9277 Occurs when waiting for an EX (exclusive) latch. This does not include buffer latches or transaction mark latches. A listing of LATCH_* waits is available in sys.dm_os_latch_stats. Note that sys.dm_os_latch_stats groups LATCH_NL, LATCH_SH, LATCH_UP, LATCH_EX, and LATCH_DT waits together.
PAGELATCH_SH 0.3146477 636 / 832 (76%) 208.2786 98109 Occurs when a task is waiting on a latch for a buffer that is not in an I/O request. The latch request is in Shared mode.
PAGELATCH_EX 0.4393602 639 / 832 (77%) 0.545509 385 Occurs when a task is waiting on a latch for a buffer that is not in an I/O request. The latch request is in Exclusive mode.
PAGEIOLATCH_SH 6.304212 639 / 832 (77%) 18.16245 4829 Occurs when a task is waiting on a latch for a buffer that is in an I/O request. The latch request is in Shared mode. Long waits may indicate problems with the disk subsystem.
PAGEIOLATCH_UP 0.103555 640 / 832 (77%) 21.0174 9145 Occurs when a task is waiting on a latch for a buffer that is in an I/O request. The latch request is in Update mode. Long waits may indicate problems with the disk subsystem.
PAGEIOLATCH_EX 1.138522 640 / 832 (77%) 8.345117 243 Occurs when a task is waiting on a latch for a buffer that is in an I/O request. The latch request is in Exclusive mode. Long waits may indicate problems with the disk subsystem.
IO_COMPLETION 1.171773 638 / 832 (77%) 5.259058 167 Occurs while waiting for I/O operations to complete. This wait type generally represents non-data page I/Os. Data page I/O completion waits appear as PAGEIOLATCH_* waits.
ASYNC_IO_COMPLETION 2.969181 635 / 832 (76%) 46952.45 3278792 Occurs when a task is waiting for I/Os to finish.
ASYNC_NETWORK_IO 5.273717 640 / 832 (77%) 10.28845 613 Occurs on network writes when the task is blocked behind the network. Verify that the client is processing data from the server.
SLEEP_BPOOL_FLUSH 0.5082802 638 / 832 (77%) 5.330103 706 Occurs when a checkpoint is throttling the issuance of new I/Os in order to avoid flooding the disk subsystem.
CHKPT 0.199974 629 / 832 (76%) 5313.319 77325 Occurs at server startup to tell the checkpoint thread that it can start.
SLEEP_DBSTARTUP 0.2303324 568 / 832 (68%) 102.9613 283 Occurs during database startup while waiting for all databases to recover.
SLEEP_MASTERDBREADY 0.2142657 482 / 832 (58%) 6332.663 76495 This wait type is when a thread is waiting for the master database to start during instance startup. There will be exactly one of these waits and its wait time is how long the master database took to start.
SLEEP_DCOMSTARTUP 0.02847002 621 / 832 (75%) 476.3058 12993 Occurs once at most during SQL Server instance startup while waiting for DCOM initialization to complete.
THREADPOOL 0.1865603 631 / 832 (76%) 3929.516 6201279 Occurs when a task is waiting for a worker to run on. This can indicate that the maximum worker setting is too low, or that batch executions are taking unusually long, thus reducing the number of workers available to satisfy other batches.
SOS_SCHEDULER_YIELD 4.045176 640 / 832 (77%) 0.3554758 23 Occurs when a task voluntarily yields the scheduler for other tasks to execute. During this wait the task is waiting for its quantum to be renewed.
BACKUPIO 7.131909 537 / 832 (65%) 58.07968 4926 Occurs when a backup task is waiting for data, or is waiting for a buffer in which to store data. This type is not typical, except when a task is waiting for a tape mount.
BACKUPTHREAD 1.4218 536 / 832 (64%) 2412.176 292771 Occurs when a task is waiting for a backup task to finish. Wait times may be long, from several minutes to several hours. If the task that is being waited on is in an I/O process, this type does not indicate a problem.
BROKER_MASTERSTART 0.001536705 265 / 832 (32%) 23.5993 531 Occurs when a task is waiting for the primary event handler of the Service Broker to start. This should occur very briefly.
WRITELOG 4.312083 640 / 832 (77%) 7.087919 2422 Occurs while waiting for a log flush to complete. Common operations that cause log flushes are checkpoints and transaction commits.
MSQL_XP 0.7719514 640 / 832 (77%) 85.39221 20201 Occurs when a task is waiting for an extended stored procedure to end. SQL Server uses this wait state to detect potential MARS application deadlocks. The wait stops when the extended stored procedure call ends.
LOGBUFFER 0.06940212 550 / 832 (66%) 27.01775 1264 Occurs when a task is waiting for space in the log buffer to store a log record. Consistently high values may indicate that the log devices cannot keep up with the amount of log being generated by the server.
DAC_INIT 0.001183071 453 / 832 (54%) 13.27568 1122 Occurs while the dedicated administrator connection is initializing.
XE_BUFFERMGR_ALLPROCESSED_EVENT 0.08582021 391 / 832 (47%) 8.165911 621 Occurs when Extended Events session buffers are flushed to targets. This wait occurs on a background thread.
PREEMPTIVE_OS_AUTHENTICATIONOPS 1.227866 632 / 832 (76%) 0.4142083 62 This wait type is a generic wait for when a thread is calling one of several Windows functions related to security authentication.
PREEMPTIVE_OS_DECRYPTMESSAGE 0.02363311 449 / 832 (54%) 0.04278075 12 when a thread is calling the Windows DecryptMessage function.
PREEMPTIVE_OS_DELETESECURITYCONTEXT 0.2341096 632 / 832 (76%) 0.3259036 23 when a thread is calling the Windows DeleteSecurityContext function.
PREEMPTIVE_OS_ENCRYPTMESSAGE 0.05442493 259 / 832 (31%) 0.3069307 31 Occurs when calling Windows EncryptMessage function.
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES 0.05873585 490 / 832 (59%) 0.06861199 11 when a thread is calling the Windows QueryContextAttributes function.
PREEMPTIVE_OS_AUTHORIZATIONOPS 0.1093607 632 / 832 (76%) 0.5524096 46 generic wait for when a thread is calling one of several Windows functions related to security permissions.
PREEMPTIVE_OS_LOOKUPACCOUNTSID 0.06234528 579 / 832 (70%) 7.288382 2942 Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
PREEMPTIVE_OS_REVERTTOSELF 0.06090938 630 / 832 (76%) 0.08383961 15 when a thread is calling the Windows RevertToSelf function.
PREEMPTIVE_COM_COCREATEINSTANCE 0.003336099 312 / 832 (38%) 25.80207 1995 Occurs when the SQLOS scheduler switches to preemptive mode to create a COM object.
PREEMPTIVE_OS_CRYPTOPS 0.05555265 625 / 832 (75%) 78.72866 2010 generic wait for when a thread is calling one of several Windows functions related to cryptography.
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT 0.05947029 630 / 832 (76%) 0.3228346 55 when a thread is calling the Windows CryptAcquireContext function.
PREEMPTIVE_OS_CRYPTIMPORTKEY 0.05186187 609 / 832 (73%) 0.3229498 31 when a thread is calling the Windows CryptImportKey function.
PREEMPTIVE_OS_FILEOPS 0.278141 627 / 832 (75%) 16.625 4159 Occurs when SQLOS scheduler switches to preemptive mode to wait for file system operations to complete
PREEMPTIVE_OS_CREATEFILE 0.07144599 628 / 832 (75%) 4.904034 1054 when a thread is calling the Windows CreateFile function. Note that this API is also used to open files for reading, not just for creating files. Occurs when Creating a FILESTREAM file, Creating a backup file, Creating an Extended Events target file or Creating a new database file
PREEMPTIVE_FILESIZEGET 0.006215257 578 / 832 (69%) 0.3567531 48 when a thread is calling the Windows GetFileSizeEx function. Occurs when getting the size of a data or log file.
PREEMPTIVE_OS_GETFILEATTRIBUTES 0.02162861 625 / 832 (75%) 13.39766 8865 when a thread is calling the Windows GetFileAttributes function.
PREEMPTIVE_OS_GETVOLUMEPATHNAME 0.01517897 523 / 832 (63%) 1.984305 355 when a thread is calling the Windows GetVolumePathName function possibly during a BACKUP DATABASE operation.
PREEMPTIVE_OS_WRITEFILE 0.2365451 534 / 832 (64%) 28.252 7758 when a thread is calling the Windows WriteFile function, possibly during writing synchronously to a SQL Trace file or Writing synchronously to a database snapshot (as part of running a DBCC CHECKDB operation)
PREEMPTIVE_OS_WRITEFILEGATHER 0.3865911 625 / 832 (75%) 3208.977 577027 occurs when a file is being zero-initialized. Log files and new portions of a log file are always zero initialized. Data files and new portions of a data file are only zero initialized if the Instant File Initialization feature is NOT enabled. May occur when Zeroing the log tail while starting up a database or Zeroing a new portion of the log.
PREEMPTIVE_OS_LIBRARYOPS 0.1696967 548 / 832 (66%) 3669.496 35887 Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
PREEMPTIVE_OS_GETPROCADDRESS 0.1916122 585 / 832 (70%) 40.77131 20200 when a thread is calling the Windows GetProcAddress function, to get the extended stored procedure address from a DLL.
PREEMPTIVE_OS_LOADLIBRARY 0.0101717 621 / 832 (75%) 75.57108 4401 when a thread is calling the Windows LoadLibrary function.
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE 0.1173201 610 / 832 (73%) 0.5332092 155 when a thread is calling the Windows DisconnectNamedPipe function during disconnecting a named pipe connection from a client.
PREEMPTIVE_OS_REPORTEVENT 0.04575007 626 / 832 (75%) 1.986577 73 when a thread is calling the Windows ReportEvent function, during printing to the event log.
PREEMPTIVE_OS_QUERYREGISTRY 0.08563883 611 / 832 (73%) 1.068125 101 Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
PREEMPTIVE_CLOSEBACKUPVDIDEVICE 0.01401069 243 / 832 (29%) 2.200965 169 Occurs when the SQLOS scheduler switches to preemptive mode to close a virtual backup device.
PREEMPTIVE_XE_CALLBACKEXECUTE 0.5012538 571 / 832 (69%) 0.00530856 2 when a thread is switching to preemptive mode before sending a message to the Extended Events engine through a callback mechanism.
PREEMPTIVE_XE_GETTARGETSTATE 2.343524 495 / 832 (59%) 28.68517 563 when a thread switches to preemptive mode as part of querying the state of a XE session target.
PREEMPTIVE_XE_SESSIONCOMMIT 0.06538071 472 / 832 (57%) 1.100572 84 when a thread switches to preemptive mode as part of committing changes to the list of Extended Event sessions on the instance.
PREEMPTIVE_XE_TARGETINIT 0.01545419 499 / 832 (60%) 7.465997 356 when a thread is switching to preemptive mode while creating an Extended Event session target.
WRITE_COMPLETION 0.05265998 621 / 832 (75%) 8.025641 472 Occurs when a write operation is in progress.
PERFORMANCE_COUNTERS_RWLOCK 0.007137232 495 / 832 (59%) 2.770171 117 when a thread is waiting for synchronization on the performance counter structures when adding or removing an instance of a performance counter.
PWAIT_ALL_COMPONENTS_INITIALIZED 2.46626 482 / 832 (58%) 13973.23 169077 Occurs during startup waiting for the SQL OS resource monitor to initialize or waiting for the Extended Events subsystem to initialize.
FFT_RECOVERY 0.1527157 301 / 832 (36%) 423.5306 10971 Occurs when waiting for Filetable recovery to run when starting up a database.
WAIT_XTP_HOST_WAIT 1.637053 235 / 832 (28%) 120740.2 6.047791E+07 Occurs when waiting for In-Memory OLTP wait that was started by the database engine and implemented by the host.
QDS_TASK_START 0.00175421 123 / 832 (15%) 38.8239 777
LCK_M_U 1.645805 515 / 832 (62%) 3389.592 1781334 Occurs when a task is waiting to acquire an Update lock. For a lock compatibility matrix, see sys.dm_tran_locks (Transact-SQL).
LCK_M_X 0.763204 609 / 832 (73%) 1826.98 476222 Occurs when a task is waiting to acquire an Exclusive lock. For a lock compatibility matrix, see sys.dm_tran_locks (Transact-SQL).
LCK_M_IX 0.5863588 489 / 832 (59%) 43230.02 4.324324E+07 Occurs when a task is waiting to acquire an Intent Exclusive (IX) lock. For a lock compatibility matrix, see sys.dm_tran_locks (Transact-SQL).
PAGELATCH_UP 0.2647227 590 / 832 (71%) 3.957026 451 Occurs when a task is waiting on a latch for a buffer that is not in an I/O request. The latch request is in Update mode.
OLEDB 3.740607 429 / 832 (52%) 156.129 120653 Occurs during call from the server to OLE DB provider for either functions, remote procedure calls, linked server queries, BULK INSERT commands or full-search queries.
CMEMTHREAD 0.02751828 608 / 832 (73%) 1.659519 650 Occurs when a task is waiting on a thread-safe memory object. The wait time might increase when there is contention caused by multiple tasks trying to allocate memory from the same memory object.
MSQL_DQ 0.444774 259 / 832 (31%) 2986.368 967979 Occurs when a task is waiting for a distributed query operation to finish. This is used to detect potential Multiple Active Result Set (MARS) application deadlocks. The wait ends when the distributed query call finishes.
LOGMGR_FLUSH 0.0004520656 336 / 832 (40%) 7.181452 110 Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
PREEMPTIVE_OS_AUTHZGETINFORMATIONFROMCONTEXT 0.000260536 249 / 832 (30%) 0.235 11 when a thread is calling the Windows AuthzGetInformationFromContext function.
PREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSID 0.01667841 349 / 832 (42%) 118.1276 5031 when a thread is calling the Windows AuthzInitializeContextFromSid function.
PREEMPTIVE_OS_AUTHZINITIALIZERESOURCEMANAGER 0.0004005009 264 / 832 (32%) 1.581505 227 when a thread is calling the Windows AuthzInitializeResourceManager function.
PREEMPTIVE_OS_COMOPS 0.01479743 426 / 832 (51%) 267.0507 3979 generic wait for when a thread is calling one of several Windows functions related to COM.
PREEMPTIVE_COM_CREATEACCESSOR 0.005925009 138 / 832 (17%) 0.2785515 20 Occurs when the SQLOS scheduler switches to preemptive mode to wait for the CreateAccessor function of a COM object.
PREEMPTIVE_COM_GETDATA 0.4374345 129 / 832 (16%) 0.0795107 9 Occurs when the SQLOS scheduler switches to preemptive mode to wait for the GetData function of a COM object.
PREEMPTIVE_COM_QUERYINTERFACE 0.3046984 260 / 832 (31%) 1200.909 276565 accumulated wait time for linked server queries and remote operations.
PREEMPTIVE_COM_RELEASE 0.03012263 112 / 832 (13%) 1.544803 75 Unknown
PREEMPTIVE_COM_RELEASEACCESSOR 0.008168517 93 / 832 (11%) 0.2433628 20 Occurs when the SQLOS scheduler switches to preemptive mode to wait for the ReleaseAccessor function of a COM object.
PREEMPTIVE_COM_RELEASEROWS 0.006425648 121 / 832 (15%) 0.1798107 14 Occurs when the SQLOS scheduler switches to preemptive mode to wait for the ReleaseRows function of a COM object.
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY 0.05197004 394 / 832 (47%) 3.998989 592 when a thread is calling the Windows NetValidatePasswordPolicy function.
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE 0.009719788 315 / 832 (38%) 0.230386 11 when a thread is calling the Windows NetValidatePasswordPolicyFree function.
PREEMPTIVE_DTC_ABORTREQUESTDONE 0.004405761 36 / 832 (4%) 0.6179775 4 Occurs when waiting for the Abort request of the Distributed Transaction Controller. This occurs after a failed prepair.
PREEMPTIVE_DTC_COMMITREQUESTDONE 0.09571452 51 / 832 (6%) 0.7096774 6 Unknown
PREEMPTIVE_DTC_ENLIST 0.04828541 80 / 832 (10%) 19.96602 1951 Occurs enlisting a transaction as part of a distributed transaction.
PREEMPTIVE_DTC_PREPAREREQUESTDONE 0.05837538 54 / 832 (6%) 0.4793389 13 Unknown
PREEMPTIVE_OS_DELETEFILE 0.0007737014 559 / 832 (67%) 29.51662 6651 Occurs when deleting a file.
PREEMPTIVE_OS_FLUSHFILEBUFFERS 0.07576576 546 / 832 (66%) 20.90588 4033 Occurs when flushing all in-memory buffers for a file to disk (checkpoint, backup or database close).
PREEMPTIVE_OS_GETDISKFREESPACE 0.0006263921 534 / 832 (64%) 1.357959 515 Occurs when checking disk free space as part of database restore or log growth.
PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT 0.0001851354 271 / 832 (33%) 0.2316294 8 Occurs when getting the volume name (creating or restoring a database).
PREEMPTIVE_OLEDBOPS 0.3036542 373 / 832 (45%) 48.59734 4968 Occurs when waiting for OLE DB information.
PREEMPTIVE_OLEDB_GETPROPERTIES 0.001173425 94 / 832 (11%) 5.207207 100 Unknown
PREEMPTIVE_OLEDB_GETPROPERTYINFO 6.605423E-05 82 / 832 (10%) 1.089386 10 Unknown
PREEMPTIVE_OLEDB_RELEASE 0.003833109 97 / 832 (12%) 15.02155 460 Unknown
PREEMPTIVE_OLEDB_SETPROPERTIES 0.0004299291 99 / 832 (12%) 0.3185841 26 Unknown
PREEMPTIVE_OS_SECURITYOPS 0.0189566 245 / 832 (29%) 0.1376451 12 when a thread is calling one of several Windows functions related to security.
PREEMPTIVE_OS_WAITFORSINGLEOBJECT 0.5387344 426 / 832 (51%) 5.952102 1330 Occurs during synchronization with an external client process, often seen with ASYNC_NETWORK_IO.
PREEMPTIVE_SB_STOPENDPOINT 0.0007681692 126 / 832 (15%) 19.34387 889 when a thread is calling out to Windows while shutting down a Service Broker endpoint.
PREEMPTIVE_TRANSIMPORT 0.1109668 51 / 832 (6%) 4.045045 207 Unknown
SQLTRACE_FILE_WRITE_IO_COMPLETION 0.005875583 389 / 832 (47%) 9.514131 675 Occurs while waiting for a write to a trace file to complete.
SQLTRACE_FILE_READ_IO_COMPLETION 0.03447816 225 / 832 (27%) 8.697133 236 Occurs while waiting for a read from a trace file to complete.
SECURITY_CRYPTO_CONTEXT_MUTEX 0.0002389334 139 / 832 (17%) 21.81529 2054 Unknown
LCK_M_SCH_S 0.1979465 455 / 832 (55%) 10669.48 1941372 Occurs when a task is waiting to acquire a Schema Share lock. For a lock compatibility matrix, see sys.dm_tran_locks (Transact-SQL).
LCK_M_RS_S 0.02074332 110 / 832 (13%) 2518.767 84507 Occurs when a task is waiting to acquire a Shared lock on the current key value, and a Shared Range lock between the current and previous key. For a lock compatibility matrix, see sys.dm_tran_locks (Transact-SQL).
LCK_M_RIn_NL 0.006215042 109 / 832 (13%) 2882.046 236571 Occurs when a task is waiting to acquire a NULL lock on the current key value, and an Insert Range lock between the current and previous key. A NULL lock on the key is an instant release lock. For a lock compatibility matrix, see sys.dm_tran_locks (Transact-SQL).
BROKER_RECEIVE_WAITFOR 9.83255 231 / 832 (28%) 168554.2 346448 Occurs when the RECEIVE WAITFOR is waiting. This is typical if no messages are ready to be received.
CXPACKET 26.35371 516 / 832 (62%) 56.62431 23623 (Class Exchange Packet) Occurs when trying to synchronize the query processor exchange iterator (waiting for threads to complete during parallel query execution). May not be an indication of a problem, it shows that threads are waiting which is to be expected for parallel tasks.
WAITFOR 9.104596 248 / 832 (30%) 22778.92 6720573 Occurs as a result of a WAITFOR Transact-SQL statement. The duration of the wait is determined by the parameters to the statement. This is a user-initiated wait.
EXECSYNC 0.3496332 476 / 832 (57%) 87.36269 10433 Occurs during parallel queries while synchronizing in query processor in areas not related to the exchange iterator. Examples of such areas are bitmaps, large binary objects (LOBs), and the spool iterator. LOBs may frequently use this wait state.
CLR_TASK_START 0.0001570379 96 / 832 (12%) 6.050193 403 Occurs while waiting for a CLR task to complete startup.
CLR_CRST 0.0006476821 150 / 832 (18%) 48.02153 1230 Occurs when a task is currently performing CLR execution and is waiting to enter a critical section of the task that is currently being used by another task.
CLR_MONITOR 0.000118506 32 / 832 (4%) 23.72165 708 Occurs when a task is currently performing CLR execution and is waiting to obtain a lock on the monitor.
SQLCLR_APPDOMAIN 0.0006076125 49 / 832 (6%) 821.5115 34604 Occurs while CLR waits for an application domain to complete startup.
SOS_SYNC_TASK_ENQUEUE_EVENT 0.001294232 164 / 832 (20%) 12.65639 1024 Occurs when a task is started in a synchronous manner. Most tasks in SQL Server are started in an asynchronous manner, in which control returns to the starter immediately after the task request has been placed on the work queue.
EE_PMOLOCK 3.574177E-05 210 / 832 (25%) 10.00897 558 Occurs during synchronization of certain types of memory allocations during statement execution.
QUERY_EXECUTION_INDEX_SORT_EVENT_OPEN 0.01252112 110 / 832 (13%) 49.41631 674 Occurs in certain cases when offline create index build is run in parallel, and the different worker threads that are sorting synchronize access to the sort files.
SNI_TASK_COMPLETION 0.0009091265 102 / 832 (12%) 7.986363 118 Occurs when there is a wait for all tasks to finish during a NUMA node state change.
CXROWSET_SYNC 0.02689258 412 / 832 (50%) 0.5 35 Occurs during a parallel range scan.
PREEMPTIVE_OS_GENERICOPS 0.2807238 385 / 832 (46%) 435.7222 12667 Occurs when thread calls generic Windows functions.
PREEMPTIVE_OS_DOMAINSERVICESOPS 0.005841895 538 / 832 (65%) 379.9084 84193 generic wait for when a thread is calling one of several Windows functions related to domain services
PREEMPTIVE_OS_CLOSEHANDLE 0.005864332 386 / 832 (46%) 9.713661 572 Occurs when calling Windows CloseHandle function.
PREEMPTIVE_OS_PIPEOPS 0.6167634 438 / 832 (53%) 40626.78 7802583 Occurs when calling Windows functions that work with pipes.
FT_IFTS_RWLOCK 0.3521582 221 / 832 (27%) 9774.652 227981
BROKER_TRANSMISSION_OBJECT 0.006654001 14 / 832 (2%) 6.212121 90
LCK_M_IS 0.3181199 393 / 832 (47%) 20475.77 3562384 Occurs when a task is waiting to acquire an Intent Shared (IS) lock. For a lock compatibility matrix, see sys.dm_tran_locks (Transact-SQL).
LCK_M_IU 0.02458853 300 / 832 (36%) 1926.685 284005 Occurs when a task is waiting to acquire an Intent Update (IU) lock. For a lock compatibility matrix, see sys.dm_tran_locks (Transact-SQL).
DUMP_LOG_COORDINATOR_QUEUE 0.0002351063 1 / 832 (0%) 5312 5312
BACKUP 0.01143338 138 / 832 (17%) 81.18705 4291 Occurs when a task is blocked as part of backup processing.
BACKUPBUFFER 4.582815 433 / 832 (52%) 8.772011 227 Occurs when a backup task is waiting for data, or is waiting for a buffer in which to store data. This type is not typical, except when a task is waiting for a tape mount.
DUMP_LOG_COORDINATOR 2.655808E-05 1 / 832 (0%) 4801 4801 Occurs when a main task is waiting for a subtask to generate data. Ordinarily, this state does not occur. A long wait indicates an unexpected blockage. The subtask should be investigated.
WAITSTAT_MUTEX 0.0001856125 66 / 832 (8%) 0.8014184 6 Occurs during synchronization of access to the collection of statistics used to populate sys.dm_os_wait_stats.
DEADLOCK_ENUM_MUTEX 0.003084286 154 / 832 (19%) 161.2157 52692 Occurs when the deadlock monitor and sys.dm_os_waiting_tasks try to make sure that SQL Server is not running multiple deadlock searches at the same time.
RESOURCE_SEMAPHORE_MUTEX 5.260884E-05 220 / 832 (26%) 23.54071 1875 Occurs while a query waits for its request for a thread reservation to be fulfilled. It also occurs when synchronizing query compile and memory grant requests.
SNI_CRITICAL_SECTION 0.01729365 486 / 832 (58%) 0.4861352 118 Occurs during internal synchronization within SQL Server networking components.
XE_SERVICES_MUTEX 0.190557 188 / 832 (23%) 199.6501 59943
PREEMPTIVE_OS_ACCEPTSECURITYCONTEXT 3.644761E-05 51 / 832 (6%) 8.533334 161 Occurs when retrieving security authentication and authorization.
PREEMPTIVE_OS_ACQUIRECREDENTIALSHANDLE 1.407004E-05 45 / 832 (5%) 1.170455 25 Occurs when retrieving Windows credentials handle.
PREEMPTIVE_OS_INITIALIZESECURITYCONTEXT 3.309582E-05 50 / 832 (6%) 3.567308 52 Occurs when calling Windows InitializeSecurityContext function.
PREEMPTIVE_OS_SETFILEVALIDDATA 0.001443931 316 / 832 (38%) 6.418301 566 Occurs during creation or growth of a data file for Instant File Initialization.
PREEMPTIVE_OS_GETADDRINFO 0.0004529798 51 / 832 (6%) 12.30097 962 Occurs when calling Windows GetAddrInfo function.
PREEMPTIVE_OS_WSASETLASTERROR 0.2370172 47 / 832 (6%) 5329.101 21074 Occurs when calling Windows WsaSetLastError function.
HADR_CLUSAPI_CALL 13.88109 55 / 832 (7%) 142.9174 255 A SQL Server thread is waiting to switch from non-preemptive mode (scheduled by SQL Server) to preemptive mode (scheduled by the operating system) in order to invoke Windows Server Failover Clustering APIs.
HADR_WORK_POOL 0.0003711831 30 / 832 (4%) 0.6382979 3 Concurrency control wait on the AlwaysOn Availability Groups background work task object.
HADR_WORK_QUEUE 41.81453 34 / 832 (4%) 703.7222 10011 AlwaysOn Availability Groups background worker thread waiting for new work to be assigned. This is an expected wait when there are ready workers waiting for new work, which is the normal state.
HADR_LOGCAPTURE_SYNC 0.0001228153 18 / 832 (2%) 106.7083 757 Concurrency control around the log capture or apply object when creating or destroying scans. This is an expected wait when partners change state or connection status.
LOGPOOL_CACHESIZE 3.538195E-06 30 / 832 (4%) 10.97436 107 Occurs when a task is waiting for the log pool cache size to be changed for a database.
LOGPOOL_FREEPOOLS 0.00074325 85 / 832 (10%) 9.226315 542 Occurs when a task is waiting for access to the log free pool manager.
LOGPOOL_REPLACEMENTSET 0.0001724714 65 / 832 (8%) 1.633929 73 Occurs when a task is waiting for log data to be written to the log pool.
HADR_SYNC_COMMIT 0.8303545 23 / 832 (3%) 64.1579 276 Waiting for transaction commit processing for the synchronized secondary databases to harden the log. This wait is also reflected by the Transaction Delay performance counter. This wait type is expected for synchronized availability groups and indicates the time to send, write, and acknowledge log to the secondary databases.
HADR_AG_MUTEX 0.01485637 34 / 832 (4%) 727.0189 6477 Occurs when an AlwaysOn DDL statement or Windows Server Failover Clustering command is waiting for exclusive read/write access to the configuration of an availability group.
UCS_SESSION_REGISTRATION 0.03339499 33 / 832 (4%) 0.2692308 6
HADR_LOGPROGRESS_SYNC 0.000754234 26 / 832 (3%) 13.05405 253 Concurrency control wait when updating the log progress status of database replicas.
XDESTSVERMGR 0.001090204 28 / 832 (3%) 122.0244 629
HADR_REPLICAINFO_SYNC 0.000294988 23 / 832 (3%) 199.1053 1753 Waiting for concurrency control to update the current replica state.
HADR_NOTIFICATION_DEQUEUE 14.34301 35 / 832 (4%) 5155355 2.886458E+07 A background task that processes Windows Server Failover Clustering notifications is waiting for the next notification. Internal use only.
HADR_ARCONTROLLER_NOTIFICATIONS_SUBSCRIBER_LIST 0.009125003 27 / 832 (3%) 0.255814 4 The publisher for an availability replica event (such as a state change or configuration change) is waiting for exclusive read/write access to the list of event subscribers. Internal use only.
HADR_DATABASE_FLOW_CONTROL 0.002161548 23 / 832 (3%) 188.1563 1797 Waiting for messages to be sent to the partner when the maximum number of queued messages has been reached. Indicates that the log scans are running faster than the network sends. This is an issue only if network sends are slower than expected.
HADR_LOGCAPTURE_WAIT 10.45378 30 / 832 (4%) 1428 4808 Waiting for log records to become available. Can occur either when waiting for new log records to be generated by connections or for I/O completion when reading log not in the cache. This is an expected wait if the log scan is caught up to the end of log or is reading from disk.
HADR_AR_CRITICAL_SECTION_ENTRY 9.714643E-06 33 / 832 (4%) 121.2115 3765
HADR_TIMER_TASK 6.16867 33 / 832 (4%) 457.5192 1037 Waiting to get the lock on the timer task object and is also used for the actual waits between times that work is being performed. For example, for a task that runs every 10 seconds, after one execution, AlwaysOn Availability Groups waits about 10 seconds to reschedule the task, and the wait is included here.
HADR_GROUP_COMMIT 0.1982573 21 / 832 (3%) 2.366667 8 Transaction commit processing is waiting to allow a group commit so that multiple commit log records can be put into a single log block. This wait is an expected condition that optimizes the log I/O, capture, and send operations.
HADR_SYNCHRONIZING_THROTTLE 0.001390122 16 / 832 (2%) 5.954545 10 Waiting for transaction commit processing to allow a synchronizing secondary database to catch up to the primary end of log in order to transition to the synchronized state. This is an expected wait when a secondary database is catching up.
SERVER_IDLE_CHECK 11.53771 57 / 832 (7%) 7167.263 11054 Occurs during synchronization of SQL Server instance idle status when a resource monitor is attempting to declare a SQL Server instance as idle or trying to wake up.
RESOURCE_SEMAPHORE 1.527372 128 / 832 (15%) 13972.17 390931 Occurs when a query memory request cannot be granted immediately due to other concurrent queries. High waits and wait times may indicate excessive number of concurrent queries, or excessive memory request amounts.
RESOURCE_SEMAPHORE_QUERY_COMPILE 0.1715986 178 / 832 (21%) 2022.069 151107 Occurs when the number of concurrent query compilations reaches a throttling limit. High waits and wait times may indicate excessive compilations, recompiles, or uncachable plans.
PREEMPTIVE_OS_DTCOPS 0.001564696 91 / 832 (11%) 3710.604 232784 generic wait for when a thread is calling one of several Windows functions related to DTC.
ASYNC_DISKPOOL_LOCK 0.001031717 93 / 832 (11%) 4.051136 177 Occurs when there is an attempt to synchronize parallel threads that are performing tasks such as creating or initializing a file.
PREEMPTIVE_OS_SQMLAUNCH 0.001412858 343 / 832 (41%) 8.934516 2064 Occurs when Windows initializes the SQM error reporting system.
IO_AUDIT_MUTEX 0.008246756 78 / 832 (9%) 0.2043796 13 Occurs during synchronization of trace event buffers.
BROKER_TRANSMISSION_WORK 3.842916E-05 103 / 832 (12%) 34.38542 2610
DTC_STATE 0.0001971949 17 / 832 (2%) 6914.674 290698 Occurs when a task is waiting on an event that protects changes to the internal MS DTC global state object. This state should be held for very short periods of time.
MSQL_XACT_MGR_MUTEX 0.08496898 11 / 832 (1%) 54510.32 243002 Occurs when a task is waiting to obtain ownership of the session transaction manager to perform a session level transaction operation.
PREEMPTIVE_OLEDB_GETDATASOURCE 1.492952E-05 72 / 832 (9%) 0.1730769 5 Unknown
PREEMPTIVE_OLEDB_GETLITERALINFO 8.989198E-05 57 / 832 (7%) 0.9051724 23 Unknown
LOGMGR_RESERVE_APPEND 0.1459295 30 / 832 (4%) 1042.295 2026 Occurs when a task is waiting to see whether log truncation frees up log space to enable the task to write a new log record. Consider increasing the size of the log file(s) for the affected database to reduce this wait.
LOGPOOL_CONSUMER 0.0001099558 48 / 832 (6%) 0.8767123 8 Occurs when a task is waiting for access to a log pool consumer.
SOSHOST_MUTEX 5.023786E-05 45 / 832 (5%) 14.31183 469 Occurs when a hosted component, such as CLR, waits on a SQL Server mutex synchronization object.
BROKER_TRANSMISSION_TABLE 0.007335848 99 / 832 (12%) 33.30729 1576 Occurs when Waiting for inactive transmission objects to be written to tempdb.
PREEMPTIVE_XE_TARGETFINALIZE 0.006791219 195 / 832 (23%) 0.3076923 18 Occurs when destroying an extended event target.
PREEMPTIVE_OS_VERIFYTRUST 0.01397272 178 / 832 (21%) 66.16602 3096
MEMORY_ALLOCATION_EXT 0.6674636 109 / 832 (13%) 0 0
RESERVED_MEMORY_ALLOCATION_EXT 0.08179126 181 / 832 (22%) 0 0
PARALLEL_REDO_WORKER_WAIT_WORK 1.81712 168 / 832 (20%) 10.62753 64
SESSION_WAIT_STATS_CHILDREN 0.03528057 120 / 832 (14%) 0.6698113 23
QDS_ASYNC_QUEUE 54.00209 56 / 832 (7%) 2968879 5.38352E+07 Occurs when a thread is waiting for access to the queue of query store information that is asynchronously persisted to disk.
LCK_M_RS_U 0.01087245 160 / 832 (19%) 891.1495 46252 Occurs when a task is waiting to acquire an Update lock on the current key value, and an Update Range lock between the current and previous key. For a lock compatibility matrix, see sys.dm_tran_locks (Transact-SQL).
DTC 0.7230639 48 / 832 (6%) 40.29358 231 Occurs when a task is waiting on an event that is used to manage state transition. This state controls when the recovery of Microsoft Distributed Transaction Coordinator (MS DTC) transactions occurs after SQL Server receives notification that the MS DTC service has become unavailable. This state also describes a task that is waiting when a commit of a MS DTC transaction is initiated by SQL Server and SQL Server is waiting for the MS DTC commit to finish.
IMPPROV_IOWAIT 0.00485637 77 / 832 (9%) 10.77778 237 Occurs when SQL Server waits for a bulkload I/O to finish.
CMEMPARTITIONED 2.673755E-05 20 / 832 (2%) 0.3076923 5
TRANSACTION_MUTEX 0.4974271 176 / 832 (21%) 663.2937 27613 Occurs during synchronization of access to a transaction by multiple batches.
QUERY_NOTIFICATION_MGR_MUTEX 3.433024E-07 8 / 832 (1%) 1.785714 10 Occurs during synchronization of the garbage collection queue in the Query Notification Manager.
QUERY_NOTIFICATION_TABLE_MGR_MUTEX 1.187811E-05 8 / 832 (1%) 0.1176471 1 Occurs during internal synchronization within the Query Notification Manager.
SOS_PROCESS_AFFINITY_MUTEX 0.000161021 45 / 832 (5%) 10.34783 146 Occurs during synchronizing of access to process affinity settings.
PREEMPTIVE_COM_RESTARTPOSITION 0.007079229 52 / 832 (6%) 7.880342 264
PREEMPTIVE_DTC_BEGINTRANSACTION 0.04432618 54 / 832 (6%) 2.583333 74 Occurs when waiting for the Distributed Transaction Controller to start a transaction.
PAGELATCH_KP 6.025098E-07 72 / 832 (9%) 0.5794392 17
LOGPOOL_CONSUMERSET 2.455762E-05 41 / 832 (5%) 1.855072 54 Occurs when a task is waiting for a log pool consumer to be created or destroyed.
LCK_M_SIX 0.03467759 25 / 832 (3%) 5761.082 17685
LATCH_UP 0.0003271445 154 / 832 (19%) 504.6046 16490
SOS_PHYS_PAGE_CACHE 0.01431568 63 / 832 (8%) 36.61326 6321
PARALLEL_BACKUP_QUEUE 0.06350661 230 / 832 (28%) 74.52364 3229
FCB_REPLICA_WRITE 0.002076539 95 / 832 (11%) 144.9493 2383
FCB_REPLICA_READ 0.000164658 93 / 832 (11%) 71.75773 1076
EXCHANGE 0.0003835527 56 / 832 (7%) 0.3986928 15
DTC_ABORT_REQUEST 0.7118875 32 / 832 (4%) 3068.307 4200
EE_SPECPROC_MAP_INIT 4.123626E-06 13 / 832 (2%) 29.04762 155
PREEMPTIVE_OS_CLUSTEROPS 4.265044E-05 52 / 832 (6%) 52.52293 345 Occurs when calling Windows functions that work with failover clusters.
PREEMPTIVE_CLUSAPI_CLUSTERRESOURCECONTROL 0.004566615 47 / 832 (6%) 1.053192 7
PREEMPTIVE_COM_GETCOMMANDTEXT 0.001082795 22 / 832 (3%) 1.428571 23
PREEMPTIVE_COM_GETRESULT 0.002209222 21 / 832 (3%) 4.021276 27
PREEMPTIVE_COM_RELEASESESSION 0.0007957478 21 / 832 (3%) 1.326087 16
PREEMPTIVE_COM_SETPARAMETERINFO 0.0001531834 75 / 832 (9%) 0.2116402 8
PREEMPTIVE_COM_SETPARAMETERPROPERTIES 0.0001408239 66 / 832 (8%) 0.3192771 13
PREEMPTIVE_OS_DEVICEOPS 0.3415023 81 / 832 (10%) 2.539604 20 Occurs when calling Windows functions that work with device control.
PREEMPTIVE_OS_DEVICEIOCONTROL 9.663226E-05 180 / 832 (22%) 1.049751 35 Occurs when calling the Windows DeviceControl function.
PREEMPTIVE_OS_MOVEFILE 0.00251116 62 / 832 (7%) 2.401786 23
PREEMPTIVE_ODBCOPS 0.03020315 25 / 832 (3%) 175.963 2950
PREEMPTIVE_CREATEPARAM 8.545965E-06 70 / 832 (8%) 294.5898 8920
PREEMPTIVE_XE_DISPATCHER 6.935289 51 / 832 (6%) 6.313446E+07 1.140147E+09
CREATE_DATINISERVICE 0.0002895414 9 / 832 (1%) 219.6 724
SOS_DISPATCHER_MUTEX 2.80619E-06 78 / 832 (9%) 0.1029412 3
PREEMPTIVE_OS_FINDFILE 0.008866121 21 / 832 (3%) 0.08928572 2
LCK_M_BU 0.05252286 20 / 832 (2%) 51925.9 569290
QDS_TASK_SHUTDOWN 0.02191025 21 / 832 (3%) 12.71014 85
PREEMPTIVE_DEBUG 0.07309642 55 / 832 (7%) 946.7152 8569
PREEMPTIVE_OLE_UNINIT 0.0008164119 77 / 832 (9%) 0.9945946 14
XE_LIVE_TARGET_TVF 2.084599 43 / 832 (5%) 19246.25 309190
SOS_RESERVEDMEMBLOCKLIST 0.0001972706 92 / 832 (11%) 3.493878 79
SOS_LOCALALLOCATORLIST 2.437216E-05 67 / 832 (8%) 1.342246 48
SQLSORT_SORTMUTEX 0.00194143 27 / 832 (3%) 40.76667 176
SQLTRACE_LOCK 0.009679783 37 / 832 (4%) 30.58108 288
CLEAR_DB 0.0007900007 12 / 832 (1%) 379.5555 1771
FFT_NSO_DB_LIST 0.0002863942 21 / 832 (3%) 7.216216 121
SEQUENTIAL_GUID 1.226225E-06 5 / 832 (1%) 0.07692308 1
DEADLOCK_TASK_SEARCH 9.601864E-06 47 / 832 (6%) 118.6456 1897
WAITFOR_PER_QUEUE 2.301013E-05 28 / 832 (3%) 0.2173913 4
LOGMGR 0.0001592742 10 / 832 (1%) 19.375 24
PRINT_ROLLBACK_PROGRESS 0.01820264 89 / 832 (11%) 3161.298 6027
LOGPOOL_MGRSET 2.181146E-05 2 / 832 (0%) 0 0
DBMIRRORING_CMD 33.38171 19 / 832 (2%) 1097218 1.76015E+07
DBMIRROR_DBM_EVENT 0.5020888 13 / 832 (2%) 4.466667 41
DBMIRROR_SEND 2.234304 16 / 832 (2%) 4737.079 92007
DBMIRROR_EVENTS_QUEUE 36.23943 19 / 832 (2%) 288.0714 2230
DBMIRROR_WORKER_QUEUE 0.4589762 19 / 832 (2%) 451774.2 2.044341E+07
QUERY_TASK_ENQUEUE_MUTEX 0.02346502 30 / 832 (4%) 0.1447368 7
PREEMPTIVE_OS_CREATEDIRECTORY 0.004282668 12 / 832 (1%) 11.36667 80
WAIT_XTP_RECOVERY 0.3364795 7 / 832 (1%) 313849.9 1066500
PWAIT_DIRECTLOGCONSUMER_GETNEXT 40.06166 6 / 832 (1%) 47421 86404
PARALLEL_REDO_WORKER_SYNC 0.01027907 141 / 832 (17%) 6.218045 133
BROKER_INIT 0.001547266 28 / 832 (3%) 1040.917 3002
QDS_CTXS 9.695603E-06 4 / 832 (0%) 27.875 223
XE_FILE_TARGET_TVF 0.1233589 38 / 832 (5%) 7.641304 54
SLEEP_BUFFERPOOL_HELPLW 0.09849112 107 / 832 (13%) 4.657692 242
PARALLEL_REDO_DRAIN_WORKER 0.00699182 115 / 832 (14%) 80.77888 3629
XE_SESSION_FLUSH 0.01620123 103 / 832 (12%) 129.9083 4997
DEBUG 1.430606E-07 28 / 832 (3%) 4.303797 36
SOS_MEMORY_TOPLEVELBLOCKALLOCATOR 6.193517E-06 19 / 832 (2%) 80.71875 1257
REPL_SCHEMA_ACCESS 0.0001542716 31 / 832 (4%) 0.2794118 2
REPL_CACHE_ACCESS 1.53706E-06 1 / 832 (0%) 8 8
SQLCLR_QUANTUM_PUNISHMENT 0.0003484888 8 / 832 (1%) 1.916667 23
REQUEST_DISPENSER_PAUSE 0.0006582458 63 / 832 (8%) 734.5894 1210
XE_SESSION_SYNC 6.068963E-06 15 / 832 (2%) 8.185185 127
XE_TIMER_MUTEX 3.538129E-05 38 / 832 (5%) 0.1505376 3
MD_LAZYCACHE_RWLOCK 0.0006391695 42 / 832 (5%) 2.051546 19
PWAIT_MD_RELATION_CACHE 1.1901E-05 26 / 832 (3%) 0.7450981 5
LOGPOOLREFCOUNTEDOBJECT_REFDONE 4.045452E-06 14 / 832 (2%) 2.8125 22
RESOURCE_GOVERNOR_IDLE 1.320081 1 / 832 (0%) 4 4
SEQUENCE_GENERATION 0.01446384 30 / 832 (4%) 3.478723 32
BUILTIN_HASHKEY_MUTEX 4.250652E-06 6 / 832 (1%) 18.66667 96
PREEMPTIVE_OS_FORMATMESSAGE 1.851108E-05 7 / 832 (1%) 0.6666667 4
FT_MASTER_MERGE 0.005077317 18 / 832 (2%) 16966.2 257281
QDS_BCKG_TASK 1.844312E-07 12 / 832 (1%) 0 0
QDS_LOADDB 0.0008252109 15 / 832 (2%) 6505.063 85412
NODE_CACHE_MUTEX 3.781279E-07 20 / 832 (2%) 0.5666667 4
PREEMPTIVE_COM_GETROWSBYBOOKMARK 0.001691676 23 / 832 (3%) 1.4375 27
PREEMPTIVE_OLEDB_ABORTORCOMMITTRAN 0.002688148 22 / 832 (3%) 15 177
LCK_M_RX_X 0.005477607 22 / 832 (3%) 4225.6 14611
BAD_PAGE_PROCESS 8.115714 6 / 832 (1%) 6035.545 15001
XE_SERVICES_RWLOCK 0.003889249 10 / 832 (1%) 22282.12 315422
PREEMPTIVE_OLEDB_ABORTTRAN 0.002592365 22 / 832 (3%) 1 3
PREEMPTIVE_OLEDB_GETSCHEMALOCK 0.03293221 17 / 832 (2%) 4.236842 43
DBMIRROR_DBM_MUTEX 9.056476 13 / 832 (2%) 91730 1867879
QDS_ASYNC_PERSIST_TASK_START 0.002308767 35 / 832 (4%) 99.77381 959
PARALLEL_REDO_FLOW_CONTROL 0.002786044 16 / 832 (2%) 531.875 2912
EXECUTION_PIPE_EVENT_INTERNAL 0.030793 14 / 832 (2%) 0.01818182 1
PREEMPTIVE_OS_RSFXDEVICEOPS 0.08610443 11 / 832 (1%) 0.05882353 1
PREEMPTIVE_OS_GETFILESIZE 0.001003938 4 / 832 (0%) 0.2 1
REDO_THREAD_PENDING_WORK 5.014196 15 / 832 (2%) 102.1429 110
REDO_THREAD_SYNC 0.003578853 10 / 832 (1%) 36.25 368
HADR_DB_COMMAND 0.006990453 15 / 832 (2%) 601.8095 2194
PWAIT_HADR_WORKITEM_COMPLETED 7.658661E-05 16 / 832 (2%) 403.4783 1206
HADR_PARTNER_SYNC 3.668275E-06 9 / 832 (1%) 28.38461 141
HADR_DBSTATECHANGE_SYNC 0.0002238722 13 / 832 (2%) 4371.235 20033
HADR_DBR_SUBSCRIBER 3.362761E-05 13 / 832 (2%) 3572.778 39623
HADR_BACKUP_BULK_LOCK 0.002863268 4 / 832 (0%) 127.1429 629
HADR_BACKUP_QUEUE 0.02590981 4 / 832 (0%) 2496.143 5221
RECOVERY_MGR_LOCK 0.00954048 47 / 832 (6%) 48.24742 1021
DIRTY_PAGE_SYNC 7.316984E-06 8 / 832 (1%) 3.315789 14
PWAIT_RESOURCE_SEMAPHORE_FT_PARALLEL_QUERY_SYNC 0.0003134716 6 / 832 (1%) 6.548387 20
QRY_PARALLEL_THREAD_MUTEX 8.107433E-08 4 / 832 (0%) 3.818182 9
PREEMPTIVE_OS_REMOVEDIRECTORY 3.023492E-05 5 / 832 (1%) 3.285714 6
BROKER_SERVICE 1.911246E-05 9 / 832 (1%) 0.4615385 4
PREEMPTIVE_COM_SEQSTRMREAD 0.008721229 12 / 832 (1%) 0.3414634 14
UCS_TRANSPORT_STREAM_CHANGE 8.045254E-08 4 / 832 (0%) 2.5 5
PWAIT_HADR_ONLINE_COMPLETED 3.490584E-05 10 / 832 (1%) 3784.933 6174
HADR_TRANSPORT_DBRLIST 3.88608E-06 8 / 832 (1%) 12.83333 67
HADR_DATABASE_WAIT_FOR_RECOVERY 2.781449E-05 3 / 832 (0%) 419.75 473
CHECK_TABLES_INITIALIZATION 0.04825035 25 / 832 (3%) 2940.267 68180
CHECK_TABLES_THREAD_BARRIER 0.0007548838 24 / 832 (3%) 12.2093 220
DPT_ENTRY_LOCK 1.807037E-05 5 / 832 (1%) 115.3333 1556
SOS_VIRTUALMEMORY_LOW 0.00439211 3 / 832 (0%) 127.75 181
SQLTRACE_WAIT_ENTRIES 23.9198 12 / 832 (1%) 114241.6 300007
HTREPARTITION 0.2512214 11 / 832 (1%) 24.53572 288
HTBUILD 0.1478998 13 / 832 (2%) 161.3 2309
HTMEMO 0.4359159 11 / 832 (1%) 37.5 317
HTDELETE 0.1781238 13 / 832 (2%) 19.86667 173
BMPBUILD 0.2238413 11 / 832 (1%) 0.6785714 8
PWAIT_QRY_BPMEMORY 0.001988575 11 / 832 (1%) 0.1071429 1
COLUMNSTORE_BUILD_THROTTLE 0.01009307 8 / 832 (1%) 23855.83 29201
XTP_PREEMPTIVE_TASK 11.36141 2 / 832 (0%) 1.100147E+07 2.771002E+07
PREEMPTIVE_SP_SERVER_DIAGNOSTICS 3.678897 14 / 832 (2%) 2.145634E+08 9.843073E+08
STARTUP_DEPENDENCY_MANAGER 0.03750615 16 / 832 (2%) 84.62791 177
FILE_VALIDATION_THREADS 1.346545E-07 3 / 832 (0%) 0.125 1
BMPREPARTITION 0.2239875 9 / 832 (1%) 0.68 8
BMPALLOCATION 0.1639409 9 / 832 (1%) 0.4 6
ROWGROUP_OP_STATS 3.338285E-05 2 / 832 (0%) 0 0
BPSORT 0.0332018 11 / 832 (1%) 41.81482 190
VERSIONING_COMMITTING 3.880555E-05 10 / 832 (1%) 15.47059 21
WAIT_XTP_TASK_SHUTDOWN 0.002062514 2 / 832 (0%) 6 17
PREEMPTIVE_OS_LOGONUSER 0.001022638 6 / 832 (1%) 160.7692 462
HADR_DB_OP_COMPLETION_SYNC 2.396568E-06 3 / 832 (0%) 7.333333 12
XE_SESSION_CREATE_SYNC 0.004511772 4 / 832 (0%) 83.55556 226
SLEEP_MASTERUPGRADED 0.04298727 26 / 832 (3%) 274.4531 2430
CLRHOST_STATE_ACCESS 0.01783699 3 / 832 (0%) 2985 12272
QDS_DYN_VECTOR 0.001644837 13 / 832 (2%) 12.95455 131
WAIT_XTP_OFFLINE_CKPT_NEW_LOG 18.18028 3 / 832 (0%) 4676.167 5003
TRAN_MARKLATCH_SH 1.725254E-06 3 / 832 (0%) 13.875 42
HADR_TRANSPORT_SESSION 4.068838E-06 6 / 832 (1%) 59.11111 330
HADR_DB_OP_START_SYNC 1.649081E-09 1 / 832 (0%) 1 1
HADR_RECOVERY_WAIT_FOR_UNDO 2.946808E-05 4 / 832 (0%) 1156.4 3532
AUDIT_ON_DEMAND_TARGET_LOCK 3.224005E-07 2 / 832 (0%) 16.5 17
SERVER_RECONFIGURE 3.185287E-05 3 / 832 (0%) 1841.5 2811
QDS_BLOOM_FILTER 0.0002646061 9 / 832 (1%) 2.352941 18
SOS_SMALL_PAGE_ALLOC 1.432221E-05 11 / 832 (1%) 0.3913043 6
WAIT_XTP_OFFLINE_CKPT_LOG_IO 3.153087E-06 1 / 832 (0%) 1 1
QDS_STMT 1.883466E-06 19 / 832 (2%) 1.311111 12
SP_SERVER_DIAGNOSTICS_BUFFER_ACCESS 5.728856E-06 5 / 832 (1%) 799.5714 2793
QRY_PROFILE_LIST_MUTEX 3.717005E-06 2 / 832 (0%) 8.5 18
FILESTREAM_WORKITEM_QUEUE 64.47813 1 / 832 (0%) 600 600
XE_CX_FILE_READ 1.201615E-06 3 / 832 (0%) 0.4 1
PWAIT_MD_SERVER_CACHE 3.163637E-07 1 / 832 (0%) 0 0
PREEMPTIVE_OS_OPENDIRECTORY 0.08526912 1 / 832 (0%) 0 0
HADR_COMPRESSED_CACHE_SYNC 0.0002086778 5 / 832 (1%) 0 0
MSSEARCH 0.001290009 7 / 832 (1%) 64.4 588
SQLCLR_ASSEMBLY 7.92369E-06 8 / 832 (1%) 5.769231 18
PREEMPTIVE_SHAREDMEM_GETDATA 1.282565 1 / 832 (0%) 68.5 70
METADATA_LAZYCACHE_RWLOCK 5.165711E-06 7 / 832 (1%) 1.545455 4
SLEEP_MASTERMDREADY 0.07849737 12 / 832 (1%) 652.4722 7921
COMMIT_TABLE 2.808079E-05 7 / 832 (1%) 7.764706 62
NET_WAITFOR_PACKET 0.0006384038 6 / 832 (1%) 102.4 108
PREEMPTIVE_OS_SQLCLROPS 3.701516E-07 2 / 832 (0%) 5 5
QRY_MEM_GRANT_INFO_MUTEX 1.259996E-07 7 / 832 (1%) 0 0
PREEMPTIVE_OS_DIRSVC_NETWORKOPS 0.000142865 9 / 832 (1%) 47.89286 102
PREEMPTIVE_CLOSEBACKUPMEDIA 3.884375E-09 2 / 832 (0%) 5 5
HADR_NOTIFICATION_WORKER_TERMINATION_SYNC 4.925797E-05 5 / 832 (1%) 58.71429 257
PREEMPTIVE_HADR_LEASE_MECHANISM 6.993332 10 / 832 (1%) 5.911911E+08 1.640512E+09 Occurs when there is a problem with an availability group and the failover cluster lease is renewed.
PWAIT_REPLICA_ONLINE_INIT_MUTEX 3.615183E-09 2 / 832 (0%) 1.5 3
UTIL_PAGE_ALLOC 0.0001827734 1 / 832 (0%) 6003 6003
SLEEP_TEMPDBSTARTUP 0.1625368 2 / 832 (0%) 149 254
WORKTBL_DROP 0.0002046777 1 / 832 (0%) 5014 5014
PREEMPTIVE_OS_GETCOMPRESSEDFILESIZE 0.0002894317 1 / 832 (0%) 0 0
PREEMPTIVE_OS_NETLOCALGROUPGETMEMBERS 4.302328E-09 1 / 832 (0%) 3 3
COUNTRECOVERYMGR 3.12205E-08 2 / 832 (0%) 0 0
PWAIT_COOP_SCAN 4.58632E-07 1 / 832 (0%) 0 0
SQLTRACE_PENDING_BUFFER_WRITERS 1.380537E-05 4 / 832 (0%) 21.5 47
PREEMPTIVE_OLEDB_JOINTRANSACTION 0.002984607 8 / 832 (1%) 1.73913 4
SLEEP_MSDBSTARTUP 0.0005968752 2 / 832 (0%) 2422 4931
HADR_TRANSPORT_FLOW_CONTROL 0.0180622 2 / 832 (0%) 535 737
PREEMPTIVE_OS_NETGROUPGETUSERS 7.952433E-08 2 / 832 (0%) 2 2
PREEMPTIVE_OS_GETFINALFILEPATHBYHANDLE 0.0002191513 14 / 832 (2%) 0 0
FS_HEADER_RWLOCK 2.262863E-06 1 / 832 (0%) 7 7
PREEMPTIVE_FSRECOVER_UNCONDITIONALUNDO 1.645719E-05 1 / 832 (0%) 45 45
HADR_DBR_SUBSCRIBER_FILTER_LIST 5.972085E-08 4 / 832 (0%) 0 0
FFT_NSO_FCB 3.135668E-08 2 / 832 (0%) 8.5 11
TERMINATE_LISTENER 1.866365E-07 6 / 832 (1%) 33.55556 280
BROKER_REGISTERALLENDPOINTS 5.785297E-05 1 / 832 (0%) 165 165
XE_BUFFERMGR_FREEBUF_EVENT 0.0005889254 1 / 832 (0%) 541 541
CONNECTION_ENDPOINT_LOCK 5.237949E-08 1 / 832 (0%) 0 0
CXCONSUMER 17.74056 27 / 832 (3%) 49.63158 265
FT_COMPROWSET_RWLOCK 2.666754E-09 1 / 832 (0%) 0 0
TRAN_MARKLATCH_EX 7.564017E-07 1 / 832 (0%) 9 12
ROWGROUP_VERSION 1.352479E-08 3 / 832 (0%) 0 0
PREEMPTIVE_COM_LBREADAT 0.0003388055 8 / 832 (1%) 0 0
PREEMPTIVE_COM_LBSTAT 0.0003554844 7 / 832 (1%) 0 0
PREEMPTIVE_COM_SETDATAFAILURE 8.249989E-08 3 / 832 (0%) 0 0
VIEW_DEFINITION_MUTEX 0.02272436 9 / 832 (1%) 0.08333334 1
XACTWORKSPACE_MUTEX 2.192925E-05 1 / 832 (0%) 0 0
PARALLEL_REDO_TRAN_TURN 0.1758008 3 / 832 (0%) 0 0
HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING 0.001945173 1 / 832 (0%) 5005 5005
PARALLEL_REDO_TRAN_LIST 5.314284E-06 1 / 832 (0%) 0 0
HTREINIT 0.0001646766 1 / 832 (0%) 6 8
BROKER_ENDPOINT_STATE_MUTEX 6.725114E-08 1 / 832 (0%) 14 14