Microsoft Dynamics CRM 2016 Update 1 Performance

The Microsoft Dynamics CRM team has been testing the performance of Microsoft Dynamics CRM 2016 Update 1 (version 8.1) (on-premises) hosted on Microsoft Azure Virtual Machines. The goal is to establish a baseline for performance on Microsoft Dynamics CRM 2016 Update 1, using Azure IaaS infrastructure with premium storage.  The scenarios we have targeted involve thousands of users accessing their environment concurrently, every few minutes, with various workloads designed to simulate production.  In this new baseline, we are testing performance against a SQL DB running on VM (Azure GS5 SKU). The detailed configuration, topology, optimizations, data profile, and test workload as well as lessons we learnt along the way on how to really get your Microsoft Dynamics CRM deployment tuned will be included in a whitepaper to be published very soon.

Infrastructure and Environment Configuration 

Microsoft SQL Server

SQL Server was deployed on an Azure GS5 virtual machine configured with 32 cores and 448 GB of memory.

Microsoft Dynamics CRM Server

Dynamics CRM Server was deployed on Azure DS14 virtual machines configured with 16 cores and 112 GB of memory.

Summary

From the initial round of tests, with around 15,000 concurrent users, we observed an average PLT (Page Load Time) of under a second and average transaction time for complex CRM operations staying at under a couple of seconds.  We’ve designed each of these transactions to mimic real world usage, which include scenarios like:

• Basic user interactions like loading entity forms and manipulating grids.
• Searching and advanced find
• Dashboards and reporting
• Appointment, email, phone calls, etc. (activity tracking)
• Coverage over multiple clients (web, mobile, etc.)
• … and more

We targeted and observed an average CPU utilization between 80-90% with these workloads for the duration of the test run.   Our aim with the white paper will be to stress test Microsoft Dynamics CRM 2016 Update 1 even more, increasing the numbers of users and test mix values to define a benchmark for on-premises installations moving forward. Also the white paper would cover the results from performance testing of Microsoft Dynamics CRM Online (v8.1), under similar load conditions.

The results reflect the scalability and performance achieved on a specific Microsoft Dynamics CRM 2016 implementation running in a particular test environment.  Actual performance may vary based on factors ranging from specific customizations deployed to geographic distribution of users and network latency/bandwidth.  Customers should expect that results will vary for each implementation and should perform their own performance testing based on their needs or requirements.  In some cases, customers may achieve higher levels of performance by fine-tuning or optimizing the configuration of Microsoft Dynamics CRM.

Additional Information

In addition to this performance test run, we have correlated the results found with those observed while performance testing Microsoft IT’s Dynamics CRM Online instances and found an improvement of about 1 second (across different internal scenarios) over the previous baseline for Microsoft CRM Online 2016 (v8.0).

With this white paper release, we aim to demonstrate the robustness of Microsoft Dynamics CRM 2016 Update 1 and its capability to handle concurrent user activities with ease for enterprise CRM scenarios.  This is the result of significant work put into this CRM release and our unwavering commitment to customers to excel on performance standards.

– Srikumar Nair