Transactions are at the heart of concurrency. I explain their ACID properties, the transaction isolation levels that dictate acceptable behaviors when multiple transactions access the same data simultaneously, and SQL Server's optimistic and pessimistic models for mediating concurrent access.
Pessimistic concurrency, SQL Server's default, uses locks to avoid concurrency problems. I explain all the different locks and their compatibility. I show how to control locking with hints and bound connections, and how to troubleshoot excessive blocking and deadlocking.
Optimistic concurrency uses row versions to support concurrency. I explain how row versioning works, cover SQL Server's two snapshot-based isolation levels and offer troubleshooting tips for issues such as update conflicts.
Your application can have world-class indexes and queries, but they won't help you if you can't get your data because another application has it locked. That's why every DBA and developer must understand SQL Server concurrency, and how to troubleshoot any issues. I hope my book helps!
Table of contents
- Concurrency and Transactions
- Locking Basics
- Advanced Locking Concepts
- Controlling Locking
- Troubleshooting Pessimistic Concurrency
- Optimistic Concurrency
| Pages : | 181 |
| Size : | 9.6 MB |
| Downloads: | 234 |
| Created: | 2022-02-03 |
| License: | For personal or educational use |
| Author(s): | Kalen Delaney |
Others related eBooks about SQL Server Concurrency
Download free course PostgreSQL Shell Commands free PDF, pdf file on 8 pages by tutorialkart.com.
With this tutorial you will learn step by step how to install SQL Server 2008 and how to check the correct configuration of the server. Download free pdf training course in 32 page intended to beginners.
This PDF tutorial will teachs you how to use SQL Server Data Tools to develop and deploy an Analysis Services project with examples,it's a free training course under 169 pages by Microsoft.
Download free PostgreSQL tutorial course in PDF, training file in 29 chapters and 93 pages. Free unaffiliated ebook created from Stack OverFlow contributor.
Cosmos DB is a NoSQL database service included in Azure that is continuously adding new features and has quickly become one of the most innovative services found in Azure, targeting mission-critical applications at a global scale.