Export (0) Print
Expand All
2 out of 2 rated this helpful - Rate this topic

Configuring Transaction Isolation Levels

COM+ gives developers more control over their applications by allowing configurable transaction isolation levels. Versions of COM+ prior to COM+ 1.5 always used the highest level of isolation for transactions. While this level guarantees that data integrity is always preserved, it can lead to performance issues, such as time-outs, when many transactions need to be performed on a large database. With configurable isolation levels, experienced developers can increase concurrency to improve performance and scalability.

COM+ provides the following transaction isolation levels.

LevelDescription
SerializedData read by a current transaction cannot be changed by another transaction until the current transaction finishes. No new data can be inserted that would affect the current transaction. This is the safest isolation level and is the default.
Repeatable readData read by a current transaction cannot be changed by another transaction until the current transaction finishes. Any type of new data can be inserted during a transaction.
Read committedA transaction cannot read data that is being modified by another transaction that has not committed. This is the default isolation level in Microsoft SQL Server.
Read uncommittedA transaction can read any data, even if it is being modified by another transaction. This is the least safe isolation level but allows the highest concurrency.
AnyAny isolation level is supported. This setting is most commonly used by downstream components to avoid conflicts. This setting is useful because any downstream component must be configured with an isolation level that is equal to or less than the isolation level of its immediate upstream component. Therefore, a downstream component that has its isolation level configured as Any always uses the same isolation level that its immediate upstream component uses. If the root object in a transaction has its isolation level configured to Any, its isolation level becomes Serialized.

 

Note   If a downstream component is configured with a higher isolation level than an upstream component and attempts to enlist in a transaction, an error results and the transaction aborts.

Related topics

Setting the Transaction Isolation Level

 

 

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.