List of common wait types
Published 21 October 2021
These pages provide detailed information about the most common wait types. They include an explanation of why the wait occurred and tips on how to start investigating, with links to expert articles, MSDN and TechNet resources.
- ASYNC_IO_COMPLETION
- ASYNC_NETWORK_IO
- BACKUPIO
- CXPACKET
- DBMIRROR_SEND
- HADR_SYNC_COMMIT
- HADR_SYNCHRONIZING_THROTTLE
- IO_COMPLETION
- LATCH_DT
- LATCH_EX
- LATCH_KP
- LATCH_NL
- LATCH_SH
- LATCH_UP
- LCK_M_IS
- LCK_M_IU
- LCK_M_IX
- LCK_M_RIn_NL
- LCK_M_RIn_S
- LCK_M_RIn_U
- LCK_M_RIn_X
- LCK_M_RS_S
- LCK_M_RS_U
- LCK_M_RX_S
- LCK_M_RX_U
- LCK_M_RX_X
- LCK_M_S
- LCK_M_SCH_M
- LCK_M_SCH_S
- LCK_M_SIU
- LCK_M_SIX
- LCK_M_U
- LCK_M_UIX
- LCK_M_X
- MSQL_DQ
- MSQL_XP
- OLEDB
- PAGEIOLATCH_DT
- PAGEIOLATCH_EX
- PAGEIOLATCH_KP
- PAGEIOLATCH_NL
- PAGEIOLATCH_SH
- PAGEIOLATCH_UP
- PAGELATCH_DT
- PAGELATCH_EX
- PAGELATCH_KP
- PAGELATCH_NL
- PAGELATCH_SH
- PAGELATCH_UP
- RESOURCE_SEMAPHORE
- RESOURCE_SEMAPHORE_QUERY_COMPILE
- SOS_SCHEDULER_YIELD
- THREADPOOL
- WRITELOG