Pro SQL Server 2019 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server

van de Laar, Enrico

ISBN 10: 1484249151 / ISBN 13: 9781484249154

Verlag: Apress (edition 2nd ed.), 2019

Beschreibung

Ship within 24hrs. Satisfaction 100% guaranteed. APO/FPO addresses supported.

Bestandsnummer des Verkäufers 1484249151-11-1

Bibliografische Details

• Titel: Pro SQL Server 2019 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server
• Verlag: Apress (edition 2nd ed.)
• Veröffentlichungsdatum: 2019
• Sprache: Englisch
• ISBN-10: 1484249151
• ISBN-13: 9781484249154
• Bindung: Paperback
• Ausgabe: 2nd ed.
• Zustand: Good

Über diesen Titel

Inhaltsangabe

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

14. Appendix I. Example SQL Server Machine Configurations

15. Appendix II. Spinlocks

16. Appendix III. Latch Classes

Über die Autorin bzw. den Autor

Enrico van de Laar has been working with data in various formats and sizes for over 15 years. He is a data and advanced analytics consultant for Dataheroes where he helps organizations optimize their data platform environment and helps them with their first steps in the world of advanced analytics. He is a Data Platform MVP since 2014 and a frequent speaker on various data-related events throughout the world. He frequently blogs about technologies such as Microsoft SQL Server and Azure Machine Learning on his blog at enricovandelaar.com. You can contact Enrico on Twitter @evdlaar.