Post reply

retried attempts on deadlocks

  • September 25, 2011 at 2:07 pm

    #390469

    Hello All,

    I have an application that runs the DMLs continuously on the DB. Since there is a good chance of deadlock I enabled the traceflag 1222 [DBCC TraceON (1222, 3605, -1)].

    I do see some deadlocks in the application with some retries and after 2 or 3 retries... it got successful and the deadlock got resolved.

    My question is, even if there are some retries and may got successfull after 2 or 3 retries, how can I catch those retries attempts, like on which tables were in the deadlocks and what's the T-SQL.

    Thanks

  • September 25, 2011 at 3:07 pm

    #1386244

    Traceflag 1222, which you already have. That's exactly what it does.

    You don't need 3605 as well. Just 1222.

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply