I have a bunch of blocking, is there a way to export all related queries?
Babak
Posts: 1 New member
Example, May 07 between 9 PM to 9:15 PM we had 80 blocking I need related queries
Tagged:
Answers
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
Have you visited our Help Center?