Best Means to see older performance data
So we have just passed another peak performance period.
How do I "persist" this performance data for the next time the business unit requests it? It might be 3 weeks ago, might be 1 year depending on the timing as we have several Peak performance periods in any year.
So far I know I can
1) Increase the data purge limits to 1year or even do not purge at all.
2) Export the analysis charts to CSV (to be consumed via Excel and some simple charting)
3) Generate some screenshots of existing Analysis sets
Unfortunately each has some cons.
1) We're quite busy - 25 servers generate some 500GB of RedGateMonitor database for default 3 month settings-
What effect on the database response when it has 1 year, this being 2TB in size?
2) Ideally this export to CSV will be an automated process. You can save the URL once your relevant metrics are chosen/displayed, but exporting to CSV means you have a weak manual human driven process failure point.
3) Similar to the above and weaker, in that scenarios requiring troubleshooting are atypical, so one fixed picture is harder to compare to the next situation.
Oh and is the last "hail mary" option viable where you make database backups, restore elsewhere, and point another installation of SQL monitor at this to get the "comparative" baseline for a period beyond your data purge limit?
It would be nice to get some input on how other people and RedGate see the long term usage of SQL Monitor to get comparisons.
My company's business has several peak performance periods in any year, but I would imagine most industries only have 1 or 2, so would need to consider the longer term comparisons.
Thanks for your attention and hope that some ppl get something out of the various options above (like saving URLs for a particular set of metrics).