O'Reilly logo

SQL Server DMVs in Action: Better Queries with Dynamic Management Views by Ian W. Stirk

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2. Common patterns

 

This chapter covers
  • Common patterns used repeatedly in code snippets
  • Calculating the differences between DMV snapshots
  • Reading cached plans

 

The core of this book will supply many ready-to-run code snippets that will give you useful information about the cause of your performance problems, show how to improve your SQL queries, and also give you a better understanding of your SQL Server.

Many of the code snippets in this book have approaches (patterns) that are used over and over again. Rather than explain the patterns repeatedly for each of the code snippets that use them, the purpose of this chapter is to explain these patterns once, in detail. Please feel free to refer back to this section if you’re unsure ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required