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

Search by Query hash in Top queries

https://documentation.red-gate.com/monitor14/top-queries-239668180.html#Topqueries-TopQuerySearchTopQuerySearch shows that Search can only be done by QueryText, DatabaseName and ParentObjectName.
Can you please also add a search by QueryHash? Or advise which internal RG Monitor table I can query by query hash to find corresponding query text?
Eugene_P
0

Comments

2 comments

Sort by
  • JoshH
    While Redgate Monitor doesn't allow searching by the QueryHash, the TopQueries_StableSamples table (begins with data.xxx and grouped by your type, ie cluster, AzureSqlServer, etc) collects the QueryHash. That might help you get what you are looking for.

    As for a feature request, you can enter those at our UserVoice website. Our project managers are always looking at those for ideas about new features to add.
    JoshH
    0
  • Eugene_P
    JoshH said:
    While Redgate Monitor doesn't allow searching by the QueryHash, the TopQueries_StableSamples table (begins with data.xxx and grouped by your type, ie cluster, AzureSqlServer, etc) collects the QueryHash. That might help you get what you are looking for.

    As for a feature request, you can enter those at our UserVoice website. Our project managers are always looking at those for ideas about new features to add.
    thank you, I submitted the feature request https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/49407620-search-by-query-hash-in-top-queries
    Eugene_P
    0

Add comment

Please sign in to leave a comment.