Microsoft Dynamics CRM 2011 Data Load Performance and Scalability Case Study

This white paper provides details of bulk data load benchmark testing performed on behalf of a large financial services company. The company’s existing CRM solution stored customer data (including various related custody account information) in their host system, in which users during daily operations were frequently creating and updating customer records. To better accommodate business needs, the company wanted to set up a solution that would provide for management of their master customer data as well as data integration with their host system. One of the first steps in the move to a new business solution involved migrating and synchronizing legacy customer data with the new system. To this end, the customer contacted Microsoft Services with a request to conduct benchmark testing of an on-premises deployment of Microsoft Dynamics CRM 2011. The testing was designed to ensure that the system could accommodate the need to create or update 10 million custody account records as part of a single batch job that would complete in a period of no longer than four hours.