Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2006
    Posts
    119

    Unanswered: Checking for deadlock over last period of time

    Hi,
    I know to check for live deadlocks

    select * from sys.sysprocesses where blocked>0

    However, that is only for deadlocks that are current. How do we check for deadlocks from the say the last 24 hours? Note: I want to be able to do this without having to configure on any trace etc - just get the information from a system table. Is that possible?

    Thanks.
    Last edited by Breako; 02-09-12 at 06:28.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •