Paul Randal has come out with his comprehensive wait and latch type library:
I present to the community a comprehensive library of all wait types and latch classes that have existed since SQL Server 2005 (yes, it includes 2016 waits and latches).
The idea is that over time, this website will have the following information about all wait types and latch classes:
-
What they mean
-
When they were added
-
How they map into Extended Events (complete for all entries already)
-
Troubleshooting information
-
Example call stacks of where they occur inside SQL Server
-
Email link for feedback and questions
It’s not complete yet, but entries are thorough.