Post reply

Deadlocks report

  • April 19, 2012 at 2:20 pm

    #272955

    Hello,

    How can I find out how many and what kind deadlock I had within 12 days.

    Thank you

  • April 19, 2012 at 4:02 pm

    #1476338

    On SQL 2005, no, not unless you have trace flag 1222 or 1204 enabled or had a server-side trace running.

    If you're worried about deadlocks enable 1222 (only) globally and future deadlocks will be written to the SQL Error Log:

    DBCC TRACEON (1222, -1)

    If you want this running all the time you can add it to the SQL Server startup parameters, or setup a SQL Agent job to "start when the services start" to enable the trace flag.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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