SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance

by Grant Fritchey

1. SQL Query Performance Tuning

2. Memory Performance Analysis

3. Disk Performance Analysis

4. CPU Performance Analysis

5. Creating a Baseline

6. Query Performance Metrics

7. Analyzing Query Performance

8. Index Architecture and Behavior

9. Index Analysis

10. Database Engine Tuning Advisor

11. Query Store

12. Key Lookups and Solutions

13. Statistics, Data Distribution, and Cardinality

14. Index Fragmentation

15. Execution Plan Generation

16. Execution Plan Cache Behavior

17. Parameter Sniffing

18. Query Recompilation

19. Query Design Analysis

20. Reduce Query Resource Use

21. Blocking and Blocked Processes

22. Causes and Solutions for Deadlocks

23. Row-By-Row Processing

24. Memory-Optimized OLTP Tables and Procedures

25. Automated Tuning in Azure SQL Database and SQL Server

26. Database Performance Testing

27. Database Workload Optimization

28. SQL Server Optimization Checklist

966 pages, Paperback

Published September 6, 2018

About the author

I have over thirty years experience working in technical support, development and database administration. I'm work for Redgate Software as a Product Advocate. I am a Microsoft Data Platform MVP and AWS Community Builder. I write articles for publication at SQL Server Central and Simple-Talk. I present sessions at events, large and small, all around the world and online. I work with both SQL Server and PostgreSQL and have authored multiple books on a variety of topics related to databases and data management.