Wait statistics are a great tool for troubleshooting performance 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 wait types in SQL Server 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 wait statistics. Speaker Bio:
David Maxwell has over 15 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has had experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. David has been a frequent presenter at SQL Saturday events around the Midwest since 2012, as well as a presenter for the DBA Fundamentals virtual chapter, the Performance virtual chapter, and 24 Hours of PASS. David participates in his local Columbus Ohio PASS chapter, where he serves on the board of directors as SQL Saturday coordinator.