Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners

© Dmitri Korotkevitch 2018

Dmitri KorotkevitchExpert SQL Server Transactions and Lockinghttps://doi.org/10.1007/978-1-4842-3957-5_11

11. Designing Transaction Strategies

Dmitri Korotkevitch¹ 

(1)

Land O Lakes, Florida, USA

 

A properly implemented transaction strategy would benefit every system. This chapter will provide a set of generic guidelines on the subject and discuss how you can improve concurrency in a system.

Transaction Strategy Design Considerations

Consistent transaction and error-handling strategies always benefit the system. They help to reduce blocking and simplify troubleshooting when blocking does occur.

As we already discussed in Chapter 2, the choice between client- and server-side transaction management greatly depends on the data ...