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

SQL blocking queries from the monitor DB

Hi all, I'm trying to extract blocking information across our estate from our redgate monitor platform (version 14), given this isn't available in the product.. has anyone written any queries to extract the data directly from the backend SQL database?

David Wall
0

Comments

1 comment

Sort by
  • Christian Perez
    Official comment

    Hi David, 

    Redgate Monitor doesn’t currently offer a built‑in feature to export blocking data across the entire estate. However, you may be able to retrieve this information using Redgate Monitors Rest API feature.

    Try reviewing through this page: https://documentation.red-gate.com/monitor14/rest-api-in-monitor-enterprise-240976357.html

    https://documentation.red-gate.com/monitor14/alerts-240976373.html

    Alternatively: You can try to query the Data Repository directly, however,  all monitoring and alert data—including blocking alerts—is stored in the Redgate Monitor Data Repository database. You can query the underlying tables to retrieve historical blocking information. However, Redgate does not publish this schema, and it may change between versions, so direct SQL access is considered an advanced and unsupported method. Typically we do not share custom scripts to query the Redgate Monitor dbs unless it is for troubleshooting purposes and at developments discretion.

    Let me know if the above is unclear.

    Christian Perez

Add comment

Please sign in to leave a comment.