000 01591nam a2200229Ia 4500
003 NULRC
005 20250520103029.0
008 250520s9999 xx 000 0 und d
020 _a9781098101923
040 _cNULRC
050 _aQA 76.9 .K67 2022
100 _aKorotkevich, Dmitri
_eauthor
245 0 _aSQL server advanced troubleshooting and performance tuning :
_bbest practices and techniques /
_cDmitri Korotkevich
260 _aSebastopol, California :
_bO'Reilly Media, Incorporated,
_cc2022
300 _axviii, 477 pages ;
_c23 cm.
365 _bUSD56
504 _aIncludes index.
505 _a1. 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.
520 _aThis 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.
650 _aDATABASE MANAGEMENT
942 _2lcc
_cBK
999 _c21823
_d21823