Home Forums SQL Server 2012 SQL 2012 - General Deadlocks trace flag RE: Deadlocks trace flag

  • August 26, 2013 at 2:23 pm

    #1644963

    GilaMonster (8/26/2013)

    I used to run a server with that traceflag on 24/7. If you have so many deadlocks that the traceflag is causing noticable load, the traceflag is not the primary problem

    We've already discovered the deadlock problem and so far we had no more.

    The flag causes no extra load unless there are deadlocks? If so we'll leave it on so when another deadlock occurs the information will be available..

    Thanks,

    Pedro


    If you need to work better, try working less...