Skip to main content

Microsoft Releases Dynamics CRM 2011 Data Load Performance and Scalability Case Study

by Linda Rosencrance
Contributing Writer, MSDW

Microsoft has released details of a bulk data load benchmark testing on Microsoft Dynamics CRM 2011 performed on behalf of a large financial services company in a new white paper.

The company was looking for a new CRM system because its existing CRM solution stored customer data (including various related custody account information) in its host system. And that meant that during daily operations users were frequently creating and updating customer records.

To better accommodate business needs, the company wanted to set up a solution that would manage its master customer data as well as integrate data with its host system, according to a blog post by Jim Toland, Senior Content Project Manager, Enterprise Audience Content Team at Microsoft.

One of the first steps the company had to take was migrating and synchronizing legacy customer data with the new system. That's when the customer asked Microsoft Services to conduct benchmark testing of an on-premises deployment of Microsoft Dynamics CRM 2011, according to Toland.

The reason for the testing was to ensure that Dynamics CRM 2011 could accommodate the need to create or update 10 million custody account records as part of a single batch job that would be completed in four hours or less.

The key goals of the testing were to:

  • Verify that bulk data load for both the initial data migration and for batch processing on fixed schedules could be achieved in a reasonable time.
  • Estimate the time required to migrate 91.8 million customer records and their related custody entities to Microsoft Dynamics CRM 2011.
  • Identify the hardware capacity required to meet ...

    FREE Membership Required to View Full Content:

    Joining gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
    Learn more about us here

About Linda Rosencrance

Linda Rosencrance is a freelance writer/editor in the Boston area. Rosencrance has over 25 years experience as an reporter/investigative reporter, writing for many newspapers in the metropolitan Boston area. Rosencrance has been writing about information technology for the past 16 years.

She has covered a variety of IT subjects, including Microsoft Dynamics, mobile security issues such as data loss prevention, network management, secure mobile app development, privacy, cloud computing, BI, big data, analytics, HR, CRM, ERP, and enterprise IT.

Rosencrance is the author of six true crime books for Kensington Publishing Corp.