Sql Server 2008 Wait Types

Front 1

"ASYNC_DISKPOOL_LOCK"

Back 1

"Occurs when there is an attempt to synchronize parallel threads that are performing tasks such as creating or initializing a file."

Front 2

"ASYNC_IO_COMPLETION"

Back 2

"Occurs when a task is waiting for I/Os to finish."

Front 3

"ASYNC_NETWORK_IO"

Back 3

"Occurs on network writes when the task is blocked behind the network. Verify that the client is processing data from the server."

Front 4

"BACKUP"

Back 4

"Occurs when a task is blocked as part of backup processing."

Front 5

"BACKUP_OPERATOR"

Back 5

"Occurs when a task is waiting for a tape mount. To view the tape status

Front 6

"BACKUPBUFFER"

Back 6

"Occurs when a backup task is waiting for data

Front 7

"BACKUPIO"

Back 7

"Occurs when a backup task is waiting for data

Front 8

"BACKUPTHREAD"

Back 8

"Occurs when a task is waiting for a backup task to finish. Wait times may be long

Front 9

"BAD_PAGE_PROCESS"

Back 9

"Occurs when the background suspect page logger is trying to avoid running more than every five seconds. Excessive suspect pages cause the logger to run frequently."

Front 10

"BROKER_CONNECTION_RECEIVE_TASK"

Back 10

"Occurs when waiting for access to receive a message on a connection endpoint. Receive access to the endpoint is serialized."

Front 11

"BROKER_ENDPOINT_STATE_MUTEX"

Back 11

"Occurs when there is contention to access the state of a Service Broker connection endpoint. Access to the state for changes is serialized."

Front 12

"BROKER_EVENTHANDLER"

Back 12

"Occurs when a task is waiting in the primary event handler of the Service Broker. This should occur very briefly."

Front 13

"BROKER_INIT"

Back 13

"Occurs when initializing Service Broker in each active database. This should occur infrequently."

Front 14

"BROKER_MASTERSTART"

Back 14

"Occurs when a task is waiting for the primary event handler of the Service Broker to start. This should occur very briefly."

Front 15

"BROKER_RECEIVE_WAITFOR"

Back 15

"Occurs when the RECEIVE WAITFOR is waiting. This is typical if no messages are ready to be received."

Front 16

"BROKER_REGISTERALLENDPOINTS"

Back 16

"Occurs during the initialization of a Service Broker connection endpoint. This should occur very briefly."

Front 17

"BROKER_SHUTDOWN"

Back 17

"Occurs when there is a planned shutdown of Service Broker. This should occur very briefly

Front 18

"BROKER_TRANSMITTER"

Back 18

"Occurs when the Service Broker transmitter is waiting for work."

Front 19

"BUILTIN_HASHKEY_MUTEX"

Back 19

"May occur after startup of instance

Front 20

"CHECKPOINT_QUEUE"

Back 20

"Occurs while the checkpoint task is waiting for the next checkpoint request."

Front 21

"CHKPT"

Back 21

"Occurs at server startup to tell the checkpoint thread that it can start."

Front 22

"CLR_AUTO_EVENT"

Back 22

"Occurs when a task is currently performing common language runtime (CLR) execution and is waiting for a particular autoevent to be initiated."

Front 23

"CLR_CRST"

Back 23

"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."

Front 24

"CLR_JOIN"

Back 24

"Occurs when a task is currently performing CLR execution and waiting for another task to end. This wait state occurs when there is a join between tasks."

Front 25

"CLR_MANUAL_EVENT"

Back 25

"Occurs when a task is currently performing CLR execution and is waiting for a specific manual event to be initiated."

Front 26

"CLR_MONITOR"

Back 26

"Occurs when a task is currently performing CLR execution and is waiting to obtain a lock on the monitor."

Front 27

"CLR_RWLOCK_READER"

Back 27

"Occurs when a task is currently performing CLR execution and is waiting for a reader lock."

Front 28

"CLR_RWLOCK_WRITER"

Back 28

"Occurs when a task is currently performing CLR execution and is waiting for a writer lock."

