It’s finally ready!
For the last two years, I’ve been working on-and-off on a new community resource. It was postponed during 2015 while I mentored 50+ people, but this year I’ve had a bunch of time to work on it.
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
As of today, I have complete information for more than 225 common wait types (897 entries in the library) and 26 common latch classes (185 entries in the library), and I’m adding more information constantly.
If there’s one that I haven’t done yet, and you’re really interested in it, click the email link on the page to let me know. Also, if you’ve seen something be a bottleneck that I haven’t, let me know so I can update the relevant page too.
I’m doing this because there is so little information about waits and latches available online and I know that people are constantly searching for information about them. This is very much a labor of love for me as wait statistics are now my favorite area to teach.
Waiting until it’s complete isn’t feasible, so it’s open and available for use now!
Check it out at https://www.SQLskills.com/help/waits and https://www.SQLskills.com/help/latches, or jump to some examples PAGELATCH_EX, SOS_SCHEDULER_YIELD, WRITELOG, CXPACKET.
Enjoy!
22 thoughts on “Announcing the comprehensive SQL Server Wait Types and Latch Classes Library”
This is simply amazing, thanks for making the lives of DBA’s around the world easier!
Thank you Paul for doing this. It will be our one stop shop to understand wait types.
Thanks so much, Paul! This is amazing and very much appreciated.
Thanks Paul, this is a brilliant resource that will undoubtedly help me time and time again.
Thank you so much. I was really excited to hear this when you announced it in class, and it is going to be a well utilized tool.
Amazing work, thanks for this
Thank you so much for your efforts in compiling a vast topic and sharing it for public use, Paul. It really helps!
Thank you so much Paul for giving up your time to provide the level of documentation that Microsoft should have provided!
Great job – please do keep it up.
Thank you!
Amazing stuff. Thank you Paul for your effort!
Amazing, thanks a lot Paul.
Much appreciated! Certainly now SQL Server started to expose ‘wait events’ per session, there’s no excuse not to use them anymore.
Great work, big man, thanks very very much.
FANTASTIC STUFF!
Amazing work Paul, that was fabulous. thank you.
Wow, well done.
You are to be commended for compiling and sharing this for the benefit of everyone. Thank you.
Instant bookmark on this, great to have this as a resource for troubleshooting! Nice one, and thankyou, Paul.
This is an excellent resource. Thank you so much for sharing these insights! Great work!
WOWOWOWOWOWOW!!! Unreal Paul, can’t thank you enough for this!!!
Paul, thank you to you and your team for the efforts in putting together this wonderful resource.
Really a Wonderful guide for understanding wait stats and latches! Thanks Paul!