SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance. 6 Ed

Ниже — практический обзор по теме «performance».

Database administrators and SQL developers are constantly under pressure to provide more speed. Troubleshoot slow-performing queries and make them run faster. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. These modern features are covered while still providing the necessary fundamentals to better understand how statistics and indexes affect query performance. The book Includes expanded information on using extended events, automatic execution plan correction, and other advanced features now available in SQL Server. The book gives you knowledge and tools to help you identify poorly performing queries and understand the possible causes of that poor performance. You’ll learn about key fundamentals, such as statistics, data distribution, cardinality, and parameter sniffing. The book also provides mechanisms for resolving the issues identified, whether on-premises, in containers, or on cloud platform providers. You’ll learn to analyze and design your indexes and your queries using best practices that ward off performance problems before they occur. You will be able to troubleshoot in a systematic way. 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. Query tuning doesn’t have to be difficult. This book helps you to make it much easier.

What You Will LearnUse Query Store to understand and easily change query performanceRecognize and eliminate bottlenecks leading to slow performanceTune queries whether on-premises, in containers, or on cloud platform providersImplement best practices in T-SQL to minimize performance riskDesign in the performance that you need through careful query and index designUnderstand how built-in, automatic tuning can assist your performance enhancement effortsProtect query performance during upgrades to the newer versions of SQL Server

Если материал оказался полезен — сохраните страницу.