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