Pro SQL Server 2019 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server (Paperback, 2)

Part I: Foundations of Wait Statistics Analysis

1. Wait Statistics Internals

2. Querying SQL Server Wait Statistics

3. The Query Store

4. Building a Solid Baseline

Part II: Wait Types

5. CPU-Related Wait Types

6. IO-Related Wait Types

7. Backup-Related Wait Types

8. Lock-Related Wait Types

9. Latch-Related Wait Types

10. High-Availability and Disaster-Recovery Wait Types

11: Preemptive Wait Types

12: Background and Miscellaneous Wait Types

13. In-Memory OLTP-Related Wait Types

14. Appendix I. Example SQL Server Machine Configurations

15. Appendix II. Spinlocks

16. Appendix III. Latch Classes