Post reply

dead lock

  • January 18, 2011 at 9:34 pm

    #232330

    Hi,

    I have to provide the detailed information about dead lock which was happend sometime back .

    How should i get the detailed information .

    Thanks

  • January 18, 2011 at 10:37 pm

    #1275099

    If you have enabled trace flag 1204 or 1222 on your server, you should be able to get dead lock details from the error log. Otherwise, I don't think you will be able to get it after the event.

  • January 18, 2011 at 11:04 pm

    #1275103

    Don't use 1204 on a SQL 2005 or 2008 server. It doesn't produce as much info as 1222 and it's harder to read, it's an older traceflag for SQL 2000.

    You can also use Profiler and, on 2008, I believe there's an extended event. Nothing to get the info after the fact though.

    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

  • January 19, 2011 at 9:57 pm

    #1275663

    thanks Gail.....

Viewing 4 posts - 1 through 3 (of 3 total)

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