28
Currently, queries from Environment monitoring - SQL Insights tab are very slow. I tested on different production instances and executing "List most expensive queries" and "Get the SQL query plan for a given plan ID" took 5-10 minutes to get any results. Such huge times makes this functionality very unusable. Is it possible to improve the performance of these queries - to several seconds(a full list can be found here
https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/lifecycle-services/performancetroubleshooting) or implement some new queries? For example, this "Get Top SQL" is always instant even on huge databases - https://github.com/TrudAX/TRUDScripts/blob/master/Performance/AX%20Technical%20Audit.md#get-top-sql
https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/lifecycle-services/performancetroubleshooting) or implement some new queries? For example, this "Get Top SQL" is always instant even on huge databases - https://github.com/TrudAX/TRUDScripts/blob/master/Performance/AX%20Technical%20Audit.md#get-top-sql
STATUS DETAILS
Needs Votes