number of blockings and deadlocks in a specific time range

  • Hi,

    Is there any way to calculate the number of blockings and deadlocks in a specific time range (e.g. 8AM~9AM today)?

    Regards,

  • Sure. Set up Extended events with the relevant events. Blocked process report if you have it configured, or you could use the wait-related events if carefully filtered, and the deadlock_info event, then afterwards you can just count the number of events that fired.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply