Although, we treat our Production environment with all our respect, Archiving/Delete one of the most significant aspects in improving the PI Production environment performance.
The message store on the Integration Engine is the component for which data archiving is most critical. Depending on the integration processes that are running on the Integration Server, large numbers of messages with large message sizes be persisted in the Integration Engine. Therefore, the archiving of (Processed, Error out, History Entries) messages must be carefully planned and monitored. Thus, this effort helps in preventing the Archiving and Delete related table’s growth and consequently that help out improving performance.
Even though, there are different sources on the same topic area but this wiki gives you brief and significant details for quick reference about the whole aspect of archiving/delete procedure.
This weblog and wiki would be applicable to those who manage large PI landscape or about to be a part of such a large PI implementation.