Pro SQL Server 2022 wait statistics a practical guide to analyzing performance in SQL Server and Azure SQL Database
Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You'll learn to identify precisely why your queries are running slowly. And you'll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the...
| Otros Autores: | , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
New York, NY :
Apress
[2023]
|
| Edición: | 3rd ed. 2023. |
| Colección: | ITpro collection
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009712939006719 |
Tabla de Contenidos:
- Part I: Foundations of Wait Statistics Analysis
- 1. Wait Statistics Internals
- 2. Querying SQL Server Wait Statistics
- 3. The Query Store
- 4. Building a Solid Baseline
- Part II: Wait Types
- 5. CPU-Related Wait Types
- 6. IO-Related Wait Types
- 7. Backup-Related Wait Types
- 8. Lock-Related Wait Types
- 9. Latch-Related Wait Types
- 10. High-Availability and Disaster-Recovery Wait Types
- 11: Preemptive Wait Types
- 12: Background and Miscellaneous Wait Types
- 13. In-Memory OLTP-Related Wait Types
- Appendix I. Example SQL Server Machine Configurations
- Appendix II. Spinlocks
- Appendix III. Latch Classes
- Appendix IV. Waits and DMVs.
