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.

1 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.