- The first step is to verify the oldest data samples within the DataStore. Use the DataStore Profile script for an Oracle database found on the Support Portal's Tools & Utilities page.
Once you know the oldest data sample, go to the Historical Data Purge Scripts page and download the Oracle trim script you want to run i.e. Procedure or Use Archive Settings.
Warning WARNING: All deleted data will be lost. Ensure that you complete a full data store backup before proceeding with a trim script.
Choose a date for which all data samples collected before this day will be deleted. It is strongly recommended that deletions are completed in small chunks (e.g. 2 weeks or 1 month at a time) rather than attempting one large delete statement, so if the oldest data in the data store is from July 1, 20142016, choose July 15, 2014 2016 as the day to delete from.
You can verify that the historical data has been deleted by running a performance graph or report in the Uptime Infrastructure Monitor UI or simply running the Datastore Profile script again.
Once the data have been trimmed we also recommend working with your DBA and running the Index Rebuild script.
If you encounter any issues or have any questions regarding this process please do not hesitate to contact [email protected][email protected].com for guidance.
See related articles for DataStore running on MySQL or MS SQL.