Every slow system has a resource bottleneck. Everybody wants to identify and resolve the performance issues related to those resources. SQL Server Waits and Queues can reveal your past, explain your present and predict your future. SQL Server Performance Tuning uses the Waits and Queues as a proven method to identify the best opportunities to improve performance. In this webcast, we will focus on the practical approach of SQL Wait Stats and learn how the resource of two of the major performance bottlenecks related to I/O and CPU.
You can view the slide deck here.
You can view the scripts here.
You can view the recording here.