Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database
暫譯: Pro SQL Server 2022 等待統計：SQL Server 和 Azure SQL Database 性能分析實用指南
Larock, Thomas, Van De Laar, Enrico
- 出版商: Apress
- 出版日期: 2023-01-12
- 售價: $2,610
- 貴賓價: 9.5 折 $2,480
- 語言: 英文
- 頁數: 407
- 裝訂: Quality Paper - also called trade paper
- ISBN: 1484287703
- ISBN-13: 9781484287705
-
相關分類:
Microsoft Azure、MSSQL、SQL、機率統計學 Probability-and-statistics、資料庫
海外代購書籍(需單獨結帳)
商品描述
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、I/O、鎖定、鎖定競爭等多個方面。
書中包含清晰的範例，幫助您獲得實用知識，了解特定等待時間為何增加或減少，這些變化如何影響您的 SQL Server 性能，以及您可以採取哪些措施來改善性能。閱讀完本書後，您將不會想失去等待統計數據提供的寶貴資訊，這些資訊能幫助您確定應該將有限的調整時間花在哪裡，以最大化性能和對業務的價值。
您將學到的內容：
- 了解 SQL Server 引擎如何處理請求
- 識別正在運行的 SQL Server 實例中的資源瓶頸
- 在 DMVs 和查詢存儲中定位等待統計數據信息
- 分析次優性能的根本原因
- 診斷 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 經驗，曾擔任程式設計師、開發人員、分析師和資料庫管理員等職位。他是 Microsoft Certified Master in SQL Server，並自 2009 年以來獲得 Microsoft Data Platform MVP 的稱號。Thomas 在其職業生涯中大部分時間都在處理資料和資料庫，這使他在 2010 年被選為 Confio Software 的技術倡導者，該軟體現在被稱為 SolarWinds Database Performance Analyzer (DPA)。
目前，Thomas 擔任 SolarWinds 的 Head Geek，該公司專注於企業基礎設施監控軟體。這個角色使他能夠與各種客戶合作，幫助解決有關網路、應用程式和資料庫性能調優及虛擬化的問題。您可以通過他的部落格 (thomaslarock.com/blog) 聯繫他，並在 Twitter 上找到他 @SQLRockstar。
Enrico van de Laar 在各種格式和大小的資料處理方面擁有超過 15 年的經驗。他是 Dataheroes 的資料和高級分析顧問，幫助組織優化其資料平台環境，並協助他們在高級分析領域的第一步。他自 2014 年以來是 Data Platform MVP，並且經常在全球各地的各種資料相關活動中演講。他經常在他的部落格 (enricovandelaar.com) 上撰寫有關 Microsoft SQL Server 和 Azure Machine Learning 等技術的文章。您可以在 Twitter 上聯繫 Enrico @evdlaar。
