Replicating the databases
BMC recommends that you replicate the databases used by your data sources and use the replicated database as your reporting instance. This replicated database should be configured with regular refreshes from the production database.
The main benefit of using a replicated database is to reduce the performance issues on the live database and improve the application reliability, as the data is spread into multiple systems. This also helps in data retention in case of any failure. If you concurrently refresh certain BMC Analytics for BSM reports, depending upon the amount of data on the replicated database, the reports may take a long time to refresh. In this case, the live database is not impacted. Additionally, if the live database is down, you can still use the replicated database as a backup for reporting and continue with the analytical reporting.
For more information about the replicated BMC Remedy AR System database, see BMC Analytics for BSM with a replicated BMC Remedy AR System database.