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 4. Improving poor query performance

 

This chapter covers
  • Query execution
  • Identifying different aspects of poorly performing queries
  • How to improve poorly performing queries

 

Slow-performing queries can have a costly impact on systems. When queries run slowly, transactions and locks are held longer, leading to an increased possibility of blocking, which can cause other queries in turn to run more slowly. All of this can lead to more client application timeouts.

Identifying the slowest queries will allow you to make targeted improvements, confident in the knowledge that any improvement to these queries will have the biggest overall impact on performance.

As well as looking at slow-running queries, we’ll look at other aspects of ...

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