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.
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
What is considered to be a part of the DOM load time
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.
- Dynamics CRM
- SQL Error
- Relic Performance
- New Relic
- SQL Profiler
- Database Engine Tuning Advisor
- DOM Load Time