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

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.