Redgate SQL Monitor database

Question

question

anitadh asked May 9, '16

Redgate SQL Monitor database

Hi, I am just trying to get a history of how long a query is taking to run. i have looked at the Redgate database directly and have looked at the Cluster_SqlServer_TopQueries_Instances_View view querytext column it does not contain the text. How can i get the details of the text? Many Thanks Anita

redgate

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2016-05-12T03:54:50Z

GPO answered May 12, '16

Try contacting Redgate [here][1]. They have a support forum as well. This forum (although hosted by Redgate I think) is about more broad SQL Server issues generally, rather than specific vendor database questions. [1]: http://www.red-gate.com/products/dba/sql-monitor/support

3

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush commented · May 12, 2016 at 09:07 AM

I agree. There's no sign of a table or view in there that holds the query for a SQL handle unless they've called that column something else there. My guess is this view is about what's heavy right now and the handle is used to get the details from the plan cache for display. I don't think the query details get stored in the monitor database. But ask Red Gate. They'll know!

1 ·

anitadh commented · May 12, 2016 at 09:51 AM

Thanks for your reply! I got in touch with Redgate and they advised that the query text is compressed... they do not usually support decompression but have suggested other ways for me to retrive this info which i will pursue

0 ·

GPO commented · May 12, 2016 at 11:59 PM

@anitadh Thanks for the feedback Anita. If you're happy with the answer remember to mark it as correct - otherwise it comes out of my pay :-(

0 ·

question