Pro SQL Server 2019 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server

© Enrico van de Laar 2019

Enrico van de LaarPro SQL Server 2019 Wait Statisticshttps://doi.org/10.1007/978-1-4842-4916-1_4

4. Building a Solid Baseline

Enrico van de Laar¹ 

(1)

Drachten, The Netherlands

 

In Chapter 2, “Querying SQL Server Wait Statistics,” we spent a great deal of time describing and using the various methods of accessing wait statistics information. Most of those methods focused on using that information for detecting performance problems that are presently occurring. While it is possible to find the exact cause of the performance problem using these real-time methods , it requires a deep knowledge of the various wait types and—most important—experience in the performance of your SQL Server. If you are managing only one SQL Server ...