How can we help you today? How can we help you today?

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
Babak
0

Comments

1 comment

Sort by
  • Alex B
    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
    Alex B
    0

Add comment

Please sign in to leave a comment.