To analyse a trend over a period of say 30 days using one continuous line graph is difficult. If we could see a line for day 1, overlapped with day2, day 3 etc over the same 24 hour period then its easier to see trends and patterns e.g. processing time increases at 1pm everyday
See the Baselining features introduced in SQL Monitor 3.5
Thanks for your suggestion. I'd be interested to know how far the current 'Baseline' feature goes towards helping solve your problem.
1. On the Analysis page, select processor time on the relevant machine and then set a time range of 24 hours
2. Click 'Compare baseline' button - by default this will compare it with a period 24 hours earlier (i.e. past 24hrs vs. 24 hours previous)
3. Click 'Extend baseline' button
4. Move the slider to extend the baseline by 10 previous time ranges
The graph should now be showing the past 10 days (or 10 x 24 hour periods) overlayed as 10 lines on the graph. It's not the thirty days you were looking for, but does this go some way towards helping?
If you view the image at http://ux.red-gate.com/wp-content/uploads/2014/08/Analysis_baseline.jpg you should see the pattern where processing time increases at the same time every day (just after 7am).