INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- Turn Off Ad Banners
- One-Click Access To Your
Favorite Forums
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
Member Feedback
"...I have learned more through this forum than I did on a two day course. Thanks to everyone for their help and other postings that I have found useful..."
Geography
Where in the world do Tek-Tips members come from?
|
Microsoft SQL Server: Programming FAQ
|
MTS -> DTC -> SQL Server
|
How MTS Transactions Affect SQL Server
Posted: 15 Nov 00
|
MTS Default SQL Server
Transaction SQL Server Enlisted In Transaction
Setting Isolation Level DTC Type
---------------------------------------------------------------------------------------------
Requires New Serializable Yes Explicit
Requires Serializable Yes Explicit
Supports (1) Serializable Yes Explicit
Supports (2) Read Committed No Autocommit
Does Not Support Read Committed No Autocommit
(1) If the object is involved in a transaction
(2) If the object is not involved in a transaction
Why did I put this together?
For components involved in transactions, MTS by default uses the serializable isolation level on SQL Server, which could cause a concurrency problems such as blocked processes and deadlocks. If not absolutely necessary to use the serializable isolation level, developers should set the SQL Server isolation level to read committed so that they can obtain higher concurrency (fewer blocked transactions, fewer deadlocks).
Thanks,
Tom
tdavis@sark.com |
Back to Microsoft SQL Server: Programming FAQ Index
Back to Microsoft SQL Server: Programming Forum
My FAQ Archive
 Email This FAQ To A Friend |
|
 |
|
