Introduction:
The maintenance activity is an essential activity to be considered in environment. This document has been written to share the purge script along with purging document to outline how to use the scripts. It is recommended to purge the old historical data (no more useful) from data base which can impact the performance due to increase size of objects in database.
The tables being purged are the tables containing event information and temporary auditing information. The document includes a high level overview of the Database schema for information.
Environments:
- Applicable for Release Automation 5.x - 6.x
- Database: Microsoft SQL, Oracle DB, MySQL
Instructions:
The scripts included in supplied zip file provide a mechanism to purge data from the Release Automation database. The two stored procedures are provided for purging data in the Release Automation Database:
- The first script is used for purging offline execution Jobs
- The second script can be used to purge audit records.
Attachment Map
Database Type
| Attachment Name
|
|---|
| Microsoft SQL Database | SQLBestPracticeGuide-2-0.zip |
| Oracle Database | OracleBestPracticeGuide-2-0.zip |
| MySQL Database | MySQLBestPracticeGuide-2-0.zip |
Additional Information:
Recommendations:
- It is recommended that the stored procedures be executed during off hours though a scheduled job.
- The two stored procedures can be executed concurrently in different database sessions.
- However, do not execute the same stored procedure more than once simultaneously
- Read the guide enclosed in each zip providing an overview of
Added improvised script sp_purge_execution_jobs-mysql-v1.1.sql (Only for MySQL it is improvised in terms of performance on large data set)