SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance, 6th Edition

Book Description

Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pr龟岛酒店essure to provide more speed. This new editionhas been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expanded information on using extended events, automatic execution plan correction, and other advanced features now available in SQL Server. These modern features are covered while still providing the necessary fundamentals to better understand how statistics and indexes affect query performance.

The book gives you knowledge and tools to help you identify poorly performing queries and understand the possible causes of that poor per弗雷格特岛酒店formance. The book also provides mechanisms for resolving the issues identified, whether on-premises, in containers, or on cloud platform providers. You’ll learn about key fundamentals, such as statistics, data distribution, cardinality, and parameter sniffing. You’ll learn to analyze and design your indexes and your queries using best practices that ward off performance problems before they occur. You’ll also learn to use important modern features, such as Query Store to manage and control execution plans, the automated performance tuning feature set, and memory-optimized OLTP tables and procedures. You will be able to troubleshoot in a systematic w菲拉格慕ay. Query tuning doesn’t have to be difficult. This book helps you to make it much easier.

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 2022查询性能调优: 查询性能的故障排除和优化，第6版

对执行缓慢的查询进行故障排除，并使其运行更快。数据库管理员和SQL开发人员不断承受压力，以提供更高的速度。这个新版本是根据宝珀作者最近15年的学习、知识和积累的经验，从零开始重新设计和重写的。本书包括有关使用扩展事件，自动执行计划更正以及SQL Server中现在可用的其他高级功能的扩展信息。涵盖了这些现代功能，同时仍然提供了必要的基础知识，以更好地了解统计数据和索引如何影响查询性能。

这本书为您提供了知识和工具，以帮助您识别性能不佳的查询并了解导致性能不佳的可能原因。本书还提供了解决已识别问题的机制，无论是在本地，在容器中还是在云平台提供商上。您将了解关键基础知识，如统计数据、数据分布、基数和参数嗅探。您将学习使用最佳实践来分析和设计索引和查询，以在性能问题发生之前避免它们。您还将学习使用重要的现代功能，如查询存储来管理和控制执行计划、自动性能调优功能集和内存优化的OLTP表和过程。您将能够以系统的方式进行故障排除。查询调整不一定要困难。这本书帮助你让它变得更容易。

你将学到什么

• 使用Query Store理解并轻松更改查询性能
• 识别并消除瓶颈导致性能下降
• 本地查询、容器查询、云平台提供商查询
• 在T-SQL中实现最佳实践，以最大程度地降低性能风险
• 通过仔细的查询和索引设计，实现性能设计
• 了解内置自动调整如何帮助您的性能增强工作
• 更新SQL Server版本时的查询性能保护

这本书是给谁的

负责SQL Server环境中查询性能的开发人员和数据库管理员，以及负责编写或创建t-sql查询并需要洞察瓶颈 (包括如何识别、理解和消除瓶颈) 的任何人