One of the requirements for an environment I am working with was to be able to provide performance information for more than a two year period of time. By default, the grooming interval for performance data in Operations Manager is 400 days. To change for this requirement we needed to change the grooming interval on the performance data. In our environment, we have really come to appreciate a lot of the new reports including the “Data Warehouse Properties Report” which is shown below with default data retention periods.
[TANGENT STARTS HERE: When we started with Operations Manager there were no methods available to estimate data warehouse sizing so seeing this report really makes my day. This process has gone light-years past the types of calculations we were building in Excel based upon estimated impacts of rows of different types of data into the Data Warehouse and then from a formula trying to determine what database sizes would look like a year after deployment, but I digress… TANGENT ENDS HERE]
Note that the report shows the estimated maximum sizing for the database at just over 100 gb in the report before we made the change. We changed the data retention for the performance (hourly and daily) using the steps detailed within Kevin Holman’s blog entry available at http://blogs.technet.com/b/kevinholman/archive/2010/01/05/understanding-and-modifying-data-warehouse-retention-and-grooming.aspx. After making the change, the estimated Data Warehouse database size increased to just over 150 gb.
Summary: Check out the new Data Warehouse Properties report and if you want to determine projected database sizes after making data retentions changes you should really check out this report (before and after making the changes)!