Group expensive queries by query hash
I would like to have a section where the query execution counters are aggregated per query_hash.
We use Dynamics Ax ERP and in order to avoid parameterisation issues we enabled passing company literals instead of parametres. This now leads to a single expensive query "taking up" as many of the top 10 query slots as there are companies executing this query.
Ideally it would be possible to show the top 10 query hash data on the top level and then drill into each sql handle and view the query statistics and history there.
Rasmus Bielidt
shared this idea
-
From version 12.1.50 top queries are grouped together by query hash, opening a group shows each of the individual queries.
-
Sanjiv
commented
Any updates on this? SQLGrease allows drilling down by query hash as opposed to a single query with literal values and it's very useful
