January 26, 2010 at 11:34 pm
Hi,
Isolation level of my database is "Read Committed Snapshot". A deadlock as occurred , but it is showing the isolation level as "Serializable". Please refer the attached deadlock log.More then that , the two tables are independent to each other. Wt really made this two tables as a deadlock victim? Why there is change in isolation level?
Regards,
Saravanan
January 27, 2010 at 12:22 am
Saravanan T (1/26/2010)
Hi,Isolation level of my database is "Read Committed Snapshot". A deadlock as occurred , but it is showing the isolation level as "Serializable". Please refer the attached deadlock log.More then that , the two tables are independent to each other. Wt really made this two tables as a deadlock victim? Why there is change in isolation level?
Check the your com+ isolation level ...
January 27, 2010 at 1:26 am
How to check it???? Can elaborate on it????
Regards,
Saravanan
January 27, 2010 at 2:38 am
Saravanan T (1/27/2010)
How to check it???? Can elaborate on it????
Are you using the ramco erp product ?
January 27, 2010 at 7:36 am
Connection settings can be changed, independent of your database default connection settings. It's possible for the app to come in using serializable. I'd check the code if you're sure the db is set appropriately.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 27, 2010 at 7:43 am
Running some Linq-to-SQL?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 27, 2010 at 9:08 pm
We are using two tier architecture. We are connecting SQL server from App server using COM+ applications. Any problem in this?
Regards,
Saravanan
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply