Is it possible to list all SQLs directly which occurred during a designated period of time
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?
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
Thank you for your prompt reply. I have found the configuration.
Welcome the
Dynatrace Community Forums
Check out the Forum User Guide and Forum Guidelines to learn how to get started.Community Member of the Month
October 2017
Announcing Dynatrace's Community Member of the Month for October 2017, Ram S.! Click here to read more! 