Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

about the deadlock Expand / Collapse
Author
Message
Posted Friday, October 9, 2009 12:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 23, 2009 9:50 PM
Points: 9, Visits: 22
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 ?
Post #800530
Posted Friday, October 9, 2009 12:53 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:48 PM
Points: 2,726, Visits: 1,110
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.


--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #800532
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse