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

2 comments

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
  • vahid

    Hi, I have installed Redgate Monitor version 13.0.19.19808. In the “Blocking processes” section, it’s no longer possible to view the page in full screen. In previous versions, this was possible. Has this feature been removed in this version?

    vahid
    0

Add comment

Please sign in to leave a comment.