Microsoft Dynamics CRM 2011

Performance

Microsoft Dynamics CRM 2011

Microsoft Dynamics CRM Performance and Scalability on Intel Xeon Processor-based Dell Servers with Solid-State Drives

White Paper

Date: March 2011

Acknowledgements

Initiated by the Microsoft Dynamics CRM Engineering for Enterprise (MS CRM E2) Team, this document was developed in part with support from across the organization and in direct collaboration with the following:

Key Contributors

Brian Bakke (Dynamics PFE, US)

Russ Dobbins (CRM Performance)

Grant Geiszler (Dynamics PFE, US)

Gus Apostol (SQL CAT)

Martijn Bronkhorst (Dynamics PFE, EMEA) Mukul Agarwal (MSSolve)

Andy Dow (Dynamics PFE, EMEA)

Paul Liew (MSSolve)

Aditya Varma(CRM Performance)

Nitasha Chopra (Intel)

The MS CRM E2 Team recognizes their efforts in helping to ensure delivery of an accurate and

comprehensive technical resource in support of the broader CRM community.

MS CRM E2 Contributors

Ahmed Bisht, Sr. Program Manager

Jim Toland, Sr. Content Project Manager

Amir Jafri, Sr. Program Manager

Murat Ozturan, Principal PM Lead

Feedback

Please send comments or suggestions about this document to the MS CRM E2 Team feedback

alias (entfeed@).

Microsoft Dynamics is a line of integrated, adaptable business management solutions that enables you and your people to make business decisions with greater confidence. Microsoft Dynamics works like and with familiar Microsoft software, automating and streamlining financial, customer relationship and supply chain processes in a way that helps you drive business success.

U.S. and Canada Toll Free 1-888-477-7989 Worldwide +1-701-281-6500 dynamics

Legal Notice

The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication.

This White Paper is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT.

Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.

? 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Server, Active Directory, SQL Server, Microsoft Dynamics, and the Microsoft Dynamics Logo are either registered trademarks or trademarks of Microsoft Corporation.

Intel, the Intel logo, Xeon and Xeon Inside are trademarks of Intel Corporation in the U.S. and other countries.

All other trademarks are property of their respective owners.

2

MICROSOFT DYNAMICS CRM PERFORMANCE AND SCALABILITY ON INTEL XEON PROCESSOR-BASED DELL SERVERS WITH SOLID STATE DRIVES

MARCH 2011

Contents

Overview ................................................................................................................4 Results Summary .................................................................................................4

Testing Methodology ................................................................................................6 Test Scenarios .....................................................................................................6 Business Transactions ...........................................................................................7 Transaction Workload............................................................................................7 Database Server...................................................................................................7 Tuning and Optimization........................................................................................8 Hardware Environment..........................................................................................8

Test Results ............................................................................................................9 Conclusion ............................................................................................................ 10 Appendix A: Additional Resources ............................................................................ 11

Microsoft ........................................................................................................... 11 Intel ................................................................................................................. 11 Appendix B: Benchmark Testing Detail ..................................................................... 12 Table 1: Key Benchmark Test Parameters..............................................................12 Table 2: Key Benchmark Results .......................................................................... 12 Table 3: Row counts for tables with 10,000+ rows..................................................12 Table 4: Business Scenarios Tested (by User Role) ................................................. 14 Table 5: CRM Database Server Hardware .............................................................. 17 Table 6: CRM Web Servers (11, one with Async Server) Hardware............................18 Table 7: Load Balancer Hardware ......................................................................... 18 Table 8: Load Generation Servers (30) Hardware ................................................... 18 Appendix C: Key Benchmark Component Details ....................................................... 19 Intel? Xeon? 7500 Series Processors .................................................................. 19 Pliant Technology Solid State Drives ..................................................................... 21 Microsoft SQL Server 2008 R2 Enterprise Edition .................................................... 21 F5 Big IP Local Traffic Manager............................................................................. 22

