List of common wait types
Published 08 July 2015
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