sp_who, sp_lock, and sp_familylock report on locks held by users, and show processes that are blocked by other transactions.
