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 8. Resolving transaction issues

 

This chapter covers
  • Transactions, locks, blocks, and deadlocks
  • Sessions, connections, and requests
  • Methods to minimize contention and improve concurrency and performance

 

A query may run fast when it runs alone, taking advantage of all available resources without the impact of other running queries. But in the real world it needs to interact with other running queries, each requiring resources and coordination to reduce contention.

To enable queries to run concurrently, resources need to be shared, and data needs to be protected so it’s able to give consistent and correct values. Therefore, there’s often a trade-off between data consistency and concurrency. Many factors can affect both consistency ...

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