Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database

Author:   Thomas LaRock ,  Enrico van de Laar
Publisher:   APress
Edition:   3rd ed.
ISBN:  

9781484287705


Pages:   402
Publication Date:   12 January 2023
Format:   Paperback
Availability:   Manufactured on demand   Availability explained
We will order this item for you from a manufactured on demand supplier.

Our Price $158.37 Quantity:  
Add to Cart

Share |

Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database


Add your own review!

Overview

Full Product Details

Author:   Thomas LaRock ,  Enrico van de Laar
Publisher:   APress
Imprint:   APress
Edition:   3rd ed.
Weight:   0.802kg
ISBN:  

9781484287705


ISBN 10:   1484287703
Pages:   402
Publication Date:   12 January 2023
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   Manufactured on demand   Availability explained
We will order this item for you from a manufactured on demand supplier.

Table of Contents

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

Reviews

Author Information

Thomas LaRock has over 20 years of IT experience holding roles such as programmer, developer, analyst, and database administrator. He is a Microsoft Certified Master in SQL Server and a Microsoft Data Platform MVP since 2009. Thomas has spent much of his career working with data and databases, which led to his selection as Technical Advocate for Confio Software in 2010 for the software now known as SolarWinds Database Performance Analyzer (DPA).  Currently, Thomas serves as Head Geek for SolarWinds, a company specializing in software for enterprise infrastructure monitoring. This role allows him to work with a variety of customers, helping to solve questions regarding network, application, and database performance tuning and virtualization. You can reach him through his blog (thomaslarock.com/blog) and find him on Twitter @SQLRockstar). 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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions
Latest Reading Guide

wl

Shopping Cart
Your cart is empty
Shopping cart
Mailing List