Filter by database

In the Trends view, from the "Day" drop down, choose a custom interval (spanning up to 120 hours allowed here). After you choose this date range, you can select the database from the databases tab and then use the Timeslice tab to zoom into a shorter timeframe

I tried it and it says the date range cannot exceed 24 hours but its still helpful. I can at least check 1 whole day and night for an specific database.

Thanks.

There is actually an option that you have to tweak to get to the 120 hours allowed.

options -> administration tab -> Advanced Options

On the system options tab, check the support options checkbox and look for CUSTOM_TIME_MAX_RANGE_IN_HOURS.

I don't think it says, but if my memory serves, I do think it's 120 hours max as Holy Guacamole mentions.

Thank you. I have changed it already. It says "high value can result in degraded performance". May I know what are the implications why DPA says the performance will be degraded for having this increased?

DPA summarizes into hourly and daily waits/stats. By choosing a custom time interval, those charts will be at least partially built out of the detail data putting additional load on the database.