I recently onboarded an AD Base application into the production environment. I have observed that the account aggregation task is taking significantly longer than the expected average runtime. The application currently manages approximately 85,000 accounts.
I have already enabled Delta Aggregation and Partitioning; however, the performance issue persists even after these optimizations. I would appreciate insights or recommendations from the community to help resolve this issue.
Hi khushboo, Have you configured any correlation rule or customization rule on the Active Directory application that executes during account aggregation? Such rules run per account and can significantly impact performance when aggregating large volumes (e.g. 85k accounts).
Additionally, have you tested the task with partition disabled??
@Ksharma11 If you are using customization rule, then it could be one of the reason for longer time. Another reason could be the large number of groups per user, and also frequent change on group assignments. IIQ need to update all entries in multiple tables based on aggregated data.
However, delta should be fast, do you have any numbers like how many users are processed in full aggregation vs delta aggregation. If delta is also bringing all users, then no need to have delta aggregation. You also need to review why many users are being modified after the last aggregation.
Note: Found a fix?Help the community by marking the comment as solution. Feel free to react(,, etc.)with an emoji to show your appreciation or message me directly if your problem requires a deeper dive.
