Post reply

Profiler won't show graphs for deadlocks

  • March 30, 2011 at 7:29 am

    #237730

    Hello,

    I have a production SQL 2005 database with occasional deadlocks. To keep prod impact minimal, I am running Profiler on a separate server that has the 2005 tools, with SP3 installed. The db server is SQL 2005 Standard with SP3. I have the 1204 and 1222 trace flags turned on.

    The deadlock info is in my traces and in the SQL log but I cannot get the formatted deadlock graph to appear in my traces. The Deadlock Graph event is turned on in Profiler.

    Does anyone have any tricks to make the deadlock graph show up? Would running Profiler on the actual db server help? Thanks!

  • March 30, 2011 at 1:43 pm

    #1305653

    I found the answer to my question. If you are filtering on DatabaseID (as in > 5 to not see system databases) then Profiler will not show the deadlock graph.

    That seems like a bug to me but it's true.

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

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