SQL Server Waits
1. LCK_M_U
2. OLEDB
3. CXCONSUMER
4. LCK_M_X
5. LCK_M_S
6. LCK_M_SCH_S
7. SP_SERVER_DIAGNOSTICS_SLEEP
8. PREEMPTIVE_XE_GETTARGETSTATE
9. PREEMPTIVE_OS_PIPEOPS
10. ASYNC_NETWORK_IO
11. CXPACKET
12. LCK_M_IS
13. MEMORY_ALLOCATION_EXT
14. CXSYNC_PORT
15. LCK_M_IX
16. LCK_M_SCH_M
17. PREEMPTIVE_OS_GETPROCADDRESS
18. PREEMPTIVE_OS_GETFINALFILEPATHBY
19. XE_LIVE_TARGET_TVF
20. RESOURCE_SEMAPHORE_QUERY_COMPILE
21. PAGELATCH_EX
22. RESOURCE_SEMAPHORE
23. LCK_M_IU
24. LATCH_EX
25. PAGEIOLATCH_SH
26. WRITELOG
27. PAGELATCH_SH
28. WRITE_COMPLETION
29. PAGELATCH_UP
30. PAGEIOLATCH_EX
31. FT_MASTER_MERGE
32. PREEMPTIVE_OS_WRITEFILEGATHER
33. LATCH_SH
34. SOS_SCHEDULER_YIELD
35. LCK_M_RS_U
36. XE_FILE_TARGET_TVF
37. LOGBUFFER
38. IO_COMPLETION
39. BUFFERPOOL_SCAN
40. PREEMPTIVE_OS_DEVICEOPS
41. RESERVED_MEMORY_ALLOCATION_EXT
42. PAGEIOLATCH_UP
43. PREEMPTIVE_OS_AUTHZINITIALIZECON
44. LCK_M_BU
45. FCB_REPLICA_READ
46. EXECSYNC
47. HADR_SYNC_COMMIT
48. PREEMPTIVE_OS_CLOSEHANDLE
49. LCK_M_RS_S
50. LCK_M_SCH_M_LOW_PRIORITY
51. SQLTRACE_FILE_BUFFER
52. ASYNC_IO_COMPLETION
53. PREEMPTIVE_OS_LOOKUPACCOUNTSID
54. PREEMPTIVE_OS_QUERYREGISTRY
55. PREEMPTIVE_OS_FILEOPS
56. PREEMPTIVE_OS_AUTHORIZATIONOPS
57. LCK_M_RIn_NL
58. PREEMPTIVE_OS_DELETEFILE
59. PREEMPTIVE_OS_WAITFORSINGLEOBJEC
60. PREEMPTIVE_OS_CRYPTACQUIRECONTEX
61. PREEMPTIVE_OLEDBOPS
62. PREEMPTIVE_OS_CRYPTOPS
63. PREEMPTIVE_OS_CREATEFILE
64. PREEMPTIVE_SHAREDMEM_GETDATA
65. PREEMPTIVE_OS_MOVEFILE
66. PRINT_ROLLBACK_PROGRESS
67. TRACEWRITE
68. FCB_REPLICA_WRITE
69. CMEMTHREAD
70. HADR_CLUSAPI_CALL
71. FT_IFTS_RWLOCK
72. TRANSACTION_MUTEX
73. SLEEP_BPOOL_STEAL
74. XE_BUFFERMGR_ALLPROCESSED_EVENT
75. IMPPROV_IOWAIT
76. QDS_STMT
77. PREEMPTIVE_COM_GETDATA
78. PREEMPTIVE_OS_AUTHENTICATIONOPS
79. SOS_PHYS_PAGE_CACHE
80. PREEMPTIVE_OS_REPORTEVENT
81. LOGMGR_RESERVE_APPEND
82. PREEMPTIVE_OS_REVERTTOSELF
83. LATCH_UP
84. PREEMPTIVE_OS_SECURITYOPS
85. LOGMGR_FLUSH
86. PREEMPTIVE_FILE_MAPPING
87. SLEEP_BPOOL_FLUSH
88. PREEMPTIVE_CLUSAPI_CLUSTERRESOUR
89. PREEMPTIVE_OS_GENERICOPS
90. SLEEP_BUFFERPOOL_HELPLW
91. PREEMPTIVE_OS_FLUSHFILEBUFFERS
92. PREEMPTIVE_COM_QUERYINTERFACE
93. PREEMPTIVE_OS_LIBRARYOPS
94. PREEMPTIVE_OS_CRYPTIMPORTKEY
95. PREEMPTIVE_COM_SETPARAMETERINFO
96. DBMIRROR_DBM_EVENT
97. PREEMPTIVE_COM_SETPARAMETERPROPE
98. PREEMPTIVE_FILESIZEGET
99. CLR_CRST
100. PREEMPTIVE_COM_COCREATEINSTANCE
101. PREEMPTIVE_OS_AUTHZINITIALIZERES
102. PREEMPTIVE_COM_CREATEACCESSOR
103. PREEMPTIVE_OS_AUTHZGETINFORMATIO
104. SLEEP_MEMORYPOOL_ALLOCATEPAGES
105. PREEMPTIVE_OS_SETFILEVALIDDATA
106. PREEMPTIVE_XE_CALLBACKEXECUTE
107. PREEMPTIVE_OS_ENCRYPTMESSAGE
108. PREEMPTIVE_SERVICE_CONTROL_MANGE
109. PREEMPTIVE_OS_NETVALIDATEPASSWOR
110. REPL_SCHEMA_ACCESS
111. PREEMPTIVE_OS_WRITEFILE
112. HADR_AR_CRITICAL_SECTION_ENTRY
113. HADR_GROUP_COMMIT
114. DTC
115. PREEMPTIVE_OS_GETFILEATTRIBUTES
116. PREEMPTIVE_XE_SESSIONCOMMIT
117. PREEMPTIVE_COM_SEQSTRMREAD
118. PREEMPTIVE_OS_VERIFYTRUST
119. PREEMPTIVE_OS_GETCOMPRESSEDFILES
120. FT_IFTSHC_MUTEX
121. PREEMPTIVE_COM_RELEASE
122. PREEMPTIVE_XE_TARGETFINALIZE
123. PREEMPTIVE_OS_GETDISKFREESPACE
124. SQLTRACE_FILE_WRITE_IO_COMPLETIO
125. PREEMPTIVE_COM_RELEASEROWS
126. MSQL_XP
127. WAIT_ON_SYNC_STATISTICS_REFRESH
128. FT_IFTS_DOCID_INTERFACE_LIST
129. PREEMPTIVE_DTC_BEGINTRANSACTION
130. EE_PMOLOCK
131. PREEMPTIVE_OS_DEVICEIOCONTROL
132. REDO_THREAD_SYNC
133. ASYNC_DISKPOOL_LOCK
134. PREEMPTIVE_OS_BACKUPREAD
135. BACKUPTHREAD
136. DEADLOCK_TASK_SEARCH
137. LCK_M_S_ABORT_BLOCKERS
138. PREEMPTIVE_XE_TARGETINIT
139. RESOURCE_QUEUE
140. BROKER_MASTERSTART
141. LCK_M_SCH_M_ABORT_BLOCKERS
142. REPLICA_WRITES
143. HADR_TIMER_TASK
144. HADR_COMPRESSED_CACHE_SYNC
145. LATCH_NL
146. LCK_M_RX_U_LOW_PRIORITY
147. REQUEST_FOR_DEADLOCK_SEARCH
148. LCK_M_S_LOW_PRIORITY
149. LCK_M_IS_LOW_PRIORITY
150. HADR_BACKUP_QUEUE
151. HADR_TRANSPORT_FLOW_CONTROL
152. HADR_LOGCAPTURE_SYNC
153. HADR_FABRIC_CALLBACK
154. PREEMPTIVE_OS_LOADLIBRARY
155. HADR_LOGCAPTURE_WAIT
156. BROKER_ENDPOINT_STATE_MUTEX
157. LOGPOOL_FREEPOOLS
158. HADR_DATABASE_FLOW_CONTROL
159. LCK_M_RIn_X_LOW_PRIORITY
160. LCK_M_RIn_S
161. VERSIONING_COMMITTING
162. LCK_M_SIX_ABORT_BLOCKERS
163. DTC_STATE
164. PARALLEL_REDO_WORKER_WAIT_WORK
165. LCK_M_U_LOW_PRIORITY
166. WAITFOR
167. PREEMPTIVE_SERVICE_CONTROL_MANAGE
168. HADR_ARCONTROLLER_NOTIFICATIONS_SUBSCRIBER_LIST
169. CLR_RWLOCK_READER
170. BROKER_REGISTERALLENDPOINTS
171. HADR_FILESTREAM_IOMGR
172. MSQL_DQ
173. LCK_M_X_LOW_PRIORITY
174. LCK_M_SIU
175. LCK_M_IU_ABORT_BLOCKERS
176. SQLTRACE_INCREMENTAL_FLUSH_SLEEP
177. LCK_M_RX_S
178. DBMIRROR_DBM_MUTEX
179. LCK_M_RS_S_ABORT_BLOCKERS
180. LCK_M_SIX_LOW_PRIORITY
181. LCK_M_RIn_S_LOW_PRIORITY
182. DTCPNTSYNC
183. BROKER_DISPATCHER
184. BROKER_EVENTHANDLER
185. CXSYNC_CONSUMER
186. HADR_LOGPROGRESS_SYNC
187. COMMIT_ACT
188. LCK_M_UIX
189. LCK_M_IS_ABORT_BLOCKERS
190. DAC_INIT
191. HADR_DBR_SUBSCRIBER
192. DIRTY_PAGE_POLL
193. PERFORMANCE_COUNTERS_RWLOCK
194. DISPATCHER_PRIORITY_QUEUE_SEMAPHORE
195. LAZYWRITER_SLEEP
196. HADR_NOTIFICATION_DEQUEUE
197. PAGEIOLATCH_DT
198. LCK_M_RS_U_LOW_PRIORITY
199. LCK_M_IU_LOW_PRIORITY
200. DISABLE_VERSIONING
201. CLR_RWLOCK_WRITER
202. HADR_DBSTATECHANGE_SYNC
203. HADR_DBSEEDING
204. LCK_M_RIn_U_LOW_PRIORITY
205. XE_SERVICES_MUTEX
206. DTC_WAITFOR_OUTCOME
207. PWAIT_DIRECTLOGCONSUMER_GETNEXT
208. LCK_M_RIn_NL_ABORT_BLOCKERS
209. BROKER_TRANSMISSION_OBJECT
210. BACKUPIO
211. LCK_M_RS_S_LOW_PRIORITY
212. HADR_READ_ALL_NETWORKS
213. LCK_M_RIn_NL_LOW_PRIORITY
214. LATCH_DT
215. CLR_AUTO_EVENT
216. LCK_M_RX_X_ABORT_BLOCKERS
217. BACKUP_OPERATOR
218. HADR_FILESTREAM_BLOCK_FLUSH
219. EXCHANGE
220. PREEMPTIVE_OS_DTCOPS
221. HADR_PARTNER_SYNC
222. DBMIRROR_SEND
223. PAGELATCH_KP
224. LOGPOOL_REPLACEMENTSET
225. PAGEIOLATCH_NL
226. BROKER_TASK_SUBMIT
227. HADR_DBSEEDING_LIST
228. HADR_TDS_LISTENER_SYNC
229. HADR_FILESTREAM_FILE_CLOSE
230. LCK_M_RS_U_ABORT_BLOCKERS
231. MSSEARCH
232. PREEMPTIVE_HADR_LEASE_MECHANISM
233. HADR_DBR_SUBSCRIBER_FILTER_LIST
234. HADR_NOTIFICATION_WORKER_TERMINATION_SYNC
235. PAGELATCH_DT
236. HADR_NOTIFICATION_WORKER_EXCLUSIVE_ACCESS
237. HADR_TRANSPORT_SESSION
238. LOGMGR
239. LCK_M_RIn_X
240. LCK_M_RIn_S_ABORT_BLOCKERS
241. QDS_LOADDB
242. LCK_M_RX_X_LOW_PRIORITY
243. REDO_THREAD_PENDING_WORK
244. LCK_M_RX_U_ABORT_BLOCKERS
245. LCK_M_BU_ABORT_BLOCKERS
246. LCK_M_SIU_ABORT_BLOCKERS
247. HADR_WORK_POOL
248. DBSEEDING_OPERATION
249. XACTLOCKINFO
250. DBSEEDING_FLOWCONTROL
251. HADR_DB_COMMAND
252. DEADLOCK_ENUM_MUTEX
253. LATCH_KP
254. LCK_M_RX_S_ABORT_BLOCKERS
255. BROKER_CONNECTION_RECEIVE_TASK
256. PREEMPTIVE_OS_SQLCLROPS
257. LCK_M_RX_X
258. HADR_RECOVERY_WAIT_FOR_UNDO
259. BROKER_SHUTDOWN
260. HADR_SYNCHRONIZING_THROTTLE
261. ASYNC_OP_COMPLETION
262. SOS_WORK_DISPATCHER
263. LOGMGR_QUEUE
264. SQLTRACE_SHUTDOWN
265. RESOURCE_SEMAPHORE_MUTEX
266. HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING
267. XACT_OWN_TRANSACTION
268. LCK_M_SIX
269. LCK_M_U_ABORT_BLOCKERS
270. DTC_TMDOWN_REQUEST
271. BROKER_FORWARDER
272. HADR_DB_OP_COMPLETION_SYNC
273. HADR_NOTIFICATION_WORKER_STARTUP_SYNC
274. LCK_M_UIX_LOW_PRIORITY
275. MSSQL_XP
276. BACKUP
277. BROKER_TRANSMISSION_WORK
278. BROKER_INIT
279. LCK_M_SCH_S_LOW_PRIORITY
280. HADR_WORK_QUEUE
281. DTC_RESOLVE
282. BROKER_SERVICE
283. PREEMPTIVE_XE_DISPATCHER
284. HADR_FILESTREAM_FILE_REQUEST
285. BROKER_TRANSMISSION_TABLE
286. LCK_M_RX_S_LOW_PRIORITY
287. PREEMPTIVE_OS_SERVICEOPS
288. DTC_ABORT_REQUEST
289. HADR_REPLICAINFO_SYNC
290. LCK_M_IX_ABORT_BLOCKERS
291. BROKER_TRANSMITTER
292. LCK_M_SCH_S_ABORT_BLOCKERS
293. PREEMPTIVE_OS_CLUSTEROPS
294. HADR_TDS_LISTENER_SYNC_PROCESSING
295. LCK_M_UIX_ABORT_BLOCKERS
296. TEMPOBJ
297. SOSHOST_MUTEX
298. SQLTRACE_BUFFER_FLUSH
299. CLR_MONITOR
300. SQLTRACE_FILE_WRITE_IO_COMPLETION
301. LCK_M_BU_LOW_PRIORITY
302. SLEEP_TASK
303. LCK_M_RX_U
304. PAGEIOLATCH_KP
305. LCK_M_IX_LOW_PRIORITY
306. LCK_M_RIn_X_ABORT_BLOCKERS
307. HADR_XRF_STACK_ACCESS
308. DISKIO_SUSPEND
309. BROKER_RECEIVE_WAITFOR
310. SNI_CRITICAL_SECTION
311. HADR_RECOVERY_WAIT_FOR_CONNECTION
312. CLR_TASK_START
313. BROKER_TASK_SHUTDOWN
314. PREEMPTIVE_OLEDB_RELEASE
315. LCK_M_RIn_U_ABORT_BLOCKERS
316. HADR_DATABASE_WAIT_FOR_RESTART
317. DLL_LOADING_MUTEX
318. PAGELATCH_NL
319. SOS_SYNC_TASK_ENQUEUE_EVENT
320. HADR_AR_MANAGER_MUTEX
321. HADR_BACKUP_BULK_LOCK
322. HADR_DB_OP_START_SYNC
323. HADR_FILESTREAM_MANAGER
324. HADR_TRANSPORT_DBRLIST
325. DBMIRRORING_CMD
326. LCK_M_SIU_LOW_PRIORITY
327. HADR_CONNECTIVITY_INFO
328. HADR_AR_UNLOAD_COMPLETED
329. BROKER_TASK_STOP
330. LCK_M_X_ABORT_BLOCKERS
331. BACKUPBUFFER
332. PREEMPTIVE_OS_LOGONUSER
333. HADR_AG_MUTEX
334. SQLTRACE_FILE_READ_IO_COMPLETION
335. SQLTRACE_PENDING_BUFFER_WRITERS
336. DBMIRROR_WORKER_QUEUE
337. HADR_DATABASE_VERSIONING_STATE
338. LCK_M_RIn_U
339. THREADPOOL
340. COMMIT_TABLE