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: | 86 |
Created: | 2022-02-03 |
License: | For personal or educational use |
Author(s): | Kalen Delaney |
Others related eBooks about SQL Server Concurrency
PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural ..., download free PL/SQL tutorial in PDF (440 pages) created by Saurabh K. Gupta .
Download free SQL tutorial course in PDF, training file in 62 chapters and 166 pages. Free unaffiliated ebook created from Stack OverFlow contributor.
Download free MySQL tutorial course in PDF, training file in 70 chapters and 199 pages. Free unaffiliated ebook created from Stack OverFlow contributor.
PostgreSQL for Beginners book is intended for those who only start getting acquainted with..., download free PostgreSQL tutorial in PDF (142 pages) created by Pavel Luzanov .
This PDF tutorial will teachs you how to install and use SQL Server Management Studio from Home using VPN,it's a free training courses for beginners