• Menu
  • Skip to right header navigation
  • Skip to main content
  • Skip to secondary navigation
  • Skip to primary sidebar

OnlineProgrammingBooks.com

Legally Free Computer Books

  • All Categories
  • All Books
  • All Categories
  • All Books
  • About Us
  • Privacy policy
  • Disclaimer
  • Subscribe
  • Contact
You are here: Home ▶ Databases ▶ SQL Server Concurrency

SQL Server Concurrency

December 13, 2012

SQL Server Concurrency

Free eBook: “SQL Server Concurrency: Locking, Blocking and Row Versioning” by Kalen Delaney. This book is for anyone using SQL Server as a programmer, an administrator, or even a user, who wants to understand how SQL Server manages multiple sessions, and what causes excessive blocking. It is also for those SQL Server professionals who need to know how to troubleshoot and solve blocking and deadlocking problems.

Book Description

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 in order that all can succeed, without destroying data integrity. Transactions are at the heart of concurrency. I explain their ACID properties, the transaction isolation levels that dictate the 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

Download Free PDF / Read Online

Author(s): Kalen Delaney
Publisher: Simple Talk Publishing
Format(s): PDF
File size: 3.99 MB
Number of pages: 191
Link: Download.

Similar Books:

  1. Best of SQL Server Central Vol 5
  2. Mastering SQL Server 2005 Profiler
  3. The Best of SQLServerCentral.com Vol. 7
  4. SQL Server Tacklebox: Essential Tools and Scripts for the day-to-day DBA
  5. Brad’s Sure Guide to SQL Server 2008
Previous Post: « SQL Server Execution Plans – Second Edition
Next Post: Free Backbone Tutorials eBook »

Primary Sidebar

Get Latest Updates

  • Facebook
  • Pinterest
  • RSS
  • Twitter
  • YouTube
  • About Us
  • Privacy policy
  • Disclaimer
  • Subscribe
  • Contact

Copyright © 2006–2023 OnlineProgrammingBooks.com