Targeting Wait Statistics with Extended Events and DMVs
About the Presentation
Wait statistics are a great tool for troubleshooting performance tuning problems in SQL Server. However, there are so many different wait types in SQL Server, it can be challenging to determine what to focus on and what can be ignored. Even after discovering that SQL Server is waiting for something, most DBAs don’t know where to look next. In this session, we’ll examine 5 of the most frequently seen SQL Server wait statistics and how to troubleshoot each of them. You’ll learn how to determine the root cause of a particular wait type, and how to avoid common mistakes made when troubleshooting with SQL Server wait statistics.
Session Level: 300
Presentations (Upcoming & Past)
- SQLSaturday #733 – Atlanta, GA – May 15, 2018
- SQLSaturday #724 – Madison, WI – April 7, 2018
- SQLSaturday #708 – Cleveland, OH – February 3, 2018
- PASS Summit – Seattle, WA – October 31 – November 3, 2017
Leave a ReplyWant to join the discussion?
Feel free to contribute!