Currently we can find the SQLs from "Diagnose Performance"-> “Database” or "PurePaths", but it seems that there is not a easy way to capture the all SQLs which occurred during a designated period of time. Is it possible to list all SQLs directly which occurred during a designated period of time?
Answer by Andreas G. ·
Hi
If you open the Database dashlet just as you explained you will get a new Dashboard with the Database Dashlet on it. The default timeframe is "last 30 mins" which means that you see ALL SQLs of the last 30 minutes. Dashboards however allow you to specify ANY Timefilter. Simply click on the hyperlink which says "last 30 minutes". This brings you in the filter settings where you can choose a custom timerange.
Be aware though that - if you define a very long timeframe it may take a while until the dynaTrace Server analazyes ALL PurePaths from that Timeframe as it most likely needs to read it from disk first. Also - be aware that doing this for a timeframe that is e.g: 1 year back will probably not work as you most likely to not have PurePaths stored on disk any longer that are that old
Andi
JANUARY 15, 3:00 PM GMT / 10:00 AM ET