Microsoft SQL Server 2012 Internals

Chapter 13. Transactions and concurrency

Kalen Delaney

Concurrency can be defined as the ability of multiple processes to access or change shared data at the same time. The greater the number of concurrent user processes that can be active without interfering with each other, the greater the concurrency of the database system.

Concurrency is reduced when a process that’s changing data prevents other processes from reading that data or when a process that’s reading data prevents other processes from changing that data. This chapter uses the terms reading and accessing to describe the impact of using a SELECT statement on your data. Concurrency is also affected when multiple processes attempt to change the same data simultaneously, but they can’t ...