Part 2. DMV discovery
In this part we’ll examine in detail various aspects of performance problems relating to indexes, queries, the operating system, the Common Language Runtime, transactions, space usage, and much more. The code snippets will give you a head start in identifying and solving your performance problems. You’ll investigate the concept of the self-healing database and use the provided code snippets to automate many maintenance aspects of your SQL Server. Implementing the code snippets and advice from this part of the book will provide you with a more optimally performing SQL Server.
Get SQL Server DMVs in Action 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.