Front 29

"CLR_SEMAPHORE"

Back 29

"Occurs when a task is currently performing CLR execution and is waiting for a semaphore."

Front 30

"CLR_TASK_START"

Back 30

"Occurs while waiting for a CLR task to complete startup."

Front 31

"CMEMTHREAD"

Back 31

"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."

Front 32

"CXPACKET"

Back 32

"Occurs when trying to synchronize the query processor exchange iterator. You may consider lowering the degree of parallelism if contention on this wait type becomes a problem."

Front 33

"DBMIRROR_EVENTS_QUEUE"

Back 33

"Occurs when database mirroring waits for events to process."

Front 34

"DBMIRROR_SEND"

Back 34

"Occurs when a task is waiting for a communications backlog at the network layer to clear to be able to send messages. Indicates that the communications layer is starting to become overloaded and affect the database mirroring data throughput."

Front 35

"DBMIRROR_WORKER_QUEUE"

Back 35

"Indicates that the database mirroring worker task is waiting for more work."

Front 36

"DBMIRRORING_CMD"

Back 36

"Occurs when a task is waiting for log records to be flushed to disk. This wait state is expected to be held for long periods of time."

Front 37

"DEADLOCK_ENUM_MUTEX"

Back 37

"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."

Front 38

"DEADLOCK_TASK_SEARCH"

Back 38

"Large waiting time on this resource indicates that the server is executing queries on top of sys.dm_os_waiting_tasks

Front 39

"DEBUG"

Back 39

"Occurs during Transact-SQL and CLR debugging for internal synchronization."

Front 40

"DISABLE_VERSIONING"

Back 40

"Occurs when SQL Server polls the version transaction manager to see whether the timestamp of the earliest active transaction is later than the timestamp of when the state started changing. If this is this case

Front 41

"DISKIO_SUSPEND"

Back 41

"Occurs when a task is waiting to access a file when an external backup is active. This is reported for each waiting user process. A count larger than five per user process may indicate that the external backup is taking too much time to finish."

Front 42

"DLL_LOADING_MUTEX"

Back 42

"Occurs once while waiting for the XML parser DLL to load."

Front 43

"DROPTEMP"

Back 43

"Occurs between attempts to drop a temporary object if the previous attempt failed. The wait duration grows exponentially with each failed drop attempt."

Front 44

"DTC"

Back 44

"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.

Front 45

"DTC_ABORT_REQUEST"

Back 45

"Occurs in a MS DTC worker session when the session is waiting to take ownership of a MS DTC transaction. After MS DTC owns the transaction, the session can roll back the transaction. Generally, the session will wait for another session that is using the transaction.

Front 46

"DTC_RESOLVE"

Back 46

"Occurs when a recovery task is waiting for the master database in a cross-database transaction so that the task can query the outcome of the transaction."

Front 47

"DTC_STATE"

Back 47

"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."

Front 48

"DTC_TMDOWN_REQUEST"

Back 48

"Occurs in a MS DTC worker session when SQL Server receives notification that the MS DTC service is not available. First

Front 49

"DTC_WAITFOR_OUTCOME"

Back 49

"Occurs when recovery tasks wait for MS DTC to become active to enable the resolution of prepared transactions."

Front 50

"DUMP_LOG_COORDINATOR"

Back 50

"Occurs when a main task is waiting for a subtask to generate data. Ordinarily

Front 51

"EE_PMOLOCK"

Back 51

"Occurs during synchronization of certain types of memory allocations during statement execution."

Front 52

"EE_SPECPROC_MAP_INIT"

Back 52

"Occurs during synchronization of internal procedure hash table creation. This wait can only occur during the initial accessing of the hash table after the SQL Server 2005 instance starts."

Front 53

"ENABLE_VERSIONING"

Back 53

"Occurs when SQL Server waits for all update transactions in this database to finish before declaring the database ready to transition to snapshot isolation allowed state. This state is used when SQL Server enables snapshot isolation by using the ALTER DATABASE statement."

Front 54

"ERROR_REPORTING_MANAGER"

Back 54

