Applies to Product – Dynamics 365 Commerce
What’s happening?
The customer is experiencing slow performance during data migration imports using the Data Management Framework (DMF). The performance in the Production environment is significantly slower compared to previous tests, impacting the timely execution of data loads necessary for go-live activities.
Reason:
The underlying causes of the slow performance may include: - Introduction of custom code leading to longer processing times. - Slow SQL queries, particularly those merging change table data into an entity. - An overloaded SQL database. - A bad query plan affecting execution times.
Resolution:
To address the slow performance during DMF imports, the following steps are recommended: 1. Increase the Maximum Batch Threads: Configure the maximum number of batch threads per instance of Application Object Server (AOS) by setting the Maximum batch threads field on the Server configuration page. 2. Restart Batch AOS Instances: Restart the batch AOS instances to alleviate low memory states. 3. Review Entity Specific Settings: Go to the Data Management workspace, click on the Framework parameters tile, and review the entity-specific settings. If the allowed task count is high, reduce it to somewhere in the 24 to 48 range to prevent delays in starting writer tasks. 4. Check for Validation Errors: Ensure that all records are validated correctly to avoid issues that may prevent records from being imported to the target entity. 5. Execute Imports During Off-Peak Hours: Schedule import jobs during periods when the system is less busy to improve performance.
If the issue persists after implementing these steps, further analysis may be required, including reviewing specific batch job IDs or session IDs.