Post reply

dead lock info

  • December 10, 2014 at 1:47 am

    #313657

    How to export the dead lock information to the user ?

  • December 10, 2014 at 1:48 am

    #1763701

    Why does the application user need information on deadlocks? What is an end user going to do with it?

    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

  • December 10, 2014 at 4:11 am

    #1763729

    It depends on how you're getting it. If you have a deadlock graph that you've captured through extended events, or somewhere else, right click on it as you would an execution plan and save it out to a file.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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