TY  - BOOK
AU  - Korotkevich, Dmitri
TI  - SQL server advanced troubleshooting and performance tuning: best practices and techniques 
SN  - 9781098101923
AV  - QA 76.9 .K67 2022 
PY  - 2022///
CY  - Sebastopol, California
PB  - O'Reilly Media, Incorporated
KW  - DATABASE MANAGEMENT
N1  - Includes index; 1. SQL Server Setup and Configuration -- 2. SQL Server Execution Model and Wait Statistics -- 3. Disk Subsystem Performance -- 4. Inefficient Queries -- 5. Data Storage and Query Tuning -- 6. CPU Load -- 7. Memory Issues -- 8. Locking, Blocking and Concurrency -- 9. tempdp Usage Performance -- 10. Latches -- 11. Transaction Log -- 12. Always On Availability Grounds --13. Others Notable Wait Types -- 14. Database Schema and Index Analysis -- 15. SQL Server in Virtualized Environments -- 16. SQL Server in the Cloud
N2  - This practical book provides a comprehensive overview of troubleshooting and performance tuning best practices for Microsoft SQL Server. Database engineers, including database developers and administrators, will learn how to identify performance issues, troubleshoot the system in a holistic fashion, and properly prioritize tuning efforts to attain the best system performance possible
ER  -