"Occurs during synchronization of multiple concurrent error log initializations."

Front 55

"EXCHANGE"

Back 55

"Occurs during synchronization in the query processor exchange iterator during parallel queries."

Front 56

"EXECSYNC"

Back 56

"Occurs during parallel queries while synchronizing in query processor in areas not related to the exchange iterator. Examples of such areas are bitmaps

Front 57

"FCB_REPLICA_READ"

Back 57

"Occurs when the reads of a snapshot (or a temporary snapshot created by DBCC) sparse file are synchronized."

Front 58

"FCB_REPLICA_WRITE"

Back 58

"Occurs when the pushing or pulling of a page to a snapshot (or a temporary snapshot created by DBCC) sparse file is synchronized."

Front 59

"FT_RESTART_CRAWL"

Back 59

"Occurs when a full-text crawl needs to restart from a last known good point to recover from a transient failure. The wait lets the worker tasks currently working on that population to complete or exit the current step."

Front 60

"FULLTEXT GATHERER"

Back 60

"Occurs during synchronization of full-text operations."

Front 61

"HTTP_ENUMERATION"

Back 61

"Occurs at startup to enumerate the HTTP endpoints to start HTTP."

Front 62

"HTTP_START"

Back 62

"Occurs when a connection is waiting for HTTP to complete initialization."

Front 63

"IMPPROV_IOWAIT"

Back 63

"Occurs when SQL Server waits for a bulkload I/O to finish."

Front 64

"IO_AUDIT_MUTEX"

Back 64

"Occurs during synchronization of trace event buffers."

Front 65

"IO_COMPLETION"

Back 65

"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."

Front 66

"KSOURCE_WAKEUP"

Back 66

"Used by the service control task while waiting for requests from the Service Control Manager. Long waits are expected and do not indicate a problem."

Front 67

"LATCH_DT"

Back 67

"Occurs when waiting for a DT (destroy) 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

Front 68

"LATCH_EX"

Back 68

"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

Front 69

"LATCH_KP"

Back 69

"Occurs when waiting for a KP (keep) 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

Front 70

"LATCH_SH"

Back 70

"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

Front 71

"LATCH_UP"

Back 71

"Occurs when waiting for an UP (update) 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

Front 72

"LAZYWRITER_SLEEP"

Back 72

"Occurs when lazywriter tasks are suspended. This is a measure of the time spent by background tasks that are waiting. Do not consider this state when you are looking for user stalls."

Front 73

"LCK_M_BU"

Back 73

"Occurs when a task is waiting to acquire a Bulk Update (BU) lock. For a lock compatibility matrix

Front 74

"LCK_M_IS"

Back 74

"Occurs when a task is waiting to acquire an Intent Shared (IS) lock. For a lock compatibility matrix

Front 75

"LCK_M_IU"

Back 75

"Occurs when a task is waiting to acquire an Intent Update (IU) lock. For a lock compatibility matrix

Front 76

"LCK_M_IX"

Back 76

"Occurs when a task is waiting to acquire an Intent Exclusive (IX) lock. For a lock compatibility matrix

Front 77

"LCK_M_RIn_NL"

Back 77

"Occurs when a task is waiting to acquire a NULL lock on the current key value

Front 78

"LCK_M_RIn_S"

Back 78

"Occurs when a task is waiting to acquire a shared lock on the current key value

Front 79

"LCK_M_RIn_U"

Back 79

"Task is waiting to acquire an Update lock on the current key value

Front 80

"LCK_M_RIn_X"

Back 80

"Occurs when a task is waiting to acquire an Exclusive lock on the current key value

Front 81

"LCK_M_RS_S"

Back 81

"Occurs when a task is waiting to acquire a Shared lock on the current key value

Front 82

"LCK_M_RS_U"

Back 82

"Occurs when a task is waiting to acquire an Update lock on the current key value

Front 83

"LCK_M_RX_S"

Back 83

"Occurs when a task is waiting to acquire a Shared lock on the current key value

Front 84

"LCK_M_RX_U"

Back 84

"Occurs when a task is waiting to acquire an Update lock on the current key value

