Chapter 9Performance tuning SQL Server
Understanding isolation levels and concurrency
Understanding delayed durability
Understanding automatic plan correction
In this chapter, we review the database concepts and objects most commonly associated with performance tuning the performance of objects within the Microsoft SQL Server database. We begin with a fundamental exploration of database isolation and its practical effects on queries. We then review the concepts of delayed durability and delayed durability transactions. Then, we explore execution plans, including ways to use them with the Query Store feature. We discuss ...
Get SQL Server 2017 Administration Inside Out, First Edition 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.
