Applies to Product - Dynamics 365 Commerce
What’s happening?
The customer reported an issue with the import process for the Earth_##_EpContractEntity, which took an unusually long time compared to previous imports.
Reason:
The delay in the import process was confirmed to be due to the execution of specific queries that were taking longer than expected. The server logs indicated that multiple batch jobs were generated during the time of the import, which contributed to the high load on the Azure SQL Database.
Resolution:
- Investigate the specific queries that were executed during the import process.
- Confirm if there were any other processes affecting the Azure SQL Database's performance at the time of the import.
- If necessary, consider optimizing the queries or adjusting the batch job scheduling to reduce the load on the database during peak times.
- Monitor the performance of the import process after implementing any changes to ensure that the issue does not recur.