List of common wait types
Published 14 February 2023
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
