I have a bunch of blocking, is there a way to export all related queries?

Example, May 07 between 9 PM to 9:15 PM we had 80 blocking I need related queries
Tagged:

Answers

  • Alex BAlex B Posts: 1,158 Diamond 4
    edited May 13, 2024 11:43AM
    Hi @Babak,

    There is not an export functionality on the Server overview page for the Blocking processes (top 10 by time) page unfortunately.

    If the blocking processes raised alerts, then you should be able to see the blocking fragment for the head blocker on the alert Details and Processes tabs:



    and the blocking chain and fragments of those queries on the alert Processes tab:


    If I have misunderstood, please do clarify where you are looking to export and if it is the above and you would like to see a feature added to export the Blocking processes from the Server overview page, please raise a suggestion on the Uservoice forum here https://sqlmonitor.uservoice.com/forums/91743-suggestions/filters/top

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.