User Id :    Password :      New Member   Forgot Password  
Topic: What are Isolation Levels in SQL 2005?
Anamika singh
23 Nov 2010 at 12:02 AM

What are Isolation Levels in SQL 2005?

Re: What are Isolation Levels in SQL 2005?
16 Dec 2010 at 04:21 AM
Isolation levels come into play when you need to isolate a resource for a transaction and protect that resource from other transactions. The protection is done by obtaining locks. What locks need to be set and how it has to be established for the transaction is determined by SQL Server referring to the Isolation Level that has been set. Lower Isolation Levels allow multiple users to access the resource simultaneously (concurrency) but they may introduce concurrency related problems such as dirty-reads and data inaccuracy. Higher Isolation Levels eliminate concurrency related problems and increase the data accuracy but they may introduce blocking.
Total Replies: 1
Featured Text Ad

Featured Ad