CRM 4.0 Performance and Scalability

 

Microsoft, together with Unisys Corporation, completed benchmark testing of Microsoft Dynamics CRM 4.0 running on Microsoft® Windows Server® 2008 operating system and Microsoft SQL Server® 2008 database software. Benchmark results demonstrate that Microsoft Dynamics CRM can scale to meet the needs of an enterprise.

This white paper provides an overview of the results and benefits of performance and scalability enhancements in Microsoft Dynamics CRM 4.0.

Performance and Scalability – User Scalability for the Enterprise

These benchmark results demonstrate that Microsoft Dynamics CRM can scale to meet the needs of an enterprise-level, mission-critical workload of 24,000 concurrent users while maintaining performance at sub-second response times. Test results were achieved without customizations to simulate an out-of-the-box Microsoft Dynamics CRM deployment. This white paper describes the goals, methodology and detailed results of this performance benchmark.

Performance and Scalability – Database Scalability for the Enterprise

These benchmark results demonstrate that Microsoft Dynamics CRM can scale to data volumes of over 1 billion database records while maintaining performance at sub-second response times. Test results were achieved without customizations, and minimal optimization to simulate an out-of-the-box Microsoft Dynamics CRM deployment. This white paper describes the goals, methodology and detailed results of this performance benchmark.

Performance and Scalability – Bandwidth Utilization Improvements

Microsoft Dynamics CRM showed network utilization improvements of up to 94% in version 4.0. This white paper details the test results comparing version 3.0 to 4.0.

Download Files:

1. Microsoft Dynamics CRM_4_0_Enterprise Performance and Scalability.pdf

2. Microsoft Dynamics CRM_4_0_Performance and Scalability _Users.pdf

3. Microsoft Dynamics CRM4_0_Performance and Scalability_Network.pdf

4. Microsoft Dynamics CRM4_0_Performance and Scalability_Database.pdf

Performance & Optimization

The AsyncOperationBase and WorkflowLogBase tables grow very large and performance issues occur when you use many workflows in Microsoft Dynamics CRM 4.0

 

This issue occurs because, when the workflow rules are fired, a workflow instance and a workflow record are created in the AsyncOperationBase and WorkflowLogBase tables of the MSCRM database. However, when the workflow instance is completed, the workflow record remains in the database. Therefore, the AsyncOperationBase and WorkflowLogBase tables continue to grow. Eventually, performance decreases.

Performance is slow if the AsyncOperationBase table becomes too large in Microsoft Dynamics CRM 4.0

 

When you run Microsoft Dynamics CRM 4.0, the AsyncOperationBase table grows to be very large. When the table contains millions of records, performance is slow.