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

Blocking SQL

Hello,
I have Redgate Monitor 14 Standard installed, and it’s monitoring one SQL Server instance.
This instance has many locking issues, with blocking SQL queries and deadlocks.
I need to extract all this information for analysis, but in the Redgate interface and dashboard I can only find the option to extract deadlock details — not blocking SQL data.

Is there a way to create a report or another method to extract both the count and details of blocking SQL queries and deadlocks within a specific time range?

Regards

 

Federico
0

Comments

1 comment

Sort by
  • Kieran Avey
    Official comment

    Hi Federico,

    Thank you for reaching out. 
     
    There isn't a way to export the blocking info like there is for the deadlock xdl I'm afraid. What you could try though is to copy the information from a blocking process alert (the Details and Processes tabs).
     
    There's not really a report that would help here either, except maybe an Alert report using a filter to filter the results to each specific alert type.

    Kieran Avey

Add comment

Please sign in to leave a comment.