Need some help on querying the actual "_QueryText" (not compressed)

Based on the thread here: https://forum.red-gate.com/discussion/81787/writing-custom-queries-against-repository-for-pulling-sql-monitor-alert-data

And the three articles that seem to be the only source on the planet that could assist someone trying to directly query the RedGateMonitor repository:
https://www.red-gate.com/simple-talk/blogs/sql-monitor-data-repository/
https://www.red-gate.com/simple-talk/blogs/sql-monitors-data-repository-alerts/
https://www.red-gate.com/simple-talk/blogs/sql-monitors-data-repository-monitoring-data-part-1/

How can someone directly query the Repository to get a query(s) or other data that seems to be compressed?

For features that possibly aren't available yet (e.g. Dashboard TOP 10's available on Reports?) it would be really helpful to be able to view our own data.

Any help would be appreciated.
Tagged:

Answers

  • RichardLRichardL Posts: 417 Gold 4

    Hi @arsqldba_CL

     

    This looks like a question that one of Support engineers will need to investigate for you.

     

    If you've a got support contract, please send us a ticket. Provide as much information as you can - screenshots of any errors, log files etc – so we can help you as fast as possible.

    If you're not covered by a Support contract at the moment, email our Sales team at sales@red-gate.com, and they'll be able to help.


    Kind regards


    Richard Lynch. 

    Customer Support
    Redgate Software
  • arsqldba_CLarsqldba_CL Posts: 4 New member
    Thank you. I submitted a support ticket.
  • Alex BAlex B Posts: 1,151 Diamond 4
    edited March 23, 2018 9:24AM

    Hi @arsqldba_CL

    Apologies for the misunderstanding here I think Richard misinterpreted the request and missed that I had replied in the original thread you referenced. 

    As I stated in the older forum post - the text is compressed (I believe it's gzip compressed) and you would need to write your own application to retrieve and decompress this.  The SQL Monitor data repository is designed for performance of the SQL Monitor application accessing the information rather than for direct querying of the information; the direct querying of the information is not supported by us.

    There is also the SSRS Reporting pack (download here) which may give some further insight into how the tables connect.

    If there are features or functionality that you would like to see in SQL Monitor please raise a Uservoice suggestion!

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.