SQL Server Performance

about deadlock of SQL2000

Discussion in 'General Developer Questions' started by tramp168, Oct 8, 2009.

  1. tramp168 New Member

    Who can be able to help me below tow question?Thanks in advance!
    1.the difference between sp_who and sp_who2?
    2.how to find the final process which caused the deadlock ?
  2. Adriaan New Member

    Use Enterprise Manager ...
    Go to Management > Current Activity. Here you have two views, "Locks / Process ID" and "Locks / Object".
    Just check the process IDs, and compare against the "Process Info" view.
    Have fun!

Share This Page