Description
SQL Server 2022 Query Performance Tuning (6th Ed., 6th ed.)
Troubleshoot and Optimize Query Performance
Author: Fritchey Grant
Language: EnglishSubject for SQL Server 2022 Query Performance Tuning:
Keywords
Performance Optimization; Query Store; Automated Tuning; Azure SQL Database; Extended Events; SQL Server Query Plans; SQL Server Execution Plans; SQL Server Query Execution Plans; SQL Server Performance Best Practices; Adaptive Execution Plans; Columnstore; Cardinality estimation; SQL Server Management Studio; SQL Server statistics; Deadlocks; Locking; AWS RDS SQL Server; Google Cloud Databases SQL Server
720 p. · 17.8x25.4 cm · Paperback
Description
/li>Contents
/li>Biography
/li>Comment
/li>
- Use Query Store to understand and easily change query performance
- Recognize and eliminate bottlenecks leading to slow performance
- Tune queries whether on-premises, in containers, or on cloud platform providers
- Implement best practices in T-SQL to minimize performance risk
- Design in the performance that you need through careful query and index design
- Understand how built-in, automatic tuning can assist your performance enhancement efforts
- Protect query performance during upgrades to the newer versions of SQL Server
1. Query Performance Tuning.- 2. Execution Plan Generation and the Query Optimizer.- 3. Methods for Capturing Query Performance Metrics.- 4. Analyzing Query Behavior Using Execution Plans.- 5. Statistics, Data Distribution and Cardinality.- 6. Using Query Store for Query Performance and Execution Plans.- 7. Execution Plan Cache Behavior.- 8. Query Recompilation.- 9. Index Architecture.- 10. Index Behaviors.- 11. Key Lookups and Solutions.- 12. Dealing with Index Fragmentation.- 13. Parameter Sensitive Queries: Causes and Solutions.- 14. Query Design Analysis.- 15. Reduce Query Resource Use.- 16. Blocking and Blocked Processes.- 17. Causes and Solutions for Deadlocks.- 18. Row-By-Row Processing from Cursors and Other Causes.- 19. Memory-Optimized OLTP Tables and Procedures.- 20. Graph Databases.- 21. Intelligent Query Processing.- 22. Automated Tuning in Azure and SQL Server.- 23. A Query Tuning Methodology.