OpsCenter database best practices
Following are the best practices for optimizing database performance:
See Disclaimer.
Install or configure the OpsCenter database on a physical disk that is different from where the OpsCenter and OS files are installed.
Tune the OpsCenter database for optimal performance.
Do not disable the data purge option.
You can configure data purge settings from Settings > Configuration > Data Purge tab in the OpsCenter console. Note that the more the retention period, the more is the effect on the performance.
For better performance, Backup Logs data should be retained for minimal days (like three days), which is a default setting. This is because Backup Logs hold temporary data and this data is not directly used by any OpsCenter report.
Defragment the OpsCenter database periodically: Once a month
Monitor the dbsrv* process memory usage under normal workload and also while executing OpsCenter reports. If this process consumes all the allocated cache size, then it is recommended that you tune it.
Increase the cache size of the OpsCenter database based on the RAM and database size.