SQL Server Concurrency



Download free course SQL Server Concurrency, pdf file on 181 pages by Kalen Delaney.
If you've designed your SQL code intelligently and implemented a sensible indexing strategy, there's a good chance your queries will "fly", when tested in isolation. In the real world, however, where multiple processes can access the same data at the same time, SQL Server often has to make one process wait, sacrificing concurrency and performance in order that all processes can succeed without destroying data integrity.

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
Pages181
Size9.6 MB
File typePDF
Downloads234
Created2022-02-03
LicenseFor personal or educational use
Author(s) Kalen Delaney
Cover of SQL Server Concurrency

Download

  • A Primer on SQL, 3rd Edition

    This book is an introduction to the basics of SQL. No prior experience with SQL is necessary, but some knowledge of working with computers in general is required. My purpose of writing this was to provide a gentle tutorial on the syntax of SQL, so that the reader is able to recognize the parts of qu...

  • MongoDB tutorial for professionals

    Download free MongoDB tutorial course in PDF, training file in 23 chapters and 73 pages. Free unaffiliated ebook created from Stack OverFlow contributor....

  • Microsoft SQL Server Notes for Professionals

    Download free course Microsoft SQL Server Notes for Professionals, pdf file on 285 pages by Stack Overflow Community....

  • Performance Tuning with SQL Server Dynamic Management Views

    Download free course Performance Tuning with SQL Server Dynamic Management Views, pdf file on 326 pages by Louis Davidson, Tim Ford....

  • Guide Microsoft Access 2010

    This document is a quick tutorial guide about Microsoft Access 2010 to learn how to store informations in an easily retrievable form....

  • PostgreSQL Administration

    Learn how to administrate PostgreSQL,a free course training material in PDF By Bruce Momjian....

  • Microsoft Access 2013 course

    Download free Microsoft Office Access 2013 file under 448 pages,step by step to learn Access and build your skills , course tutorial training on pdf by Joyce Cox and Joan Lambert....

  • Learning Microsoft SQL Server

    Download free course Learning Microsoft SQL Server, pdf file on 361 pages by Stack Overflow Community....

  • Oracle database tutorial

    Download free Oracle tutorial course in PDF, training file in 33 chapters and 104 pages. Free unaffiliated ebook created from Stack OverFlow contributor....

  • Quick Guide to SQL Server Management Studio

    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...