Front 85

"LCK_M_RX_X"

Back 85

"Occurs when a task is waiting to acquire an Exclusive lock on the current key value

Front 86

"LCK_M_S"

Back 86

"Occurs when a task is waiting to acquire a Shared lock. For a lock compatibility matrix

Front 87

"LCK_M_SCH_M"

Back 87

"Occurs when a task is waiting to acquire a Schema Modify lock. For a lock compatibility matrix

Front 88

"LCK_M_SCH_S"

Back 88

"Occurs when a task is waiting to acquire a Schema Share lock. For a lock compatibility matrix

Front 89

"LCK_M_SIU"

Back 89

"Occurs when a task is waiting to acquire a Shared With Intent Update lock. For a lock compatibility matrix

Front 90

"LCK_M_SIX"

Back 90

"Occurs when a task is waiting to acquire a Shared With Intent Exclusive lock. For a lock compatibility matrix

Front 91

"LCK_M_U"

Back 91

"Occurs when a task is waiting to acquire an Update lock. For a lock compatibility matrix

Front 92

"LCK_M_UIX"

Back 92

"Occurs when a task is waiting to acquire an Update With Intent Exclusive lock. For a lock compatibility matrix

Front 93

"LCK_M_X"

Back 93

"Occurs when a task is waiting to acquire an Exclusive lock. For a lock compatibility matrix

Front 94

"LOGBUFFER"

Back 94

"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."

Front 95

"LOGMGR"

Back 95

"Occurs when a task is waiting for any outstanding log I/Os to finish before shutting down the log while closing the database."

Front 96

"LOGMGR_QUEUE"

Back 96

"Occurs while the log writer task waits for work requests."

Front 97

"LOGMGR_RESERVE_APPEND"

Back 97

"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."

Front 98

"LOWFAIL_MEMMGR_QUEUE"

Back 98

"Occurs while waiting for memory to be available for use."

Front 99

"MSQL_DQ"

Back 99

"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."

Front 100

"MSQL_XACT_MGR_MUTEX"

Back 100

"Occurs when a task is waiting to obtain ownership of the session transaction manager to perform a session level transaction operation."

Front 101

"MSQL_XACT_MUTEX"

Back 101

"Occurs during synchronization of transaction usage. A request must acquire the mutex before it can use the transaction."

Front 102

"MSQL_XP"

Back 102

"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."

Front 103

"MSSEARCH"

Back 103

"Occurs during Full-Text Search calls. This wait ends when the full-text operation completes. It does not indicate contention

Front 104

"NET_WAITFOR_PACKET"

Back 104

"Occurs when a connection is waiting for a network packet during a network read."

Front 105

"OLEDB"

Back 105

"Occurs when SQL Server calls the Microsoft SQL Native Client OLE DB Provider. This wait type is not used for synchronization. Instead

Front 106

"ONDEMAND_TASK_QUEUE"

Back 106

"Occurs while a background task waits for high priority system task requests. Long wait times indicate that there have been no high priority requests to process

Front 107

"PAGEIOLATCH_DT"

Back 107

"Occurs when a task is waiting on a latch for a buffer that is in an I/O request. The latch request is in Destroy mode. Long waits may indicate problems with the disk subsystem."

Front 108

"PAGEIOLATCH_EX"

Back 108

"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."

Front 109

"PAGEIOLATCH_KP"

Back 109

"Occurs when a task is waiting on a latch for a buffer that is in an I/O request. The latch request is in Keep mode. Long waits may indicate problems with the disk subsystem."

Front 110

"PAGEIOLATCH_SH"

Back 110

"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."

Front 111

"PAGEIOLATCH_UP"

Back 111

"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."

Front 112

"PAGELATCH_DT"

Back 112

"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 Destroy mode."

Front 113

"PAGELATCH_EX"

Back 113

"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."

Front 114

"PAGELATCH_KP"

Back 114

"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 Keep mode."

Front 115

"PAGELATCH_SH"

Back 115

"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."

Front 116

"PAGELATCH_UP"

Back 116

"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."

Front 117

