Changing the Audit Collection Service DataRetention Period (based on the info found on the technet site)
Operations Manager grooms, or removes, data from its various databases at regular configurable intervals. For the Operations database, this is done in the Operations console. For the ACS database, these settings are configured during setup with a default value of 14 days. This means that every day, all database partitions (and their data) that are older than 14 days are dropped or deleted. Because of the volume of data that ACS can accumulate, 14 days is not an unreasonable setting. However, some companies might need to retain data for longer periods and they must have already planned for that when making the sizing and performance calculations for their environment. You can change the retention period for the ACS data by following this procedure.
To Change the ACS Data- Retention Period
Log on to the computer running SQL Server that hosts the ACS database with an account that has administrative rights to the ACS database.
Open the SQL Server Management Studio tool, and connect to the database engine.
Expand the Databases folder, and select the OperationsManagerAC database.
Right-click to open the context menu and select New Query….
Run the following query to see what your retention period is: SELECT * FROM dtConfig
Look for row 6. The result contains the days to retain + 1
- In the Query pane, type the following, where number of days to retain data + 1 equals the number of days you want to pass before data that has aged past that point is deleted. For example, if you want to retain data for 30 days, type 31
USE OperationsManagerAC UPDATE dtConfig SET Value = <number of days to retain data + 1> WHERE Id = 6 and then click the Execute button on the toolbar. This will run the query and then open the Messages pane, which should read (1 row(s) affected).
To view the new setting, delete the previous query text from the Query pane and enter SELECT * FROM dtConfig. This will open the Results pane below the Query pane.
Look at the value in the sixth row; it should now equal the value you entered for <number of days to retain data + 1>.
Restart the Operations Manager Audit Collection Service for this to take effect.