List of common wait types
Published 28 November 2013
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
- 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
