Lock Wait Time (ms) alert sent in delay RRS feed

  • Question

  • I'm testing the alert option, and unfortunately I thought that I could rely on sys.dm_exec_requests to check out the lock wait time.

    Unfortunatley, it seems that this view (or the table which it's based upon) is not the one inspected online, I mean that the alert is sent AFTER the lock is released.

    This is quite disappointing since I understand that I wont be able to on-time precisely trace the blocker or the victim on long locks cases.

    I will have to build my own sys.dm_exec_request repository and build a specific job.

    If someone faced that same need and had a ready-to-implement solution, I'll be glad to hear of it, otherwise, I will present my solution.

    • Edited by ZionAssedo Monday, January 29, 2018 9:25 AM
    Monday, January 29, 2018 9:24 AM