Chapter 14
Performance tune SQL Server
This chapter reviews the database concepts and objects most associated with tuning the performance of queries and coded objects within the Database Engine for SQL Server, Azure SQL Database, and Azure SQL Managed Instance. Much of this content also applies to dedicated SQL pools in Azure Synapse Analytics, though that product is not a focus of this book.
The first two sections of this chapter look at isolation levels and durability, including the ACID properties of a relational database management system (RDBMS). These correspond to settings ...
Get SQL Server 2022 Administration Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
