SQL Server Concurrency: Locking, Blocking and Row Versioning (Kalen Delaney)

0.0 (0)
SQL Server Concurrency: Locking, Blocking and Row Versioning (Kalen Delaney)

Anyone who works with SQL Server, whether as a programmer, an administrator or even a user and wants to understand how the database engine handles multiple sessions and what causes excessive stalling, should read this book. It is also for SQL Server experts who need to understand how to diagnose and resolve issues with blocking and deadlocking.

Your queries may "fly" when evaluated separately if your SQL code was written intelligently and an effective indexing strategy was put in place. However, in the real world, when numerous processes can access the same data concurrently, SQL Server frequently needs to make one process wait, sacrificing concurrency and efficiency, in order that all can succeed, without compromising the integrity of the data. Concurrency is built on transactions. I describe these objects' ACID features, the levels of transaction isolation that specify the permitted actions when several transactions access the same data concurrently, and the optimistic and pessimistic concurrent access models used in SQL Server. Locks are used in pessimistic concurrency, which is SQL Server's default, to prevent concurrent issues. I describe every kind of lock and how it works with others. I demonstrate how to prevent excessive blocking and deadlocking, as well as how to control locking using hints and bound connections. Row versions are used to allow optimistic concurrency. I describe how row versioning functions, go over the two snapshot-based isolation levels available in SQL Server, and provide troubleshooting advice for problems like update conflicts. Even if your application has top-notch indexes and queries, they won't help you if another application has locked your data, making it impossible for you to access it. Because of this, each DBA and developer needs to be familiar with SQL Server concurrency and how to debug any problems. I hope my book is useful.

Ebook Details

About the Authors
Since 1987, when Kalen Delaney joined the Berkeley, California-based Sybase Corporation, she has worked with SQL Server. Since 1992, Kalen has worked as an independent worldwide trainer and consultant. She has worked as a consultant to create courses and deliver internal training for the technical support personnel of Microsoft Corporation and Sybase Corporation. 
Published Date / Year
(September 11, 2012)
200 psges
eBook Format
PDF and ePub

Similar Programming & Computer Books

The Official New Features Guide to Sybase ASE (Brian Taylor, et al)
Sybase Adaptive Server Enterprise is a mission-critical, high-performance database management system created to satisfy the growing demands of huge databases and high transaction volumes while offering a cost-efficient database...
Sybase IQ (Rocket99)
The Adaptive Server product family, which also includes Adaptive Server Enterprise and SQL Anywhere, incorporates Sybase IQ. Direct access to relational and nonrelational databases on mainframe, UNIX, or Windows...
Sybase SQL Server Administration's Guide
In addition to providing thorough explanations of how to install, configure, and maintain SQL Server 10 and SQL Server 11, this book also addresses system changes that may affect...
Sams Teach Yourself C# in 24 Hours (James Foxall, Wet al.)
Sams Teach Yourself C# in 24 Hours offers students 24 modules that are well-structured and give a quick yet complete introduction to C#. ...
Standard ECMA-334 C# Language Specification, 4th Edition (ECMA International)
The C# programming language specifies the form and establishes the interpretation of programs according to this International Standard.  
The C# Station Tutorial (Joe Mayo)
A versatile computer programming language that may be used for a wide range of development needs is called C# (pronounced "See Sharp"). ...
Beginners Guide to C# and the .NET Micro Framework (Gus Issa)
Using the goal of preparing you for data-driven development, this open-source book provides a step-by-step method for learning object-oriented programming with C# and the.NET Framework. Included are more than...
Programming XML with C# (Mahesh Chand)
This free programming book is created in the style of a step-by-step tutorial and is intended for students and beginners who want to learn XML programming in the C#...
Programming C# for Beginners (Mahesh Chand)
Beginners and students who want to learn C# programming should read this free programming book. The C# language, including versions 1.0, 2.0, and 3.0, is covered in this pdf...
.NET Book Zero: C#/.NET for C/C++ Developers (Charles Petzold)
For programmers with C or C++ knowledge, this free online, 267-page book serves as an introduction to C# and the Microsoft.NET Framework. ...

Others Programming Books by Red Gate Books

45 Database Performance Tips for Developers (Phil Factor, et al)
This eBook is a compilation of advice on SQL Server performance from some of the most knowledgeable individuals in the Simple Talk community, including SQL Server MVPs. ...
Fundamentals of SQL Server Replication (Sebastian Meine)
Making data from one server accessible on another is a typical requirement. You could want to offer a local copy of the data to speed up cross-server searches. ...
SQL Server Execution Plans, 3rd Edition (Grant Fritchey)
The query's execution plan will inform you not just what data set is returning, but also what SQL Server did and in what sequence to obtain that data if...
Performance Tuning with SQL Server Dynamic Management Views (Louis Davidson, et al)
Dynamic Management Views (DMVs), which reveal previously hidden information on the background activities of your database sessions and transactions, are a substantial and valuable addition to the DBA's troubleshooting...
The Art of SQL Server FILESTREAM (Jacob Sebastian, et al)
Although storing massive object data in the database has many advantages, it also presents performance issues. On the other hand, storing large objects on the file system has significant...
SQL Server Backup and Restore (Shawn McGehee)
This book demonstrates how to create a solid, tried-and-true SQL Server backup and restore strategy. Learn how to recover your data with the least amount of downtime. Find out...
Inside the SQL Server Query Optimizer (Benjamin Nevarez)
Many people believe the SQL Server Query Optimizer to be a mysterious black box that instantly converts SQL queries into high-performance execution plans through an unknown mechanism. ...
Under the Hood of .NET Memory Management (Chris Farrell)
The analysis and optimization of.NET code performance is covered in this book in both theory and practice.
Practical Performance Profiling: Improving the Efficiency of .NET Code (Jean-Philippe Gouigoux)
This book gives readers the theoretical knowledge and practical skills they need to evaluate and enhance the performance of.NET code. It walks the reader through using a profiler and...
Exchange 2010 SP1 - A Practical Approach (Jaap Wesselius)
The most recent version of Microsoft's Messaging and Collaboration platform, Exchange Server 2010 Service Pack 1, contains several exciting new features.
SQL Server Hardware Choices Made Easy (Glenn Berry)
This book is intended to give you the core information and tools you need to choose the best configuration and installation options for the SQL Server hardware, operating system,...
SQL Server Statistics (Holger Schmeling)
A sampling representation of the data distribution in a table is a Distribution Statistics object. These statistics assist the SQL Server Database Engine's Query Optimizer in converting the 'logical'...
SQL Server Team-based Development (Phil Factor, et al.)
This book demonstrates how to successfully develop database applications in a team setting using a combination of in-house scripts, native SQL Server tools, and tools from the Red Gate...
The SysAdmin Handbook -The Best of Simple Talk SysAdmin (Jaap Wesselius, et al)
This book covers everything about the Microsoft trade Servers management intensive.
Defensive Database Programming with SQL Server (Alex Kuznetsov)
The intention of protecting Programming is to supply resilient code that responds gracefully to the surprising.
let Brad McGehee take you on a complete excursion of the sq. Server preservation Plan Wizard and clothier. find out how the renovation Plan equipment allows you to configure...
How do you rate your software program? Is it art, science, or magic? How a lot of attention should you pay to your competition? This quick guide will provide...
SQLServerCentral.com brings you an expansion of articles on all components of sq. Server from management to XML and the whole lot in among.

User reviews

There are no user reviews for this listing.
Rate this Book