• Run sp_lock @process_id to see what objects are blocked by the given process ID. then think why those objects might be blocked.