0

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.

2

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

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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