Types of maintenance types-of-maintenance
Application maintenance application-maintenance
Adobe Campaign provides a built-in workflow which lets you schedule certain database maintenance tasks: the database cleanup workflow. This workflow carries out the following tasks:
- deletion of expired records,
- deletion of orphaned records and status reinitialization for expired objects,
- updating the database statistics.
Technical maintenance technical-maintenance
The database cleanup workflow does not include any database maintenance tool: it is up to you to organize maintenance. To do this, you can either:
- work with your Database Administrator to set up database maintenance with third-party tools,
- use the Adobe Campaign workflow engine to schedule and track these maintenance activities.
These maintenance procedures must be carried out on a regular basis and should include the following:
- re-index frequently updated tables,
- compact/rebuild the tables to avoid fragmentation.
Maintenance schedule maintenance-schedule
You need to find the appropriate slots for performing these maintenance activities. They can heavily impact the database performance while running or even block the application (due to locking).
These tasks are typically run once a week during a period of low activity that does not collide with backups, data reloading or aggregate calculation. Some systems which are highly solicited require more frequent maintenance.
More in-depth maintenance, such as full table rebuilds, can be performed once a month, preferably with applications fully stopped since the system is unusable anyway.
Rebuilding a table rebuilding-a-table
Several strategies are available:
All active processes writing to the table during the process must be stopped. However, reading processes will not be affected, since the table is swapped at the last moment once rebuilt.