BROKER_CONNECTION_RECEIVE_TASK BROKER_ENDPOINT_STATE_MUTEX BROKER_EVENTHANDLER BROKER_INIT BROKER_MASTERSTART BROKER_RECEIVE_WAITFOR BROKER_REGISTERALLENDPOINTS BROKER_SERVICE BROKER_SHUTDOWN BROKER_TASK_STOP BROKER_TO_FLUSH BROKER_TRANSMITTER
The IO_COMPLETION wait indicates that SQL Server is waiting on something related to IO to finish. In the event that you are seeing the IO_COMPLETION wait this generally indicates non-data page IO. Check the placement of your database files. How …
IO_ wait types: IO_COMPLETION
LCK_M_SCH_S LCK_M_SCH_M LCK_M_S 0x03 LCK_M_U 0x04 LCK_M_X 0x05 LCK_M_IS LCK_M_IU LCK_M_IX LCK_M_SIU LCK_M_SIX LCK_M_UIX LCK_M_BU LCK_M_RS_S LCK_M_RS_U LCK_M_RI_NL LCK_M_RI_S LCK_M_RI_U LCK_M_RI_X LCK_M_RX_S LCK_M_RX_U LCK_M_RX_X LCK_M_X
Introduced in SQL Server 2008. Preemptive Waits PREEMPTIVE_OS_GENERICOPS PREEMPTIVE_OS_AUTHENTICATIONOPS PREEMPTIVE_OS_ACCEPTSECURITYCONTEXT PREEMPTIVE_OS_ACQUIRECREDENTIALSHANDLE PREEMPTIVE_OS_COMPLETEAUTHTOKEN PREEMPTIVE_OS_DECRYPTMESSAGE PREEMPTIVE_OS_DELETESECURITYCONTEXT PREEMPTIVE_OS_ENCRYPTMESSAGE PREEMPTIVE_OS_FREECREDENTIALSHANDLE PREEMPTIVE_OS_INITIALIZESECURITYCONTEXT PREEMPTIVE_OS_LOGONUSER PREEMPTIVE_OS_QUERYSECURITYCONTEXTTOKEN PREEMPTIVE_OS_VERIFYSIGNATURE PREEMPTIVE_OS_AUTHORIZATIONOPS PREEMPTIVE_OS_AUTHZGETINFORMATIONFROMCONTEXT PREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSID PREEMPTIVE_OS_AUTHZINITIALIZERESOURCEMANAGER PREEMPTIVE_OS_LOOKUPACCOUNTSID PREEMPTIVE_OS_REVERTTOSELF PREEMPTIVE_OS_SETNAMEDSECURITYINFO PREEMPTIVE_OS_CLUSTEROPS PREEMPTIVE_CLUSAPI_CLUSTERRESOURCECONTROL PREEMPTIVE_OS_COMOPS PREEMPTIVE_COM_COCREATEINSTANCE PREEMPTIVE_COM_COGETCLASSOBJECT PREEMPTIVE_COM_CREATEACCESSOR PREEMPTIVE_COM_DELETEROWS PREEMPTIVE_COM_GETCOMMANDTEXT PREEMPTIVE_COM_GETDATA PREEMPTIVE_COM_GETNEXTROWS PREEMPTIVE_COM_GETRESULT PREEMPTIVE_COM_GETROWSBYBOOKMARK PREEMPTIVE_COM_LBFLUSH …
Usually caused by IO outside of the SQL Server in the underlying operating System. Suggestions: Increase memory on your SQL Server so that more of the database remains in memory and does not need to be paged in and out …
What is the BROKER_EVENTHANDLER Wait event? The BROKER_EVENTHANDLER wait doesn’t cause problems. This indicates the number of times the event handler has waited because there was nothing for the Service Broker to do. This number will continue to increase over time …
LATCH_EX Wait
ASYNC_NETWORK_IO Wait Usually caused by a client application not processing results from the SQL Server quickly enough, or the client application processing data row by row instead of using SQL Server to handle the complex filtering and joins. Possibly a network …
BACKUPTHREAD Wait