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