Search by Query hash in Top queries

Eugene_P

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?

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.

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