October 9, 2009 at 12:38 am
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 ?
October 9, 2009 at 12:53 am
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