Anyone has a list of all the wait events and their associated categories

Question

question

adiso75 asked Dec 14, '14

Hi, I'm looking for a complete list of all the wait events and their associated categories including the new events for 2014. Thanks

performance wait_stats

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley ♦♦ commented · Dec 15, 2014 at 09:05 AM

Do you mean wait types? Or extended events (related to waits)?

0 ·

adiso75 commented · Dec 15, 2014 at 12:36 PM

Wait types

0 ·

Answer 1 · 2014-12-15T11:20:53Z

VishalhSingh answered Dec 15, '14

A list published [here][1] might be helpful to you. [1]: http://blogs.msdn.com/b/psssql/archive/2009/11/03/the-sql-server-wait-type-repository.aspx Though you need to go through Books on line for retrieving the list of added wait types in 2014 (I don't have that handy).

3

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ commented · Dec 17, 2014 at 11:55 AM

That's the best list I've seen even though it isn't maintained. Other than that, Bing or Google.

1 ·

adiso75 commented · Dec 15, 2014 at 12:36 PM

Thanks. The list is partial and doesn't include many events so I'm still looking for a completed list.

0 ·

adiso75 commented · Dec 17, 2014 at 12:11 PM

Thanks a lot

0 ·