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 ...

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.

Start your free trial