Back

TechnologyJul 24, 2013

Dynamics CRM Performance Tuning – Series Introduction

James Parks

Numerous Dynamics CRM projects run into problems around performance. Like many out-of-the-box systems, there are maintenance tasks that must be performed periodically to keep it humming. Many times this gets overlooked as systems undergo extreme customizations that can hinder performance. There are a few simple things you can do to greatly increase the performance of your Dynamics CRM system.

scenario

You’re working on a 1,000+ user implementation of Dynamics CRM that recently went live in the production environment. Through the customization process the ribbon xml has been changed with the addition of many new buttons that link to functionality in an app built on top of CRM. You are experiencing long response times, or even timeouts, from the SDK when querying for data from the CRM database. CRM keeps throwing the generic “SQL Error,” and you’re afraid you’re risking user adoption of your new CRM platform.

where to go from here

In this blog series we will walk through the steps our team took in this scenario with a client to learn what CRM was doing under the hood, identify the root cause of the performance issues, and ultimately solve the issue of slow response time. This blog series will be organized accordingly:

1)    Setup New Relic Performance Monitoring

  • Installing New Relic

  • Configuring New Relic to report on Dynamics CRM

  • Configuring New Relic to report on apps built on top of CRM (ISVs)

2)    Leveraging New Relic to Identify Issues

  • Introduction to New Relic

  • What is New Relic actually monitoring?

  • Understanding the load time of a page

  • Detecting slow running queries

  • Detecting slow UI load times

3)    Database Optimizations

  • Provide a SQL script to identify missing indexes

  • Using the SQL Profiler to track slow performing queries

  • Using the Database Engine Tuning Advisor to optimize queries

  • How entity views effect database performance

4)    Optimize Ribbon & JavaScript Customizations

  • What is considered to be a part of the DOM load time

  • Identifying JavaScript functions that are hindering performance

  • Tricks to lighten the load on the ribbon

Stay tuned for part one, Setup New Relic Performance Monitoring, of this four-part blog series on Dynamics CRM Performance Tuning. Until then, follow @CrederaMSFT on Twitter to stay up to date on the latest Microsoft news.

Personalize marketing campaigns and increase revenue with Microsoft Dynamics

Explore Our Microsoft Consulting Services  →