Microsoft Dynamics CRM 4.0 demonstrated its ability to scale to support the needs of an enterprise organization with a very large customer service database. In a test based on a customer database of over 1 billion records, Microsoft Dynamics CRM was able to achieve sub-second response times using a modest hardware configuration.
PERFORMANCE
AND
SCALABILITY
Database Scalability for the
Enterprise
Microsoft Dynamics CRM 4.0 March 2008 CONTENTS
EXECUTIVE SUMMARY ................................................................................................................................... 1 RESULTS SUMMARY ................................................................................................................................................................... 1
OVERVIEW ....................................................................................................................................................... 2
TESTING METHODOLOGY ............................................................................................................................. 2 BUSINESS TRANSACTIONS ...................................................................................................................................................... 3 TUNING AND OPTIMIZATION ................................................................................................................................................ 3 HARDWARE ENVIRONMENT ................................................................................................................................................... 4
TEST RESULTS ................................................................................................................................................. 4
CONCLUSION .................................................................................................................................................. 5
RESOURCES ..................................................................................................................................................... 6
Database Scalability for the Enterprise
Executive Summary Microsoft DynamicsT CRM business software is designed to help enterprise MICROSOFT organizations achieve a 360-degree view of their customers across marketing, sales, and service. Engineered to deliver performance that meets the needs of the largest DYNAMICS CRM IS global deployments, Microsoft Dynamics CRM has been tested for user scalability, data scalability, and network performance. This white paper focuses on database CAPABLE OF scalability. ACHIEVING SUB-
Microsoft Corporation conducted scalability testing to evaluate the performance of a SECOND RESPONSE single instance of Microsoft Dynamics CRM 4.0 in a very large database scenario. The results of these tests demonstrated that Microsoft Dynamics CRM is capable of TIMES RUNNING USER achieving sub-second response times running user transactions against a database of TRANSACTIONS over 1 billion records. AGAINST A DATABASE These tests were performed for a Microsoft customer whose service representatives require rapid access to records in a very large customer database. The test database OF OVER 1 BILLION was designed based on the customer's production data and the database server RECORDS. received only basic tuning for the test. Microsoft Dynamics CRM exceeded performance goals for this test, ultimately enabling the customer to reduce their final hardware requirements for the deployed solution.
RESULTS SUMMARY In this test environment, Microsoft Dynamics CRM demonstrated the following performance characteristics:
Table 1: Benchmark Test Results Summary Concurrent Number Database Average Average Average SQL Server Users of Size Response Database Page Time Utilization Records Time Transactions 1,500 1.03 1.3 TB .29 654 / second 3.29 12.9% billion seconds seconds
1
Overview MICROSOFT Microsoft Dynamics CRM 4.0 addresses the stringent requirements of the enterprise DYNAMICS CRM in the areas of performance and scalability, application flexibility, efficient manageability, and network configurability. TAKES UNIQUE ADVANTAGE OF THE . Performance and scalability: Microsoft Dynamics CRM takes unique advantage MICROSOFT of the Microsoft® Windows® operating system and Microsoft SQL Server® database platforms to provide enterprise levels of performance and scalability WINDOWS AND SQL while keeping costs under control. Application tuning can be carried out using SERVER PLATFORMS commonly-available skills and tools sets, and the application is designed for ... [download for more]
