What manual maintenance tasks are recommended for the One Identity Manager (1IM) database?
Identity Manager executes daily maintenance tasks automatically. These tasks can be found in Designer by selecting Base Data then click to expand General and select Schedules and loading the schedule called "Daily Maintenance Tasks".
As with any other database, it is important to perform monitoring and maintenance of a One Identity Manager database. This will take the form of standard database maintenance tasks such as managing table indexes and database statistics. Some further reading on this subject could include:
Are I/O latencies killing your performance?
Do Not Forget to Maintain Your Indexes
Improve SQL performance – find your missing indexes
A DBA will need to monitor the SQL Server and make the decisions about what additional maintenance to perform based on the specifics of that environment.