D365 F&O Data Migration Best Practices, Patterns and Anti-Patterns

Scenario # 3 - Data loading slows down after importing large volume of data

Data loading slows down after importing large volume of data in the initial set of legal entities. Performance keeps deteriorating for the same data entity for subsequent data loads in other legal entities.

Patterns

Warm up and statistics management

• Clean up history using staging clean up

• Prior to running a data migration job for a large volume of data consider updating the statistics across the associated tables/entire database.

Anti-Patterns

• Lack of review of performance telemetry – e.g., indexes, query plan etc.

• DO NOT use Tier-1 environment for Data Migration.