List of common wait types
Published 08 March 2018
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
