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