Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

T. LaRock, E. van de LaarPro SQL Server 2022 Wait Statisticshttps://doi.org/10.1007/978-1-4842-8771-2_4

4. Building a Solid Baseline

Thomas LaRock¹   and Enrico van de Laar²

(1)

East Longmeadow, MA, USA

(2)

Drachten, The Netherlands

 

In Chapter 2, “Querying SQL Server Wait Statistics,” we spent a great deal of time describing and using various methods of accessing wait statistics information. Most of those methods focused on using the information for detecting current performance problems. While it is possible to find the exact cause of a performance problem using these real-time methods, it requires a deep knowledge of the various wait types and – most important ...