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

arsqldba_CL

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.

RichardL

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. 

arsqldba_CL

Thank you. I submitted a support ticket.

Alex B

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