MARCH 2011

3

MICROSOFT DYNAMICS CRM PERFORMANCE AND SCALABILITY ON INTEL XEON PROCESSOR-BASED DELL SERVERS WITH SOLID STATE DRIVES

Overview

Microsoft Dynamics? CRM 2011 is designed to help enterprise organizations attain a 360degree view of customers, achieve reliable user adoption, adapt quickly to business change, and accelerate project delivery and returns ? all on a platform that provides enterprise levels of scalability and performance. This white paper focuses on user scalability.

Microsoft, working with Intel? Corporation, completed benchmark testing of Microsoft Dynamics CRM 2011 running on Intel? Xeon? 7500 series processor-based Dell R910 servers with Pliant Technology solid state drives (SSDs). Standard optimizations were applied per guidelines published in the white papers Optimizing and Maintaining Microsoft Dynamics CRM and Improving Microsoft Dynamics CRM Performance and Securing Data with Microsoft SQL Server 2008.

Intels Xeon 7500 series processors, Microsoft Windows Server 2008 R2, Microsoft SQL Server 2008 R2, and Microsoft Dynamics CRM are revolutionizing how enterprises deploy mission critical applications, offering a new standard of performance, reliability, and manageability with the added benefits of virtualization, all at a dramatically lower total cost of ownership (TCO).

Results Summary

Benchmark testing was performed on a Microsoft Dynamics CRM 2011 implementation that included the latest versions of Microsoft? Windows Server? and Microsoft SQL Server?, as well as Intel? Xeon? Processor 7500 series processor-based servers with SSDs. In this test

environment, Dynamics CRM 2011 demonstrated the following performance characteristics:

Concurrent Average

Web

Business

Users*

Response Time Requests Transactions

Average SQL Server Utilization

150,000 .4 seconds

5.5 M/hr 703,080/hr

39.6%

* 150,000 users, each performing a business transaction with the system every 8 minutes

Average CRM Server Utilization

42%

Benchmark results demonstrate that a single Microsoft Dynamics CRM 2011 instance can achieve sub-second response times with 150,000 concurrent users executing a heavy workload against a large, complex database. Large enterprises often deploy multiple parallel CRM instances to meet the diverse needs of different business units or geographies. Distributed across multiple instances, a Microsoft Dynamics CRM deployment can scale to meet the needs of the largest enterprises.

This white paper details the results of benchmark testing conducted on Microsoft Dynamics CRM 2011 running on Intel Xeon 7500 series processor-based servers with SSDs, providing:

A description of the CRM implementation and the methods used to obtain the benchmark Details of the hardware configuration used in testing A summary of the key test parameters and results achieved

4

MICROSOFT DYNAMICS CRM PERFORMANCE AND SCALABILITY ON INTEL XEON PROCESSOR-BASED DELL SERVERS WITH SOLID STATE DRIVES

MARCH 2011

Important: These results reflect the scalability and performance of a specific Microsoft Dynamics CRM 2011 implementation running in a particular test environment. Factors ranging from industry vertical to geographic span can affect how enterprise organizations use their CRM system, so results will vary for each implementation. Customers may be able to achieve higher levels of performance and scalability via customization and a finer level of optimization.

While the CRM Online service is a multi-tenant environment in which resources for each organization are assigned dynamically based on demand, because the online service leverages the same code as does the on-premises version of the product, the benchmark results provided in this paper are applicable across platforms.

Also note that this benchmark focuses on server-side performance and metrics. Dynamics CRM 2011 clients provide richness that requires multiple requests to the server. As a result, response times here are in no way indicative of client responsiveness, for example in loading a form or performing a complete transaction.

MARCH 2011

5

MICROSOFT DYNAMICS CRM PERFORMANCE AND SCALABILITY ON INTEL XEON PROCESSOR-BASED DELL SERVERS WITH SOLID STATE DRIVES

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download