What is isolation level?
An isolation level determines the degree of isolation of data between concurrent transactions. The default SQL Server isolation level is Read Committed. A lower isolation level increases concurrency, but at the expense of data correctness. Conversely, a higher isolation level ensures that data is correct, but can affect concurrency negatively. The isolation level required by an application determines the locking behavior SQL Server uses.
Related Questions
- Does the isolation level specified for OC4J transactions automatically propagate to the underlying database transactions for CMP Entity Beans? Do you have to manage this yourself for BMP Entity beans?
- Why does isolation level 0 ("dirty read") require that a table have a unique index?
- How to check database ISOLATION Level?
