Home Forums SQL Server 2005 Administering Deadlocks on IIS Server RE: Deadlocks on IIS Server

  • September 16, 2012 at 8:37 pm

    #1538384

    htt (9/16/2012)

    Joy Smith San (9/16/2012)

    .. Does that mean SQL Server deadlocks are not logged in sql server errorlog always ?

    No. There is no deadlock in SQL logs at all. The deadlocks are shown in Application log on the separate IIS server.

    If you mean that IIS deadlocks won't ever be reported in the SQL Server logs, I have no reason to disagree. I just want to make sure that folks understand that SQL Server Deadlocks will be recorded in the SQL Server logs if you turn on the correct trace flags.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)