"PARALLEL_BACKUP_QUEUE"

Back 117

"Occurs when serializing output produced by RESTORE HEADERONLY

Front 118

"PRINT_ROLLBACK_PROGRESS"

Back 118

"Used to wait while user processes are ended in a database that has been transitioned by using the ALTER DATABASE termination clause. For more information

Front 119

"QPJOB_KILL"

Back 119

"Indicates that an asynchronous automatic statistics update was canceled by a call to KILL as the update was starting to run. The terminating thread is suspended

Front 120

"QPJOB_WAITFOR_ABORT"

Back 120

"Indicates that an asynchronous automatic statistics update was canceled by a call to KILL when it was running. The update has now completed but is suspended until the terminating thread message coordination is complete. This is an ordinary but rare state

Front 121

"QRY_MEM_GRANT_INFO_MUTEX"

Back 121

"Occurs when Query Execution memory management tries to control access to static grant information list. This state lists information about the current granted and waiting memory requests. This state is a simple access control state. There should never be a long wait on this state. If this mutex is not released

Front 122

"QUERY_EXECUTION_INDEX_SORT_EVENT_OPEN"

Back 122

"Occurs in certain cases when offline create index build is run in parallel

Front 123

"QUERY_NOTIFICATION_MGR_MUTEX"

Back 123

"Occurs during synchronization of the garbage collection queue in the Query Notification Manager."

Front 124

"QUERY_NOTIFICATION_SUBSCRIPTION_MUTEX"

Back 124

"Occurs during state synchronization for transactions in Query Notifications. "

Front 125

"QUERY_NOTIFICATION_TABLE_MGR_MUTEX"

Back 125

"Occurs during internal synchronization within the Query Notification Manager."

Front 126

"QUERY_OPTIMIZER_PRINT_MUTEX"

Back 126

"Occurs during synchronization of query optimizer diagnostic output production. This wait type only occurs if diagnostic settings have been enabled under direction of Microsoft Product Support."

Front 127

"RECOVER_CHANGEDB"

Back 127

"Occurs during synchronization of database status in warm standby database."

Front 128

"REPL_CACHE_ACCESS"

Back 128

"Occurs during synchronization on a replication article cache. During these waits

Front 129

"REPL_SCHEMA_ACCESS"

Back 129

"Occurs during synchronization of replication schema version information. This state exists when DDL statements are executed on the replicated object

Front 130

"REPLICA_WRITES"

Back 130

"Occurs while a task waits for completion of page writes to database snapshots or DBCC replicas."

Front 131

"REQUEST_DISPENSER_PAUSE"

Back 131

"Occurs when a task is waiting for all outstanding I/O to complete

Front 132

"REQUEST_FOR_DEADLOCK_SEARCH"

Back 132

"Occurs while the deadlock monitor waits to start the next deadlock search. This wait is expected between deadlock detections

Front 133

"RESOURCE_QUEUE"

Back 133

"Occurs during synchronization of various internal resource queues."

Front 134

"RESOURCE_SEMAPHORE"

Back 134

"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

Front 135

"RESOURCE_SEMAPHORE_MUTEX"

Back 135

"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."

Front 136

"RESOURCE_SEMAPHORE_QUERY_COMPILE"

Back 136

"Occurs when the number of concurrent query compilations reaches a throttling limit. High waits and wait times may indicate excessive compilations

Front 137

"RESOURCE_SEMAPHORE_SMALL_QUERY"

Back 137

"Occurs when memory request by a small query cannot be granted immediately due to other concurrent queries. Wait time should not exceed more than a few seconds

Front 138

"SEC_DROP_TEMP_KEY"

Back 138

"Occurs after a failed attempt to drop a temporary security key before a retry attempt."

Front 139

"SERVER_IDLE_CHECK"

Back 139

"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."

Front 140

"SHUTDOWN"

Back 140

"Occurs while a shutdown statement waits for active connections to exit."

Front 141

"SLEEP_BPOOL_FLUSH"

Back 141

"Occurs when a checkpoint is throttling the issuance of new I/Os in order to avoid flooding the disk subsystem."

