about the deadlock

  • Who can be able to help me below tow question?Thanks in advance!

    1.What does the LastBatch columns of SP_who2 mean?

    2.how to find the final process which caused the deadlock ?

  • tramp168.my265 (10/9/2009)


    Who can be able to help me below tow question?Thanks in advance!

    1.What does the LastBatch columns of SP_who2 mean?

    2.how to find the final process which caused the deadlock ?

    lastbatch is the last time that the command was run

    finding deadlocks is more than a single answer, you can use profiler and the deadlock events, you can set trace flags to enable the display in the sql log about deadlocks and there are other ways.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

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

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