SQL Server Concurrency
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 |
| File type : | |
| Downloads: | 107 |
| Created: | 2022-02-03 |
| License: | For personal or educational use |
| Author(s): | Kalen Delaney |
Warning: Trying to access array offset on false in /home/tutovnfz/public_html/article.php on line 233
Others sql Tutorials
Oracle Advanced PL/SQL Developer Professional Guide
PostgreSQL Notes for Professionals
Others related eBooks about SQL Server Concurrency
Guide to NoSQL with Azure Cosmos DB: Create Scalable and Globally Distributed Web ApplicationsCosmos 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. ...
Essential SQLThis book written to provide clear and concise explanation of topics for programmers both starting to learn the Structured Query Language (SQL) as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it....
Oracle database tutorials for professionalsDownload free Oracle tutorial course in PDF, training file in 45 chapters and 118 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
SQL Server Backup and RestoreDownload free course SQL Server Backup and Restore, pdf file on 381 pages by Shawn McGehee....
PostgreSQL for BeginnersDownload free course PostgreSQL for Beginners, pdf file on 142 pages by Pavel Luzanov, Egor Rogov, Igor Levshin....
SQL in 21 daysThis tutorial is for people who want to learn the fundamentals of Structured Query Language (SQL) , a complete training courses under 412 pages for download ....
Introducing Microsoft SQL Server 2016Download free course Introducing Microsoft SQL Server 2016, pdf file on 215 pages by Stacia Varga, Denny Cherry, Joseph D'Antoni....
Tutorial Oracle Database 11g: SQL Fundamentals in PDFDownload tutorial in PDF about Oracle Database 11g: SQL Fundamentals, free training document for beginners....
SQL Server Internals: In-Memory OLTPDownload free course SQL Server Internals: In-Memory OLTP, pdf file on 201 pages by Kalen Delaney....
Oracle database tutorialDownload free Oracle tutorial course in PDF, training file in 33 chapters and 104 pages. Free unaffiliated ebook created from Stack OverFlow contributor....