Front 142

"SLEEP_DBSTARTUP"

Back 142

"Occurs during database startup while waiting for all databases to recover."

Front 143

"SLEEP_DCOMSTARTUP"

Back 143

"Occurs once at most during SQL Server instance startup while waiting for DCOM initialization to complete."

Front 144

"SLEEP_MSDBSTARTUP"

Back 144

"Occurs when SQL Trace waits for the msdb database to complete startup."

Front 145

"SLEEP_SYSTEMTASK"

Back 145

"Occurs during the start of a background task while waiting for tempdb to complete startup."

Front 146

"SLEEP_TASK"

Back 146

"Occurs when a task sleeps while waiting for a generic event to occur."

Front 147

"SLEEP_TEMPDBSTARTUP"

Back 147

"Occurs while a task waits for tempdb to complete startup."

Front 148

"SNI_CRITICAL_SECTION"

Back 148

"Occurs during internal synchronization within SQL Server networking components."

Front 149

"SNI_HTTP_WAITFOR_0_DISCON"

Back 149

"Occurs during SQL Server shutdown

Front 150

"SOAP_READ"

Back 150

"Occurs while waiting for an HTTP network read to complete."

Front 151

"SOAP_WRITE"

Back 151

"Occurs while waiting for an HTTP network write to complete."

Front 152

"SOS_CALLBACK_REMOVAL"

Back 152

"Occurs while performing synchronization on a callback list in order to remove a callback. It is not expected for this counter to change after server initialization is completed."

Front 153

"SOS_LOCALALLOCATORLIST"

Back 153

"Occurs during internal synchronization in the SQL Server memory manager."

Front 154

"SOS_OBJECT_STORE_DESTROY_MUTEX"

Back 154

"Occurs during internal synchronization in memory pools when destroying objects from the pool."

Front 155

"SOS_PROCESS_AFFINITY_MUTEX"

Back 155

"Occurs during synchronizing of access to process affinity settings."

Front 156

"SOS_RESERVEDMEMBLOCKLIST"

Back 156

"Occurs during internal synchronization in the SQL Server memory manager."

Front 157

"SOS_SCHEDULER_YIELD"

Back 157

"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."

Front 158

"SOS_STACKSTORE_INIT_MUTEX"

Back 158

"Occurs during synchronization of internal store initialization."

Front 159

"SOS_SYNC_TASK_ENQUEUE_EVENT"

Back 159

"Occurs when a task is started in a synchronous manner. Most tasks in SQL Server are started in an asynchronous manner

Front 160

"SOS_VIRTUALMEMORY_LOW"

Back 160

"Occurs when a memory allocation waits for a resource manager to free up virtual memory."

Front 161

"SOSHOST_EVENT"

Back 161

"Occurs when a hosted component

Front 162

"SOSHOST_INTERNAL"

Back 162

"Occurs during synchronization of memory manager callbacks used by hosted components

Front 163

"SOSHOST_MUTEX"

Back 163

"Occurs when a hosted component

Front 164

"SOSHOST_RWLOCK"

Back 164

"Occurs when a hosted component

Front 165

"SOSHOST_SEMAPHORE"

Back 165

"Occurs when a hosted component

Front 166

"SOSHOST_SLEEP"

Back 166

"Occurs when a hosted task sleeps while waiting for a generic event to occur. Hosted tasks are used by hosted components such as CLR."

Front 167

"SOSHOST_TRACELOCK"

Back 167

"Occurs during synchronization of access to trace streams."

Front 168

"SOSHOST_WAITFORDONE"

Back 168

"Occurs when a hosted component

Front 169

"SQLCLR_APPDOMAIN"

Back 169

"Occurs while CLR waits for an application domain to complete startup."

Front 170

"SQLCLR_ASSEMBLY"

Back 170

"Occurs while waiting for access to the loaded assembly list in the appdomain."

Front 171

"SQLCLR_DEADLOCK_DETECTION"

Back 171

"Occurs while CLR waits for deadlock detection to complete."

Front 172

"SQLCLR_QUANTUM_PUNISHMENT"

