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.08627114 697 / 926 (75%) 4490.696 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.626926 708 / 926 (76%) 19803.46 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.05249476 690 / 926 (75%) 28.10381 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.175358 692 / 926 (75%) 28.45804 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.2961207 707 / 926 (76%) 193.7667 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.4220818 710 / 926 (77%) 0.5096953 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.231297 710 / 926 (77%) 17.42348 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.09838966 711 / 926 (77%) 20.28746 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.119007 711 / 926 (77%) 8.160754 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.122693 709 / 926 (77%) 5.164154 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.849521 706 / 926 (76%) 47952.07 3278792 Occurs when a task is waiting for I/Os to finish.
ASYNC_NETWORK_IO 5.148189 711 / 926 (77%) 9.788483 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.5166489 709 / 926 (77%) 5.111982 706 Occurs when a checkpoint is throttling the issuance of new I/Os in order to avoid flooding the disk subsystem.
CHKPT 0.1913732 700 / 926 (76%) 5437.965 77325 Occurs at server startup to tell the checkpoint thread that it can start.
SLEEP_DBSTARTUP 0.2139933 636 / 926 (69%) 102.7209 292 Occurs during database startup while waiting for all databases to recover.
SLEEP_MASTERDBREADY 0.2035498 547 / 926 (59%) 6395.597 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.02803412 691 / 926 (75%) 498.9341 12993 Occurs once at most during SQL Server instance startup while waiting for DCOM initialization to complete.
THREADPOOL 0.1867512 702 / 926 (76%) 3631.927 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 3.976305 711 / 926 (77%) 0.3997785 85 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 6.804156 595 / 926 (64%) 56.18471 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.35981 594 / 926 (64%) 2451.758 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.001464078 284 / 926 (31%) 23.60368 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.156859 711 / 926 (77%) 6.783066 2422 Occurs while waiting for a log flush to complete. Common operations that cause log flushes are checkpoints and transaction commits.
MSQL_XP 0.7315615 711 / 926 (77%) 87.55235 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.06580529 616 / 926 (67%) 28.37931 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.001103033 508 / 926 (55%) 13.26189 1122 Occurs while the dedicated administrator connection is initializing.
XE_BUFFERMGR_ALLPROCESSED_EVENT 0.08106531 453 / 926 (49%) 7.835661 621 Occurs when Extended Events session buffers are flushed to targets. This wait occurs on a background thread.
PREEMPTIVE_OS_AUTHENTICATIONOPS 1.161039 702 / 926 (76%) 0.4022284 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.02252237 487 / 926 (53%) 0.04013378 12 when a thread is calling the Windows DecryptMessage function.
PREEMPTIVE_OS_DELETESECURITYCONTEXT 0.2225831 702 / 926 (76%) 0.3272018 23 when a thread is calling the Windows DeleteSecurityContext function.
PREEMPTIVE_OS_ENCRYPTMESSAGE 0.05094933 286 / 926 (31%) 0.4495413 41 Occurs when calling Windows EncryptMessage function.
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES 0.05669613 556 / 926 (60%) 0.06479482 11 when a thread is calling the Windows QueryContextAttributes function.
PREEMPTIVE_OS_AUTHORIZATIONOPS 0.1046229 702 / 926 (76%) 0.5189521 46 generic wait for when a thread is calling one of several Windows functions related to security permissions.
PREEMPTIVE_OS_LOOKUPACCOUNTSID 0.0589587 644 / 926 (70%) 7.027972 2942 Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
PREEMPTIVE_OS_REVERTTOSELF 0.05898199 701 / 926 (76%) 0.07921349 15 when a thread is calling the Windows RevertToSelf function.
PREEMPTIVE_COM_COCREATEINSTANCE 0.003139541 340 / 926 (37%) 24.57091 1995 Occurs when the SQLOS scheduler switches to preemptive mode to create a COM object.
PREEMPTIVE_OS_CRYPTOPS 0.0547143 695 / 926 (75%) 76.43461 2010 generic wait for when a thread is calling one of several Windows functions related to cryptography.
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT 0.05653505 700 / 926 (76%) 0.3120448 55 when a thread is calling the Windows CryptAcquireContext function.
PREEMPTIVE_OS_CRYPTIMPORTKEY 0.04878418 672 / 926 (73%) 0.3103651 31 when a thread is calling the Windows CryptImportKey function.
PREEMPTIVE_OS_FILEOPS 0.2614492 697 / 926 (75%) 16.1708 4159 Occurs when SQLOS scheduler switches to preemptive mode to wait for file system operations to complete
PREEMPTIVE_OS_CREATEFILE 0.06701656 698 / 926 (75%) 6.751977 1125 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.005726873 647 / 926 (70%) 0.3431434 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.02007824 695 / 926 (75%) 12.43328 8865 when a thread is calling the Windows GetFileAttributes function.
PREEMPTIVE_OS_GETVOLUMEPATHNAME 0.01419927 580 / 926 (63%) 1.985487 355 when a thread is calling the Windows GetVolumePathName function possibly during a BACKUP DATABASE operation.
PREEMPTIVE_OS_WRITEFILE 0.2306795 600 / 926 (65%) 27.26667 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.3618465 695 / 926 (75%) 3255.519 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.1603841 608 / 926 (66%) 3845.468 39570 Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
PREEMPTIVE_OS_GETPROCADDRESS 0.1768349 649 / 926 (70%) 37.69595 20200 when a thread is calling the Windows GetProcAddress function, to get the extended stored procedure address from a DLL.
PREEMPTIVE_OS_LOADLIBRARY 0.009790595 691 / 926 (75%) 74.54121 4401 when a thread is calling the Windows LoadLibrary function.
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE 0.1138717 672 / 926 (73%) 0.5104167 155 when a thread is calling the Windows DisconnectNamedPipe function during disconnecting a named pipe connection from a client.
PREEMPTIVE_OS_REPORTEVENT 0.04311572 696 / 926 (75%) 1.941906 73 when a thread is calling the Windows ReportEvent function, during printing to the event log.
PREEMPTIVE_OS_QUERYREGISTRY 0.08209616 681 / 926 (74%) 1.092849 101 Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
PREEMPTIVE_CLOSEBACKUPVDIDEVICE 0.01333118 263 / 926 (28%) 2.248869 169 Occurs when the SQLOS scheduler switches to preemptive mode to close a virtual backup device.
PREEMPTIVE_XE_CALLBACKEXECUTE 0.4637299 641 / 926 (69%) 0.004889976 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.213225 555 / 926 (60%) 29.00845 620 when a thread switches to preemptive mode as part of querying the state of a XE session target.
PREEMPTIVE_XE_SESSIONCOMMIT 0.06552795 533 / 926 (58%) 1.077903 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.01533862 565 / 926 (61%) 7.240113 356 when a thread is switching to preemptive mode while creating an Extended Event session target.
WRITE_COMPLETION 0.05256934 691 / 926 (75%) 7.937103 472 Occurs when a write operation is in progress.
PERFORMANCE_COUNTERS_RWLOCK 0.006713727 537 / 926 (58%) 2.682443 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.340566 547 / 926 (59%) 13793.85 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.143342 332 / 926 (36%) 417.8863 10971 Occurs when waiting for Filetable recovery to run when starting up a database.
WAIT_XTP_HOST_WAIT 1.517335 270 / 926 (29%) 111602.6 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.00158579 143 / 926 (15%) 36.49432 777
LCK_M_U 1.610026 578 / 926 (62%) 248659.6 3.427023E+08 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.7201549 678 / 926 (73%) 1750.475 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.5835525 547 / 926 (59%) 40101.57 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.2607732 656 / 926 (71%) 3.821832 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.596597 479 / 926 (52%) 145.2654 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.02636414 678 / 926 (73%) 1.578601 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.4386325 291 / 926 (31%) 2952.872 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.000419944 385 / 926 (42%) 7.385902 130 Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
PREEMPTIVE_OS_AUTHZGETINFORMATIONFROMCONTEXT 0.0002382432 285 / 926 (31%) 0.2278107 11 when a thread is calling the Windows AuthzGetInformationFromContext function.
PREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSID 0.01555704 395 / 926 (43%) 111.5241 5031 when a thread is calling the Windows AuthzInitializeContextFromSid function.
PREEMPTIVE_OS_AUTHZINITIALIZERESOURCEMANAGER 0.0003668682 300 / 926 (32%) 1.43338 227 when a thread is calling the Windows AuthzInitializeResourceManager function.
PREEMPTIVE_OS_COMOPS 0.01418449 476 / 926 (51%) 274.2048 3979 generic wait for when a thread is calling one of several Windows functions related to COM.
PREEMPTIVE_COM_CREATEACCESSOR 0.00551609 157 / 926 (17%) 0.2583979 20 Occurs when the SQLOS scheduler switches to preemptive mode to wait for the CreateAccessor function of a COM object.
PREEMPTIVE_COM_GETDATA 0.4588292 144 / 926 (16%) 0.07471264 9 Occurs when the SQLOS scheduler switches to preemptive mode to wait for the GetData function of a COM object.
PREEMPTIVE_COM_QUERYINTERFACE 0.2897266 293 / 926 (32%) 1126.99 276565 accumulated wait time for linked server queries and remote operations.
PREEMPTIVE_COM_RELEASE 0.02828838 126 / 926 (14%) 1.622074 75 Unknown
PREEMPTIVE_COM_RELEASEACCESSOR 0.007508826 107 / 926 (12%) 0.2235772 20 Occurs when the SQLOS scheduler switches to preemptive mode to wait for the ReleaseAccessor function of a COM object.
PREEMPTIVE_COM_RELEASEROWS 0.006718643 136 / 926 (15%) 0.168639 14 Occurs when the SQLOS scheduler switches to preemptive mode to wait for the ReleaseRows function of a COM object.
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY 0.04760618 443 / 926 (48%) 5.393939 592 when a thread is calling the Windows NetValidatePasswordPolicy function.
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE 0.008874413 360 / 926 (39%) 0.2096413 11 when a thread is calling the Windows NetValidatePasswordPolicyFree function.
PREEMPTIVE_DTC_ABORTREQUESTDONE 0.003601373 49 / 926 (5%) 0.6880734 6 Occurs when waiting for the Abort request of the Distributed Transaction Controller. This occurs after a failed prepair.
PREEMPTIVE_DTC_COMMITREQUESTDONE 0.08604148 61 / 926 (7%) 0.6376812 6 Unknown
PREEMPTIVE_DTC_ENLIST 0.04236633 99 / 926 (11%) 18.97447 1951 Occurs enlisting a transaction as part of a distributed transaction.
PREEMPTIVE_DTC_PREPAREREQUESTDONE 0.05234342 63 / 926 (7%) 0.4296296 13 Unknown
PREEMPTIVE_OS_DELETEFILE 0.0007394388 626 / 926 (68%) 28.35606 6651 Occurs when deleting a file.
PREEMPTIVE_OS_FLUSHFILEBUFFERS 0.06972288 605 / 926 (65%) 19.58012 4033 Occurs when flushing all in-memory buffers for a file to disk (checkpoint, backup or database close).
PREEMPTIVE_OS_GETDISKFREESPACE 0.000593279 595 / 926 (64%) 1.334031 515 Occurs when checking disk free space as part of database restore or log growth.
PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT 0.0001730785 299 / 926 (32%) 0.2255193 8 Occurs when getting the volume name (creating or restoring a database).
PREEMPTIVE_OLEDBOPS 0.2796006 427 / 926 (46%) 45.30716 4968 Occurs when waiting for OLE DB information.
PREEMPTIVE_OLEDB_GETPROPERTIES 0.001086187 107 / 926 (12%) 4.8375 100 Unknown
PREEMPTIVE_OLEDB_GETPROPERTYINFO 6.038187E-05 96 / 926 (10%) 0.994898 10 Unknown
PREEMPTIVE_OLEDB_RELEASE 0.003590563 110 / 926 (12%) 15.32129 460 Unknown
PREEMPTIVE_OLEDB_SETPROPERTIES 0.0004000111 113 / 926 (12%) 0.2962963 26 Unknown
PREEMPTIVE_OS_SECURITYOPS 0.01778615 276 / 926 (30%) 0.1411043 12 when a thread is calling one of several Windows functions related to security.
PREEMPTIVE_OS_WAITFORSINGLEOBJECT 0.5167843 462 / 926 (50%) 5.80713 1330 Occurs during synchronization with an external client process, often seen with ASYNC_NETWORK_IO.
PREEMPTIVE_SB_STOPENDPOINT 0.0006994968 138 / 926 (15%) 18.37011 889 when a thread is calling out to Windows while shutting down a Service Broker endpoint.
PREEMPTIVE_TRANSIMPORT 0.100181 59 / 926 (6%) 3.674797 207 Unknown
SQLTRACE_FILE_WRITE_IO_COMPLETION 0.005449815 430 / 926 (46%) 9.138104 675 Occurs while waiting for a write to a trace file to complete.
SQLTRACE_FILE_READ_IO_COMPLETION 0.03490969 257 / 926 (28%) 8.641149 236 Occurs while waiting for a read from a trace file to complete.
SECURITY_CRYPTO_CONTEXT_MUTEX 0.0002178875 162 / 926 (17%) 19.87709 2054 Unknown
LCK_M_SCH_S 0.2074256 511 / 926 (55%) 10600.87 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.01895572 121 / 926 (13%) 2396.45 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.005836807 124 / 926 (13%) 3081.493 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 10.27496 266 / 926 (29%) 171417.3 346448 Occurs when the RECEIVE WAITFOR is waiting. This is typical if no messages are ready to be received.
CXPACKET 27.38881 582 / 926 (63%) 52.52815 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 / 926 (27%) 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.332809 540 / 926 (58%) 95.22136 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.0001494639 114 / 926 (12%) 5.424242 403 Occurs while waiting for a CLR task to complete startup.
CLR_CRST 0.001054965 188 / 926 (20%) 43.13636 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.0001492341 46 / 926 (5%) 21.0177 708 Occurs when a task is currently performing CLR execution and is waiting to obtain a lock on the monitor.
SQLCLR_APPDOMAIN 0.001125689 61 / 926 (7%) 762.7316 34604 Occurs while CLR waits for an application domain to complete startup.
SOS_SYNC_TASK_ENQUEUE_EVENT 0.001161918 192 / 926 (21%) 11.69216 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 4.091931E-05 233 / 926 (25%) 9.679436 558 Occurs during synchronization of certain types of memory allocations during statement execution.
QUERY_EXECUTION_INDEX_SORT_EVENT_OPEN 0.011422 129 / 926 (14%) 51.32197 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.0008289238 114 / 926 (12%) 8.081967 118 Occurs when there is a wait for all tasks to finish during a NUMA node state change.
CXROWSET_SYNC 0.02966762 474 / 926 (51%) 0.4872521 35 Occurs during a parallel range scan.
PREEMPTIVE_OS_GENERICOPS 0.2657465 433 / 926 (47%) 448.259 17376 Occurs when thread calls generic Windows functions.
PREEMPTIVE_OS_DOMAINSERVICESOPS 0.005645849 599 / 926 (65%) 361.3321 84193 generic wait for when a thread is calling one of several Windows functions related to domain services
PREEMPTIVE_OS_CLOSEHANDLE 0.00552117 430 / 926 (46%) 11.3501 572 Occurs when calling Windows CloseHandle function.
PREEMPTIVE_OS_PIPEOPS 0.5697727 488 / 926 (53%) 38007.24 7802583 Occurs when calling Windows functions that work with pipes.
FT_IFTS_RWLOCK 0.3301099 242 / 926 (26%) 10301.75 227981
BROKER_TRANSMISSION_OBJECT 0.00522844 20 / 926 (2%) 6.476191 90
LCK_M_IS 0.3397092 448 / 926 (48%) 22442.61 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.02377471 349 / 926 (38%) 1851.189 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 / 926 (0%) 5312 5312
BACKUP 0.01079738 155 / 926 (17%) 77.5377 4291 Occurs when a task is blocked as part of backup processing.
BACKUPBUFFER 4.369435 486 / 926 (52%) 8.637138 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 / 926 (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.0001596176 80 / 926 (9%) 0.8536586 6 Occurs during synchronization of access to the collection of statistics used to populate sys.dm_os_wait_stats.
DEADLOCK_ENUM_MUTEX 0.002672298 180 / 926 (19%) 140.0581 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.170923E-05 250 / 926 (27%) 21.20599 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.01569177 552 / 926 (60%) 0.5023511 118 Occurs during internal synchronization within SQL Server networking components.
XE_SERVICES_MUTEX 0.1720123 216 / 926 (23%) 204.9844 59943
PREEMPTIVE_OS_ACCEPTSECURITYCONTEXT 3.556908E-05 54 / 926 (6%) 16.7037 905 Occurs when retrieving security authentication and authorization.
PREEMPTIVE_OS_ACQUIRECREDENTIALSHANDLE 1.375741E-05 47 / 926 (5%) 1.144444 25 Occurs when retrieving Windows credentials handle.
PREEMPTIVE_OS_INITIALIZESECURITYCONTEXT 3.216926E-05 53 / 926 (6%) 3.663551 52 Occurs when calling Windows InitializeSecurityContext function.
PREEMPTIVE_OS_SETFILEVALIDDATA 0.001361699 353 / 926 (38%) 6.670303 566 Occurs during creation or growth of a data file for Instant File Initialization.
PREEMPTIVE_OS_GETADDRINFO 0.0004401599 54 / 926 (6%) 11.99057 962 Occurs when calling Windows GetAddrInfo function.
PREEMPTIVE_OS_WSASETLASTERROR 0.2283492 50 / 926 (5%) 5414.268 21074 Occurs when calling Windows WsaSetLastError function.
HADR_CLUSAPI_CALL 13.58074 64 / 926 (7%) 140 256 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.0003489224 33 / 926 (4%) 0.6 3 Concurrency control wait on the AlwaysOn Availability Groups background work task object.
HADR_WORK_QUEUE 41.28014 37 / 926 (4%) 670.8421 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.0001181126 19 / 926 (2%) 121.88 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.234937E-06 34 / 926 (4%) 10.23256 107 Occurs when a task is waiting for the log pool cache size to be changed for a database.
LOGPOOL_FREEPOOLS 0.0007231605 95 / 926 (10%) 9.126829 542 Occurs when a task is waiting for access to the log free pool manager.
LOGPOOL_REPLACEMENTSET 0.0001562111 74 / 926 (8%) 1.540323 73 Occurs when a task is waiting for log data to be written to the log pool.
HADR_SYNC_COMMIT 1.111612 25 / 926 (3%) 61.375 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.01406075 37 / 926 (4%) 690.4286 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.03163847 36 / 926 (4%) 0.2545455 6
HADR_LOGPROGRESS_SYNC 0.0007059353 29 / 926 (3%) 12.075 253 Concurrency control wait when updating the log progress status of database replicas.
XDESTSVERMGR 0.001050406 30 / 926 (3%) 117.3953 629
HADR_REPLICAINFO_SYNC 0.0002802714 25 / 926 (3%) 189.3 1753 Waiting for concurrency control to update the current replica state.
HADR_NOTIFICATION_DEQUEUE 14.12417 38 / 926 (4%) 5155708 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.008536751 30 / 926 (3%) 0.2391304 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.002121855 24 / 926 (3%) 183.0909 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.43617 32 / 926 (3%) 1373.22 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.684949E-06 36 / 926 (4%) 155.3455 3765
HADR_TIMER_TASK 6.108031 36 / 926 (4%) 459.8727 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.25344 23 / 926 (2%) 2.28125 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.001318101 18 / 926 (2%) 6.25 11 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.75575 58 / 926 (6%) 7183.527 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.439468 138 / 926 (15%) 14397.19 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.3400095 194 / 926 (21%) 2018.569 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.001414609 113 / 926 (12%) 3444.532 232784 generic wait for when a thread is calling one of several Windows functions related to DTC.
ASYNC_DISKPOOL_LOCK 0.0008956339 107 / 926 (12%) 3.985222 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.001372221 371 / 926 (40%) 8.482279 2064 Occurs when Windows initializes the SQM error reporting system.
IO_AUDIT_MUTEX 0.007956387 82 / 926 (9%) 0.1971831 13 Occurs during synchronization of trace event buffers.
BROKER_TRANSMISSION_WORK 3.386273E-05 120 / 926 (13%) 29.51754 2610
DTC_STATE 0.0001971949 17 / 926 (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 / 926 (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.406632E-05 81 / 926 (9%) 0.1616766 5 Unknown
PREEMPTIVE_OLEDB_GETLITERALINFO 8.716488E-05 67 / 926 (7%) 1.53125 90 Unknown
LOGMGR_RESERVE_APPEND 0.1421743 34 / 926 (4%) 1039.365 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 9.146364E-05 58 / 926 (6%) 1.044944 9 Occurs when a task is waiting for access to a log pool consumer.
SOSHOST_MUTEX 4.6762E-05 49 / 926 (5%) 13.33 469 Occurs when a hosted component, such as CLR, waits on a SQL Server mutex synchronization object.
BROKER_TRANSMISSION_TABLE 0.006131749 115 / 926 (12%) 31.12174 1576 Occurs when Waiting for inactive transmission objects to be written to tempdb.
PREEMPTIVE_XE_TARGETFINALIZE 0.006666534 228 / 926 (25%) 0.2808442 18 Occurs when destroying an extended event target.
PREEMPTIVE_OS_VERIFYTRUST 0.01376396 210 / 926 (23%) 64.72154 3096
MEMORY_ALLOCATION_EXT 0.6674636 109 / 926 (12%) 0 0
RESERVED_MEMORY_ALLOCATION_EXT 0.07712785 213 / 926 (23%) 0 0
PARALLEL_REDO_WORKER_WAIT_WORK 1.641202 199 / 926 (21%) 10.6721 89
SESSION_WAIT_STATS_CHILDREN 0.03806671 147 / 926 (16%) 0.6747312 23
QDS_ASYNC_QUEUE 54.29299 69 / 926 (7%) 2711277 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.01659231 171 / 926 (18%) 897.1697 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.6173748 61 / 926 (7%) 37.875 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.004680429 87 / 926 (9%) 10.58378 237 Occurs when SQL Server waits for a bulkload I/O to finish.
CMEMPARTITIONED 2.60845E-05 21 / 926 (2%) 0.3 5
TRANSACTION_MUTEX 0.4436939 207 / 926 (22%) 602.2911 27613 Occurs during synchronization of access to a transaction by multiple batches.
QUERY_NOTIFICATION_MGR_MUTEX 3.433024E-07 8 / 926 (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 / 926 (1%) 0.1176471 1 Occurs during internal synchronization within the Query Notification Manager.
SOS_PROCESS_AFFINITY_MUTEX 0.0001522006 48 / 926 (5%) 9.780822 146 Occurs during synchronizing of access to process affinity settings.
PREEMPTIVE_COM_RESTARTPOSITION 0.01094878 62 / 926 (7%) 68.67939 8075
PREEMPTIVE_DTC_BEGINTRANSACTION 0.03778292 70 / 926 (8%) 2.319527 74 Occurs when waiting for the Distributed Transaction Controller to start a transaction.
PAGELATCH_KP 4.724924E-07 95 / 926 (10%) 0.4507042 17
LOGPOOL_CONSUMERSET 2.387434E-05 53 / 926 (6%) 1.730337 54 Occurs when a task is waiting for a log pool consumer to be created or destroyed.
LCK_M_SIX 0.03332301 27 / 926 (3%) 5590.608 17685
LATCH_UP 0.0002970169 175 / 926 (19%) 458.4749 16490
SOS_PHYS_PAGE_CACHE 0.01362577 74 / 926 (8%) 33.90306 6321
PARALLEL_BACKUP_QUEUE 0.06827933 245 / 926 (26%) 90.96741 8375
FCB_REPLICA_WRITE 0.001955427 106 / 926 (11%) 139.6325 2383
FCB_REPLICA_READ 0.0002352135 108 / 926 (12%) 72.09502 1076
EXCHANGE 0.0003650464 61 / 926 (7%) 0.378882 15
DTC_ABORT_REQUEST 0.6161913 41 / 926 (4%) 3060.352 4200
EE_SPECPROC_MAP_INIT 4.123626E-06 13 / 926 (1%) 29.04762 155
PREEMPTIVE_OS_CLUSTEROPS 3.638963E-05 64 / 926 (7%) 55.31298 345 Occurs when calling Windows functions that work with failover clusters.
PREEMPTIVE_CLUSAPI_CLUSTERRESOURCECONTROL 0.003757338 59 / 926 (6%) 1.26087 7
PREEMPTIVE_COM_GETCOMMANDTEXT 0.0009311612 28 / 926 (3%) 1.368421 23
PREEMPTIVE_COM_GETRESULT 0.001959503 26 / 926 (3%) 3.566038 27
PREEMPTIVE_COM_RELEASESESSION 0.0007813059 22 / 926 (2%) 1.319149 16
PREEMPTIVE_COM_SETPARAMETERINFO 0.0001781855 83 / 926 (9%) 0.1980198 8
PREEMPTIVE_COM_SETPARAMETERPROPERTIES 0.0001691936 74 / 926 (8%) 0.2977528 13
PREEMPTIVE_OS_DEVICEOPS 0.3002333 95 / 926 (10%) 2.519313 20 Occurs when calling Windows functions that work with device control.
PREEMPTIVE_OS_DEVICEIOCONTROL 0.000114245 200 / 926 (22%) 1.125858 35 Occurs when calling the Windows DeviceControl function.
PREEMPTIVE_OS_MOVEFILE 0.001932134 82 / 926 (9%) 2.493151 24
PREEMPTIVE_ODBCOPS 0.02635148 31 / 926 (3%) 245.4194 2950
PREEMPTIVE_CREATEPARAM 7.49806E-06 85 / 926 (9%) 258.8932 8920
PREEMPTIVE_XE_DISPATCHER 8.540884 64 / 926 (7%) 6.903383E+07 1.140147E+09
CREATE_DATINISERVICE 0.0002895414 9 / 926 (1%) 219.6 724
SOS_DISPATCHER_MUTEX 2.530247E-06 88 / 926 (10%) 0.09210526 3
PREEMPTIVE_OS_FINDFILE 0.008287413 25 / 926 (3%) 0.1666667 4
LCK_M_BU 0.04016092 28 / 926 (3%) 41243.07 569290
QDS_TASK_SHUTDOWN 0.02156012 21 / 926 (2%) 12.51389 85
PREEMPTIVE_DEBUG 0.07176276 60 / 926 (6%) 899.4783 8569
PREEMPTIVE_OLE_UNINIT 0.0008541608 86 / 926 (9%) 0.9346734 14
XE_LIVE_TARGET_TVF 1.927648 47 / 926 (5%) 18135.51 309190
SOS_RESERVEDMEMBLOCKLIST 0.0001919889 97 / 926 (10%) 3.386719 79
SOS_LOCALALLOCATORLIST 2.459858E-05 68 / 926 (7%) 1.314136 48
SQLSORT_SORTMUTEX 0.001820303 30 / 926 (3%) 39.89063 176
SQLTRACE_LOCK 0.00885215 44 / 926 (5%) 39.03409 338
CLEAR_DB 0.0007900007 12 / 926 (1%) 379.5555 1771
FFT_NSO_DB_LIST 0.0002863942 21 / 926 (2%) 7.216216 121
SEQUENTIAL_GUID 1.314933E-06 6 / 926 (1%) 1.071429 14
DEADLOCK_TASK_SEARCH 8.431251E-06 55 / 926 (6%) 104.1556 1897
WAITFOR_PER_QUEUE 2.035825E-05 33 / 926 (4%) 0.1923077 4
LOGMGR 0.0001592742 10 / 926 (1%) 19.375 24
PRINT_ROLLBACK_PROGRESS 0.01652502 107 / 926 (12%) 3141.677 6027
LOGPOOL_MGRSET 2.181146E-05 2 / 926 (0%) 0 0
DBMIRRORING_CMD 33.38171 19 / 926 (2%) 1097218 1.76015E+07
DBMIRROR_DBM_EVENT 0.5020888 13 / 926 (1%) 4.466667 41
DBMIRROR_SEND 2.234304 16 / 926 (2%) 4737.079 92007
DBMIRROR_EVENTS_QUEUE 36.23943 19 / 926 (2%) 288.0714 2230
DBMIRROR_WORKER_QUEUE 0.4589762 19 / 926 (2%) 451774.2 2.044341E+07
QUERY_TASK_ENQUEUE_MUTEX 0.0168242 48 / 926 (5%) 0.2358491 7
PREEMPTIVE_OS_CREATEDIRECTORY 0.003779935 16 / 926 (2%) 10.88235 80
WAIT_XTP_RECOVERY 0.3016467 9 / 926 (1%) 287148.9 1066500
PWAIT_DIRECTLOGCONSUMER_GETNEXT 40.06166 6 / 926 (1%) 47421 86404
PARALLEL_REDO_WORKER_SYNC 0.009148079 171 / 926 (18%) 6.345815 226
BROKER_INIT 0.001547266 28 / 926 (3%) 1040.917 3002
QDS_CTXS 9.695603E-06 4 / 926 (0%) 27.875 223
XE_FILE_TARGET_TVF 0.1082757 58 / 926 (6%) 12.05645 304
SLEEP_BUFFERPOOL_HELPLW 0.08718029 125 / 926 (13%) 4.831081 242
PARALLEL_REDO_DRAIN_WORKER 0.006487392 137 / 926 (15%) 77.70317 3629
XE_SESSION_FLUSH 0.01446057 123 / 926 (13%) 124.316 4997
DEBUG 1.46696E-07 31 / 926 (3%) 4.364706 36
SOS_MEMORY_TOPLEVELBLOCKALLOCATOR 5.843549E-06 21 / 926 (2%) 77.64706 1257
REPL_SCHEMA_ACCESS 0.0004759187 34 / 926 (4%) 1.28 18
REPL_CACHE_ACCESS 1.53706E-06 1 / 926 (0%) 8 8
SQLCLR_QUANTUM_PUNISHMENT 0.0003484888 8 / 926 (1%) 1.916667 23
REQUEST_DISPENSER_PAUSE 0.0006137833 78 / 926 (8%) 703.5804 1337
XE_SESSION_SYNC 5.163158E-06 23 / 926 (2%) 6.948718 127
XE_TIMER_MUTEX 3.745917E-05 43 / 926 (5%) 0.1414141 3
MD_LAZYCACHE_RWLOCK 0.0006084569 47 / 926 (5%) 2.058252 19
PWAIT_MD_RELATION_CACHE 1.178729E-05 29 / 926 (3%) 0.8727273 5
LOGPOOLREFCOUNTEDOBJECT_REFDONE 2.96424E-06 19 / 926 (2%) 2.636364 22
RESOURCE_GOVERNOR_IDLE 1.320081 1 / 926 (0%) 4 4
SEQUENCE_GENERATION 0.01339397 37 / 926 (4%) 3.313725 32
BUILTIN_HASHKEY_MUTEX 4.250652E-06 6 / 926 (1%) 18.66667 96
PREEMPTIVE_OS_FORMATMESSAGE 2.00286E-05 8 / 926 (1%) 0.4 4
FT_MASTER_MERGE 0.005047181 20 / 926 (2%) 16649.14 257281
QDS_BCKG_TASK 1.407078E-07 15 / 926 (2%) 0 0
QDS_LOADDB 0.0009352764 18 / 926 (2%) 7485.976 85412
NODE_CACHE_MUTEX 3.580499E-07 20 / 926 (2%) 0.53125 4
PREEMPTIVE_COM_GETROWSBYBOOKMARK 0.001620534 26 / 926 (3%) 1.358491 27
PREEMPTIVE_OLEDB_ABORTORCOMMITTRAN 0.002631936 23 / 926 (2%) 14.76316 177
LCK_M_RX_X 0.005437382 23 / 926 (2%) 4193.459 14611
BAD_PAGE_PROCESS 8.115714 6 / 926 (1%) 6035.545 15001
XE_SERVICES_RWLOCK 0.002500516 20 / 926 (2%) 13629.46 315422
PREEMPTIVE_OLEDB_ABORTTRAN 0.002350538 26 / 926 (3%) 0.9183673 3
PREEMPTIVE_OLEDB_GETSCHEMALOCK 0.03256581 20 / 926 (2%) 4.348837 43
DBMIRROR_DBM_MUTEX 9.056476 13 / 926 (1%) 91730 1867879
QDS_ASYNC_PERSIST_TASK_START 0.002068841 37 / 926 (4%) 126.3158 959
PARALLEL_REDO_FLOW_CONTROL 0.002586746 17 / 926 (2%) 522.1 2912
EXECUTION_PIPE_EVENT_INTERNAL 0.030793 14 / 926 (2%) 0.01818182 1
PREEMPTIVE_OS_RSFXDEVICEOPS 0.08138096 13 / 926 (1%) 0.05555556 1
PREEMPTIVE_OS_GETFILESIZE 0.00129065 6 / 926 (1%) 0.1428571 1
REDO_THREAD_PENDING_WORK 4.700575 17 / 926 (2%) 102.0435 110
REDO_THREAD_SYNC 0.003070651 12 / 926 (1%) 31.07143 368
HADR_DB_COMMAND 0.006384459 17 / 926 (2%) 625.1304 2194
PWAIT_HADR_WORKITEM_COMPLETED 7.050895E-05 18 / 926 (2%) 374.92 1206
HADR_PARTNER_SYNC 3.668275E-06 9 / 926 (1%) 28.38461 141
HADR_DBSTATECHANGE_SYNC 0.0002124965 14 / 926 (2%) 4294.944 20033
HADR_DBR_SUBSCRIBER 3.335798E-05 14 / 926 (2%) 5470.158 39623
HADR_BACKUP_BULK_LOCK 0.002863268 4 / 926 (0%) 127.1429 629
HADR_BACKUP_QUEUE 0.02590981 4 / 926 (0%) 2496.143 5221
RECOVERY_MGR_LOCK 0.0093875 49 / 926 (5%) 46.96 1021
DIRTY_PAGE_SYNC 7.316984E-06 8 / 926 (1%) 3.315789 14
PWAIT_RESOURCE_SEMAPHORE_FT_PARALLEL_QUERY_SYNC 0.0003134716 6 / 926 (1%) 6.548387 20
QRY_PARALLEL_THREAD_MUTEX 6.436638E-08 11 / 926 (1%) 2.347826 9
PREEMPTIVE_OS_REMOVEDIRECTORY 3.023492E-05 5 / 926 (1%) 3.285714 6
BROKER_SERVICE 1.911246E-05 9 / 926 (1%) 0.4615385 4
PREEMPTIVE_COM_SEQSTRMREAD 0.008721229 12 / 926 (1%) 0.3414634 14
UCS_TRANSPORT_STREAM_CHANGE 8.045254E-08 4 / 926 (0%) 2.5 5
PWAIT_HADR_ONLINE_COMPLETED 3.344666E-05 11 / 926 (1%) 4001.188 7245
HADR_TRANSPORT_DBRLIST 3.88608E-06 8 / 926 (1%) 12.83333 67
HADR_DATABASE_WAIT_FOR_RECOVERY 2.781449E-05 3 / 926 (0%) 419.75 473
CHECK_TABLES_INITIALIZATION 0.04025618 30 / 926 (3%) 2405.803 68180
CHECK_TABLES_THREAD_BARRIER 0.0006227058 29 / 926 (3%) 10.27778 220
DPT_ENTRY_LOCK 7.508184E-05 6 / 926 (1%) 109.3043 1556
SOS_VIRTUALMEMORY_LOW 0.00439211 3 / 926 (0%) 127.75 181
SQLTRACE_WAIT_ENTRIES 22.42889 13 / 926 (1%) 112815.6 300007
HTREPARTITION 0.2069268 13 / 926 (1%) 20.32353 288
HTBUILD 0.1234921 15 / 926 (2%) 135.1944 2309
HTMEMO 0.3595227 13 / 926 (1%) 42.94118 317
HTDELETE 0.149491 15 / 926 (2%) 19.97222 173
BMPBUILD 0.1843933 13 / 926 (1%) 0.9117647 8
PWAIT_QRY_BPMEMORY 0.001796195 13 / 926 (1%) 0.09677419 1
COLUMNSTORE_BUILD_THROTTLE 0.01039959 9 / 926 (1%) 23473.5 29201
XTP_PREEMPTIVE_TASK 11.36141 2 / 926 (0%) 1.100147E+07 2.771002E+07
PREEMPTIVE_SP_SERVER_DIAGNOSTICS 3.684485 16 / 926 (2%) 2.30324E+08 9.843073E+08
STARTUP_DEPENDENCY_MANAGER 0.03172417 22 / 926 (2%) 85.21568 183
FILE_VALIDATION_THREADS 1.346545E-07 3 / 926 (0%) 0.125 1
BMPREPARTITION 0.1806366 11 / 926 (1%) 0.5483871 8
BMPALLOCATION 0.1322136 11 / 926 (1%) 0.3225806 6
ROWGROUP_OP_STATS 3.338285E-05 2 / 926 (0%) 0 0
BPSORT 0.03124363 12 / 926 (1%) 37.71875 190
VERSIONING_COMMITTING 3.880555E-05 10 / 926 (1%) 15.47059 21
WAIT_XTP_TASK_SHUTDOWN 0.002062514 2 / 926 (0%) 6 17
PREEMPTIVE_OS_LOGONUSER 0.001022638 6 / 926 (1%) 160.7692 462
HADR_DB_OP_COMPLETION_SYNC 2.396568E-06 3 / 926 (0%) 7.333333 12
XE_SESSION_CREATE_SYNC 0.004511772 4 / 926 (0%) 83.55556 226
SLEEP_MASTERUPGRADED 0.0451355 37 / 926 (4%) 262.6627 2430
CLRHOST_STATE_ACCESS 0.01783699 3 / 926 (0%) 2985 12272
QDS_DYN_VECTOR 0.001206384 18 / 926 (2%) 11.43333 131
WAIT_XTP_OFFLINE_CKPT_NEW_LOG 32.69333 5 / 926 (1%) 4728.125 5003
TRAN_MARKLATCH_SH 1.725254E-06 3 / 926 (0%) 13.875 42
HADR_TRANSPORT_SESSION 4.068838E-06 6 / 926 (1%) 59.11111 330
HADR_DB_OP_START_SYNC 1.649081E-09 1 / 926 (0%) 1 1
HADR_RECOVERY_WAIT_FOR_UNDO 2.946808E-05 4 / 926 (0%) 1156.4 3532
AUDIT_ON_DEMAND_TARGET_LOCK 3.224005E-07 2 / 926 (0%) 16.5 17
SERVER_RECONFIGURE 3.185287E-05 3 / 926 (0%) 1841.5 2811
QDS_BLOOM_FILTER 0.0002143074 11 / 926 (1%) 2.238095 18
SOS_SMALL_PAGE_ALLOC 1.405284E-05 14 / 926 (2%) 0.3333333 6
WAIT_XTP_OFFLINE_CKPT_LOG_IO 0.0005329348 2 / 926 (0%) 3 9
QDS_STMT 1.683192E-06 24 / 926 (3%) 1.218182 12
SP_SERVER_DIAGNOSTICS_BUFFER_ACCESS 2.509715E-06 12 / 926 (1%) 350.0625 2793
QRY_PROFILE_LIST_MUTEX 8.962592E-05 4 / 926 (0%) 368.5555 3259
FILESTREAM_WORKITEM_QUEUE 64.47813 1 / 926 (0%) 600 600
XE_CX_FILE_READ 1.201615E-06 3 / 926 (0%) 0.4 1
PWAIT_MD_SERVER_CACHE 3.163637E-07 1 / 926 (0%) 0 0
PREEMPTIVE_OS_OPENDIRECTORY 0.02842307 3 / 926 (0%) 0 0
HADR_COMPRESSED_CACHE_SYNC 0.0002086778 5 / 926 (1%) 0 0
MSSEARCH 0.001182915 8 / 926 (1%) 59.09091 588
SQLCLR_ASSEMBLY 7.92369E-06 8 / 926 (1%) 5.769231 18
PREEMPTIVE_SHAREDMEM_GETDATA 1.282565 1 / 926 (0%) 68.5 70
METADATA_LAZYCACHE_RWLOCK 5.165711E-06 7 / 926 (1%) 1.545455 4
SLEEP_MASTERMDREADY 0.1022346 14 / 926 (2%) 739.3421 7921
COMMIT_TABLE 2.808079E-05 7 / 926 (1%) 7.764706 62
NET_WAITFOR_PACKET 0.0005913655 8 / 926 (1%) 102.7778 108
PREEMPTIVE_OS_SQLCLROPS 3.701516E-07 2 / 926 (0%) 5 5
QRY_MEM_GRANT_INFO_MUTEX 1.259996E-07 7 / 926 (1%) 0 0
PREEMPTIVE_OS_DIRSVC_NETWORKOPS 0.000142865 9 / 926 (1%) 47.89286 102
PREEMPTIVE_CLOSEBACKUPMEDIA 3.884375E-09 2 / 926 (0%) 5 5
HADR_NOTIFICATION_WORKER_TERMINATION_SYNC 4.925797E-05 5 / 926 (1%) 58.71429 257
PREEMPTIVE_HADR_LEASE_MECHANISM 6.851698 11 / 926 (1%) 6.03284E+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 / 926 (0%) 1.5 3
UTIL_PAGE_ALLOC 0.0001827734 1 / 926 (0%) 6003 6003
SLEEP_TEMPDBSTARTUP 0.1625368 2 / 926 (0%) 149 254
WORKTBL_DROP 0.0002046777 1 / 926 (0%) 5014 5014
PREEMPTIVE_OS_GETCOMPRESSEDFILESIZE 0.0003144243 2 / 926 (0%) 0 0
PREEMPTIVE_OS_NETLOCALGROUPGETMEMBERS 4.302328E-09 1 / 926 (0%) 3 3
COUNTRECOVERYMGR 3.12205E-08 2 / 926 (0%) 0 0
PWAIT_COOP_SCAN 4.58632E-07 1 / 926 (0%) 0 0
SQLTRACE_PENDING_BUFFER_WRITERS 9.799972E-06 6 / 926 (1%) 27.5 52
PREEMPTIVE_OLEDB_JOINTRANSACTION 0.002315261 15 / 926 (2%) 1.352941 4
SLEEP_MSDBSTARTUP 0.0005968752 2 / 926 (0%) 2422 4931
HADR_TRANSPORT_FLOW_CONTROL 0.0180622 2 / 926 (0%) 535 737
PREEMPTIVE_OS_NETGROUPGETUSERS 7.952433E-08 2 / 926 (0%) 2 2
PREEMPTIVE_OS_GETFINALFILEPATHBYHANDLE 0.0001887995 18 / 926 (2%) 0 0
FS_HEADER_RWLOCK 2.262863E-06 1 / 926 (0%) 7 7
PREEMPTIVE_FSRECOVER_UNCONDITIONALUNDO 1.645719E-05 1 / 926 (0%) 45 45
HADR_DBR_SUBSCRIBER_FILTER_LIST 5.972085E-08 4 / 926 (0%) 0 0
FFT_NSO_FCB 3.135668E-08 2 / 926 (0%) 8.5 11
TERMINATE_LISTENER 2.460273E-07 7 / 926 (1%) 66.3 361
BROKER_REGISTERALLENDPOINTS 5.785297E-05 1 / 926 (0%) 165 165
XE_BUFFERMGR_FREEBUF_EVENT 0.0006515112 3 / 926 (0%) 317.6667 541
CONNECTION_ENDPOINT_LOCK 5.237949E-08 1 / 926 (0%) 0 0
CXCONSUMER 19.06348 41 / 926 (4%) 44.88421 265
FT_COMPROWSET_RWLOCK 2.666754E-09 1 / 926 (0%) 0 0
TRAN_MARKLATCH_EX 7.564017E-07 1 / 926 (0%) 9 12
ROWGROUP_VERSION 1.352479E-08 3 / 926 (0%) 0 0
PREEMPTIVE_COM_LBREADAT 0.000308314 10 / 926 (1%) 0 0
PREEMPTIVE_COM_LBSTAT 0.0003135135 9 / 926 (1%) 0 0
PREEMPTIVE_COM_SETDATAFAILURE 6.703509E-07 5 / 926 (1%) 0 0
VIEW_DEFINITION_MUTEX 0.02207437 11 / 926 (1%) 0.07142857 1
XACTWORKSPACE_MUTEX 1.334237E-05 2 / 926 (0%) 2.666667 6
PARALLEL_REDO_TRAN_TURN 0.1758008 3 / 926 (0%) 0 0
HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING 0.001945173 1 / 926 (0%) 5005 5005
PARALLEL_REDO_TRAN_LIST 5.314284E-06 1 / 926 (0%) 0 0
HTREINIT 5.094804E-05 2 / 926 (0%) 1.857143 8
BROKER_ENDPOINT_STATE_MUTEX 6.725114E-08 1 / 926 (0%) 14 14
WINDOW_AGGREGATES_MULTIPASS 1.803614E-05 1 / 926 (0%) 3.4 4
QPJOB_WAITFOR_ABORT 0.0002509476 1 / 926 (0%) 1011 1011
LATCH_DT 0.0008821827 1 / 926 (0%) 5004 5004
PREEMPTIVE_COM_DELETEROWS 3.071292E-06 1 / 926 (0%) 22 22