Rebuild Reporting DB in scaled environment takes moretime

Question

I have rebuilt the reporting DB in sitecore 9.1,For 60000 records it takes more than one-day,Which was not accepted by client. Please let me the process how could I improve the performance of rebuilding reporting DB.

Answer 1

On KB site is an article about analytics performance: https://kb.sitecore.net/articles/224364

To resolve this issue follow next steps:

1.For Sitecore XP 9.1 Initial Release – 9.1 Update-1, download and execute the following script against your reporting and reporting.secondary databases: Sitecore.AnalyticsOptimization.sql

2. Configure the processing agents. For more information see the following article: https://doc.sitecore.com/developers/90/sitecore-experience-platform/en/configure-processing-agents.html

3. Tune interactions batch size. For more information see the following article:: https://doc.sitecore.com/developers/90/sitecore-experience-platform/en/batch-aggregation.html