April 10, 2002 at 1:10 am
I read a book the other day, and tells me the isolation level
for MTS/COM+ is set of serializable. We are running a large
app with com+ and have yet to experience any concurrency issue
that I would expect with this isolation level, especially
as some of the jobs are long running at times.
Can anyone confirm/deny this? and how can you check it?
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
April 10, 2002 at 4:32 am
See MS KB Article "INFO: COM+ and MTS Always Use SERIALIZABLE Transaction Isolation Level (Q215520)" http://support.microsoft.com/default.aspx?scid=kb;en-us;Q215520
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 10, 2002 at 7:30 pm
Excellent, much appreciated, ill have a good read.
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply