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

Babak

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

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