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 largest improvements first. This edition is updated to cover analysis of wait statistics current with SQL Server 2022. Whether you are new to wait statistics, or already familiar with them, this book provides a deeper understanding on how wait statistics are generated and what they mean for your SQL Server instance's performance.

The book goes beyond the most common wait types into the more complex and performance-threatening wait types. You'll learn about per-query wait statistics and session-based wait statistics, and the types of problems they can help you solve. The different wait types are categorized by their area of impact, including CPU, IO, Latching, Locking, and many more.

Clear examples are included to help you gain practical knowledge of why and how specific wait times increase or decrease, how they impact your SQL Server's performance, and what you can do to improve performance. After reading this book, you won't want to be without the valuable information that wait statistics provide regarding where you should be spending your limited tuning time to maximize performance and value to your business.

What You'll Learn

• Understand how the SQL Server engine processes requests
• Identify resource bottlenecks in a running SQL Server instance
• Locate wait statistics information inside DMVs and Query Store
• Analyze the root cause of sub-optimal performance
• Diagnose I/O contention and locking contention
• Benchmark SQL Server performance
• Improve database performance by lowering overall wait time

Who This Book Is For

Database administrators who want to identify and resolve performance bottlenecks, those who want to learn more about how the SQL Server engine accesses and uses resources inside SQL Server, and administrators concerned with achieving--and knowing they have achieved--optimal performance

使用這本實用指南來分析和排除 SQL Server 的性能問題，並使用等待統計數據來確定查詢運行緩慢的原因。您將學習如何測量每個瓶頸所消耗的時間，以便首先專注於實現最大改進。本版本已更新，以涵蓋與 SQL Server 2022 相關的等待統計分析。無論您是對等待統計數據新手還是已經熟悉，本書都將深入了解等待統計數據的生成方式以及對 SQL Server 實例性能的意義。

本書不僅涵蓋了最常見的等待類型，還涉及更複雜且對性能具有威脅的等待類型。您將了解有關每個查詢的等待統計數據和基於會話的等待統計數據，以及它們可以幫助您解決的問題類型。不同的等待類型按其影響範圍進行分類，包括 CPU、IO、鎖定等。

書中提供清晰的示例，幫助您獲得有關特定等待時間增加或減少的實用知識，以及它們對 SQL Server 性能的影響，以及您可以採取的改進措施。閱讀本書後，您將不會想錯過等待統計數據提供的寶貴信息，這些信息可以告訴您應該在哪裡花費有限的調整時間，以最大程度地提高性能和價值。

您將學到什麼：
- 了解 SQL Server 引擎如何處理請求
- 確定運行中的 SQL Server 實例中的資源瓶頸
- 在 DMV 和查詢存儲中查找等待統計信息
- 分析次優性能的根本原因
- 診斷 I/O 爭用和鎖定爭用
- 基準測試 SQL Server 性能
- 通過降低總等待時間來改善數據庫性能

本書適合對識別和解決性能瓶頸感興趣的數據庫管理員，以及希望了解 SQL Server 引擎如何訪問和使用 SQL Server 內部資源的人，以及關注實現最佳性能並確定已經實現最佳性能的管理員。

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.

Thomas LaRock擁有超過20年的IT經驗，曾擔任程式設計師、開發人員、分析師和資料庫管理員等職位。他是微軟SQL Server認證大師，並自2009年起擔任微軟數據平台MVP。Thomas在職業生涯中大部分時間都在處理數據和資料庫，這使他於2010年被選為Confio Software（現稱SolarWinds Database Performance Analyzer）的技術倡導者。

目前，Thomas擔任SolarWinds的Head Geek，該公司專注於企業基礎設施監控軟件。這個角色使他能夠與各種客戶合作，幫助解決有關網絡、應用程序和資料庫性能調優以及虛擬化的問題。您可以通過他的博客（thomaslarock.com/blog）與他聯繫，並在Twitter上找到他@SQLRockstar。

Enrico van de Laar在不同格式和大小的數據上工作已有15年之久。他是Dataheroes的數據和高級分析顧問，協助組織優化其數據平台環境，並引導他們進入高級分析領域的第一步。他自2014年起擔任數據平台MVP，並經常在世界各地的各種數據相關活動上發表演講。他經常在他的博客（enricovandelaar.com）上發表有關Microsoft SQL Server和Azure Machine Learning等技術的文章。您可以通過Twitter與Enrico聯繫@evdlaar。