You may want to delete historical performance data if the Uptime Infrastructure Monitor Archive process has timed out and data older than the Archive Policy still exists in the data store.  You may also choose to manually delete historical performance data to free up the threads for regular monitoring that the Uptime Infrastructure Monitor Archive process would occupy.  Another reason to manually delete historical performance data is to shrink the size of the DataStore.

  1. 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.
  2. 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: All deleted data will be lost.  Ensure that you complete a full data store backup before proceeding with a trim script.
  3. 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, 2016, choose July 15, 2016 as the day to delete from.

  4. 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.

  5. 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] for guidance.

See related articles for DataStore running on MySQL or MS SQL