Our MSSQL 2012 Auditing database is growing by leaps and bounds. It seems easy to prune/archive the audit database, simply by copying data from ADS_EVENT and ADS_EVENT_DETAIL and then deleting it from the actual database.
However, I do not have the same level of comfort with the monitoring data (MOT_TREND_DATA, etc). I have searched many places, but have not seen any document which outlines how to prune/archive/purge Monitoring data from the Audit database. Seems there is an auto-prune by size function for the ‘Derby’ database (Delete older data when the database size grows more than (MB): ), but not for the ‘Use Audit Database’ option.
Thoughts/ideas, as consistently going to the ‘disk well’ for more space will get old, rather quickly.
jlgh (BOB member since 2009-06-11)