SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
暫譯: SQL Server 2025 查詢效能調優：故障排除與優化查詢效能
Fritchey, Grant
相關主題
商品描述
A new era of SQL Server is here, and this latest edition of Grant Fritchey's best-selling dive into SQL Server query performance can ensure your queries keep up.
The fundamentals are still here: You'll learn how statistics and indexes impact performance, how to identify poorly performing queries, and how to discover effective solutions. But this new edition also includes advanced features unique to SQL Server 2025, such as AI integration for automatic tuning, insights on using extended events, automatic execution plan correction, and more. It's a must-have resource designed to empower you to troubleshoot slow-performing queries and make them run faster than ever.
The book is a treasure trove of instruction, insight, and advice. As you dive in, you'll encounter key fundamentals, from statistics and data distribution to cardinality and parameter sniffing, and learn to analyze and design your indexes and queries using best practices that prevent performance problems before they occur. You'll also explore advanced features like Query Store for managing and controlling execution plans, automated performance tuning, and memory-optimized OLTP tables and procedures--and learn how SQL Server 2025 makes it all more powerful and automatable than ever.
What You Will Learn
- Use Query Store to understand and easily change query performance
- Recognize and eliminate bottlenecks leading to slow performance
- Tune queries whether on-premises, in containers, or on cloud platform providers
- Implement best practices in T-SQL to minimize performance risk
- Design in the performance that you need through careful query and index design
- Understand how built-in, automatic tuning can assist your performance enhancement efforts
- Protect query performance during upgrades to the newer versions of SQL Server
Who This Book Is For
Developers and database administrators with responsibility for query performance in SQL Server environments, and anyone responsible for writing or creating T-SQL queries and in need of insight into bottlenecks--including how to identify them, understand them, and eliminate them
商品描述(中文翻譯)
一個全新的 SQL Server 時代已經來臨，Grant Fritchey 的這本暢銷書深入探討 SQL Server 查詢性能的最新版本可以確保您的查詢能夠跟上。
基本概念依然存在：您將學習統計和索引如何影響性能，如何識別性能不佳的查詢，以及如何發現有效的解決方案。但這個新版本還包括 SQL Server 2025 獨有的進階功能，例如自動調整的 AI 整合、使用擴展事件的見解、自動執行計劃修正等。這是一本必備資源，旨在幫助您排除慢查詢的故障，並使其運行得比以往更快。
這本書是教學、見解和建議的寶庫。當您深入閱讀時，您將遇到關鍵的基本概念，從統計和數據分佈到基數和參數嗅探，並學會使用最佳實踐來分析和設計您的索引和查詢，以防止性能問題的發生。您還將探索進階功能，如查詢存儲（Query Store）以管理和控制執行計劃、自動性能調整，以及內存優化的 OLTP 表和程序，並學習 SQL Server 2025 如何使這一切變得更強大和自動化。
您將學到什麼
- 使用查詢存儲（Query Store）來理解並輕鬆改變查詢性能
- 識別並消除導致性能緩慢的瓶頸
- 調整無論是在本地、容器中還是雲平台提供商上的查詢
- 在 T-SQL 中實施最佳實踐以最小化性能風險
- 通過仔細的查詢和索引設計來設計所需的性能
- 了解內建的自動調整如何協助您的性能提升工作
- 在升級到更新版本的 SQL Server 時保護查詢性能
本書適合誰
負責 SQL Server 環境中查詢性能的開發人員和資料庫管理員，以及任何負責撰寫或創建 T-SQL 查詢並需要了解瓶頸的人，包括如何識別、理解和消除它們。
作者簡介
Grant Fritchey is a Microsoft Data Platform MVP and AWS Community Builder. He has more than 30 years of experience in IT technical support, development, and database administration. He currently works as Product Advocate at Red Gate Software. Grant writes articles for publication at SQL Server Central and Simple-Talk. He has published books, including SQL Server Execution Plans and SQL Server 2022 Query Performance Tuning (Apress). He has written chapters for Beginning SQL Server 2012 Administration (Apress), SQL Server Team-based Development, SQL Server MVP Deep Dives Volume 2, Pro SQL Server 2012 Practices (Apress), Expert Performance Indexing in SQL Server (Apress), and Query Store for SQL Server 2019 (Apress). Grant presents live sessions, virtual sessions, and recorded content online and in-person, around the world.
作者簡介(中文翻譯)
Grant Fritchey 是微軟數據平台的 MVP 及 AWS 社群建設者。他在 IT 技術支援、開發和資料庫管理方面擁有超過 30 年的經驗。目前，他在 Red Gate Software 擔任產品倡導者。Grant 為 SQL Server Central 和 Simple-Talk 撰寫文章。他出版了多本書籍，包括《SQL Server Execution Plans》和《SQL Server 2022 Query Performance Tuning》（Apress）。他還為《Beginning SQL Server 2012 Administration》（Apress）、《SQL Server Team-based Development》、《SQL Server MVP Deep Dives Volume 2》、《Pro SQL Server 2012 Practices》（Apress）、《Expert Performance Indexing in SQL Server》（Apress）以及《Query Store for SQL Server 2019》（Apress）撰寫了章節。Grant 在全球各地進行現場會議、虛擬會議和錄製內容的演講。
