Home » Blog » Presentation Materials – Concurrency Control

Presentation Materials – Concurrency Control

2011-07-26 - Presentations

Abstract

This session will explain the different transaction isolation levels that SQL Server provides. You will see examples of different locking and blocking behaviors and you will gain insight into how the transaction isolation level affects query concurrency and performance.

Downloads

• Slides

Other Resources

• Microsoft® SQL Server® 2008 Internals (Pro - Developer)
• SQL Server 2005 Practical Troubleshooting: The Database Engine
• Conor vs. Isolation Level Upgrade on UPDATE/DELETE Cascading RI
• Transaction Phenomena – Part 4: Serializable vs. Snapshot

Categories: Presentations