ISOLATION IN DEADLOCK

  • 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

  • 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 ...

  • How to check it???? Can elaborate on it????

    Regards,
    Saravanan

  • Saravanan T (1/27/2010)


    How to check it???? Can elaborate on it????

    Are you using the ramco erp product ?

  • 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

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 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