RU EN
Книги для разработчиков

SQL Server Query Performance Tuning, 6th Edition

SQL Server Query Performance Tuning, 6th Edition

Troubleshoot and Optimize Query Performance
Автор:
Год:
Страниц:
731
Просмотров:
788
SQL Server Query Performance Tuning, 6th Edition favorites 1
Описание

Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. 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. 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 performance. 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 way. 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

Похожее
Apps and Services with .NET 7
Автор: Mark J. Price
Год: 2022
Bestselling author Mark Price is back to guide you through the coolest and most common technologies a .NET developer should know: Blazor, .NET MAUI, gRPC, GraphQL, SQL Server, Cosmos DB, OData, SignalR, Azure Functions, and more!Key Features ...
Next Generation Databases: NoSQL, NewSQL, and Big Data
Автор: Guy Harrison
Год: 2015
This is a book for enterprise architects, database administrators, and developers who need to understand the latest developments in database technologies. It is the book to help you choose the correct database technology at a time when concepts such as...
Practical Entity Framework Core 6, Second Edition
Автор: Brian L. Gorman
Год: 2021
Take a developer journey that paves the way to enterprise-level database access from .NET and C# using the object-relational mapper (ORM) of choice. This second edition is revised to cover Entity Framework Core 5 and 6 (EF) and includes new...
PostgreSQL High Availability Cookbook, Second Edition
Автор: Shaun M. Thomas
Год: 2017
Master over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL. Databases are nothing without the data they store. In the event of a failure – catastrophic or otherwise – immediate recovery is...
Написать сообщение
Тип
Почта
Имя
*Сообщение