Table of Contents

1. Altmetric Badge
   Book Overview
2. Altmetric Badge
   Chapter 1 SQL Query Performance Tuning
3. Altmetric Badge
   Chapter 2 Memory Performance Analysis
4. Altmetric Badge
   Chapter 3 Disk Performance Analysis
5. Altmetric Badge
   Chapter 4 CPU Performance Analysis
6. Altmetric Badge
   Chapter 5 Creating a Baseline
7. Altmetric Badge
   Chapter 6 Query Performance Metrics
8. Altmetric Badge
   Chapter 7 Analyzing Query Performance
9. Altmetric Badge
   Chapter 8 Index Architecture and Behavior
10. Altmetric Badge
    Chapter 9 Index Analysis
11. Altmetric Badge
    Chapter 10 Database Engine Tuning Advisor
12. Altmetric Badge
    Chapter 11 Key Lookups and Solutions
13. Altmetric Badge
    Chapter 12 Statistics, Data Distribution, and Cardinality
14. Altmetric Badge
    Chapter 13 Index Fragmentation
15. Altmetric Badge
    Chapter 14 Execution Plan Generation
16. Altmetric Badge
    Chapter 15 Execution Plan Cache Behavior
17. Altmetric Badge
    Chapter 16 Parameter Sniffing
18. Altmetric Badge
    Chapter 17 Query Recompilation
19. Altmetric Badge
    Chapter 18 Query Design Analysis
20. Altmetric Badge
    Chapter 19 Reduce Query Resource Use
21. Altmetric Badge
    Chapter 20 Blocking and Blocked Processes
22. Altmetric Badge
    Chapter 21 Causes and Solutions for Deadlocks
23. Altmetric Badge
    Chapter 22 Row-by-Row Processing
24. Altmetric Badge
    Chapter 23 Memory-Optimized OLTP Tables and Procedures
25. Altmetric Badge
    Chapter 24 Database Performance Testing
26. Altmetric Badge
    Chapter 25 Database Workload Optimization
27. Altmetric Badge
    Chapter 26 SQL Server Optimization Checklist