Timeline for Sitecore 9 update 1 xDB Data Migration Tool Pipeline Batch Extremely slow/hangs
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 20, 2018 at 13:43 | comment | added | Vlad Shpak | @NavneetPisharodi Hi, You can play with configuration settings in Sitecore.Analytics.Processing.Aggregation.Services.config At least you can increase default value for "minimumBatchSize" of "contactWorkDispatcher" | |
| Mar 20, 2018 at 12:31 | comment | added | Navneet Pisharodi | A late reply @Vlad but I was trying out a few things before coming back to you. From the look of it xDB data migration seems to be quick and fine especially after making the configuration changes you suggested above. I now am at a point where I feel that it is the xconnect processing that is extremely slow. Once xDB Data Migration tool has pulled all the batches from Mongo, the xconnect processing engine should go in, aggregate them into SQL. But processing is painfully slow (e.g in 15 hours, I see 466 rows in [dbo].[Fact_PageViews] table where infact I expect 42K rows. Any thoughts? | |
| Feb 23, 2018 at 23:53 | history | edited | Vlad Shpak | CC BY-SA 3.0 |
added 87 characters in body
|
| Feb 23, 2018 at 23:46 | history | answered | Vlad Shpak | CC BY-SA 3.0 |