Back 172

"Occurs when a CLR task is throttled because it has exceeded its execution quantum. This throttling is done in order to reduce the effect of this resource-intensive task on other tasks."

Front 173

"SQLSORT_NORMMUTEX"

Back 173

"Occurs during internal synchronization

Front 174

"SQLSORT_SORTMUTEX"

Back 174

"Occurs during internal synchronization

Front 175

"SQLTRACE_BUFFER_FLUSH"

Back 175

"Occurs when a task is waiting for a background task to flush trace buffers to disk every four seconds. "

Front 176

"SQLTRACE_LOCK"

Back 176

"Occurs during synchronization on trace buffers during a file trace."

Front 177

"SQLTRACE_SHUTDOWN"

Back 177

"Occurs while trace shutdown waits for outstanding trace events to complete."

Front 178

"SQLTRACE_WAIT_ENTRIES"

Back 178

"Occurs while a SQL Trace event queue waits for packets to arrive on the queue."

Front 179

"SRVPROC_SHUTDOWN"

Back 179

"Occurs while the shutdown process waits for internal resources to be released to shutdown cleanly."

Front 180

"TEMPOBJ"

Back 180

"Occurs when temporary object drops are synchronized. This wait is rare

Front 181

"THREADPOOL"

Back 181

"Occurs when a task is waiting for a worker to run on. This can indicate that the maximum worker setting is too low

Front 182

"TRACEWRITE"

Back 182

"Occurs when the SQL Trace rowset trace provider waits for either a free buffer or a buffer with events to process."

Front 183

"TRAN_MARKLATCH_DT"

Back 183

"Occurs when waiting for a destroy mode latch on a transaction mark latch. Transaction mark latches are used for synchronization of commits with marked transactions."

Front 184

"TRAN_MARKLATCH_EX"

Back 184

"Occurs when waiting for an exclusive mode latch on a marked transaction. Transaction mark latches are used for synchronization of commits with marked transactions."

Front 185

"TRAN_MARKLATCH_KP"

Back 185

"Occurs when waiting for a keep mode latch on a marked transaction. Transaction mark latches are used for synchronization of commits with marked transactions."

Front 186

"TRAN_MARKLATCH_SH"

Back 186

"Occurs when waiting for a shared mode latch on a marked transaction. Transaction mark latches are used for synchronization of commits with marked transactions."

Front 187

"TRAN_MARKLATCH_UP"

Back 187

"Occurs when waiting for an update mode latch on a marked transaction. Transaction mark latches are used for synchronization of commits with marked transactions."

Front 188

"TRANSACTION_MUTEX"

Back 188

"Occurs during synchronization of access to a transaction by multiple batches."

Front 189

"UTIL_PAGE_ALLOC"

Back 189

"Occurs when transaction log scans wait for memory to be available during memory pressure."

Front 190

"VIEW_DEFINITION_MUTEX"

Back 190

"Occurs during synchronization on access to cached view definitions."

Front 191

"WAIT_FOR_RESULTS"

Back 191

"Occurs when waiting for a query notification to be triggered."

Front 192

"WAITFOR"

Back 192

"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."

Front 193

"WAITSTAT_MUTEX"

Back 193

"Occurs during synchronization of access to the collection of statistics used to populate sys.dm_os_wait_stats."

Front 194

"WORKTBL_DROP"

Back 194

"Occurs while pausing before retrying

Front 195

"WRITELOG"

Back 195

"Occurs while waiting for a log flush to complete. Common operations that cause log flushes are checkpoints and transaction commits."

Front 196

"XACT_OWN_TRANSACTION"

Back 196

"Occurs while waiting to acquire ownership of a transaction."

Front 197

"XACT_RECLAIM_SESSION"

Back 197

"Occurs while waiting for the current owner of a session to release ownership of the session."

Front 198

"XACTLOCKINFO"

Back 198

"Occurs during synchronization of access to the list of locks for a transaction. In addition to the transaction itself

Front 199

"XACTWORKSPACE_MUTEX"

Back 199

"Occurs during synchronization of defections from a transaction