SQL Server Concurrency Control: Locking, Blocking and Row Versioning
Kalen Delaney
Prior to SQL Server 2005, SQL Server managed concurrency pessimistically, using
locking and blocking to prevent multiple users from updating the same data
simultaneously and to provide data consistency. In this seminar we will look at
the concurrency enhancements made in SQL Server 2005, based on a technology
called row-level versioning (RLV) to implement optimistic concurrency. We'll
compare concurrency management with RLV to concurrency management with locking
and blocking. RLV provides a new isolation level called Snapshot Isolation that
allows readers of data to not be blocked by writers. The seminar will compare
the new isolation level with the previous ones and provide guidelines as to how
to determine which isolation level is appropriate for your needs, and what
application changes might be necessary to achieve the level desired. We will
also look at the concurrency enhancements added to SQL Server 2008.
Goals
- Compare the differences between Pessimistic and Optimistic Concurrency
Control in SQL Server
- Understand how your application's transaction control affects concurrency
- Explore of SQL Server's locking and blocking behaviours
- Learn how to access SQL Server metadata to observe the locking, blocking and
row versioning
- Differentiate between the two snapshot based isolation levels: Read
Committed Snapshot and Full Snapshot
Prerequisites
A basic understanding of batches and transactions in SQL Server and some
experience writing TSQL-based applications.
Why should I attend?
It is not uncommon for the same data to be queried at the same time by different people. Each of those users having different intentions of the data. In these situations it is essential we do not block others for longer than necessary or even worse cause deadlocks. This seminar will show you how to access your data lightly and efficiently allowing concurrent access to your data. This seminar is taught by one of the world's most respected practitioners and is an opportunity not to be missed.
Course Length & Type
One day instructor led seminar.
Location
4th November 2008 Rothamsted Manor, Harpenden
Conveniently located only 4 miles from the M1 and close to Harpenden railway
station with good links to London. Rothamsted Manor is part of the larger
Rothamsted Research facility, but retains a secluded and tranquil feel ideal for
learning.
Events are held in The Great Drawing Room at the manor house itself. For full
directions see Rothamsted Manor's
How to Find Us guide.
The Great Drawing Room Rothamsted Manor & Conference Centre
Rothamsted Research
Harpenden
AL5 2JQ
Rothamsted Manor
web site.
Timetable
Registration
Register before 21st October 2008 and receive your early bird discount:
- £200 + VAT before 21st Oct
- £249 + VAT full rate
Discounts
Early bird discounts must be booked before 21 October 2008,
and full payment must be received by 28 October 2008 to qualify for the discount.
We offer a discount of 5% for 2 - 4 places and a 10% discount for 5 or more places booked.
Discount bands apply to the total number of places booked, they are not restricted to an individual attended or course, i.e. booking two people on one course or one person on two courses will both qualify the 5% discount for 2 places booked.
For full details please see our Event Terms & Conditions