Dynamics CRM 2011 Quick Optimization Guide




This article is from Technet, url in the end of the post

Dynamics CRM 2011 Quick Optimization Guide

I’ve put together a high-level list of optimizations for dynamics CRM to centralise information for myself, and thought sharing would be helpful for someone, I’ll keep this list updated as I find more information., PLEASE ADD more optimizations tips & tricks to this article.


Authentication

The number of authentication request’s and authentication challenges takes valuable seconds deteriorating performance.

  1. Application Pool Kernel Mode authentication enabled

  2. Enable Kerberos

  3. http://quantusdynamics.blogspot.co.uk/2011/12/extreme-performance-with-dynamics-crm.html

  4. Enable useAppPoolCredentials

  5. Enable authPersistNonNTLM

Resources:

http://support.microsoft.com/kb/2593042


IIS

  1. AppPool Recycling

  2. Configure to recycle after hours.


  1. WCF Compression – enable compression for the content-type: application/soap+xml; charset=utf8 this content type is used by the Outlook client HTTP requests. Compressing this traffic reduces network traffic and improves communication.

  2. http://blogs.msdn.com/b/crminthefield/archive/2011/12/29/enable-wcf-compression-to-improve-crm-2011-network-performance.aspx

  3. Enable Dynamic Compression

  4. http://www.iis.net/ConfigReference/system.webServer/httpCompression

CRM Registry Keys

A number of tweaks can be done on the CRM side to improve performance.


  1. You can control the size of the Workflow table by deleting completed Workflows with a registry key, this is a nice way to improve performance on the database side, however this can only be applied if you don’t need the workflow history.

  2. Name: AsyncRemoveCompletedWorkflows

  3. Type: DWORD

  4. Value: 1

  5. Improve SQL Performance EnableRetrieveMultiple

  6. Type: DWORD

  7. Value: 2 (Decimal)

  8. Fixes a number of issues around the SQL tempdb database and improves performance

  9. http://support.microsoft.com/kb/2535245

With Microsoft Dynamics CRM 2011 Update Rollup 10 or later, having the HKLMSoftwareMicrosoftMSCRMEnableRetrieveMulitiple Optimization set to 0 can often give better performance than having it set to a value of 2. http://support.microsoft.com/kb/2710577 – “Update Rollup 10 for Microsoft Dynamics CRM 2011 is available” See this for more detailed information: Update Rollup 10 includes performance improvements for retrieving multiple queries and for Quick Find. For more information, see the “Optimizing the Performance of Queries against Large Datasets” and “Optimizing the Performance of Quick Find Queries” sections of the Optimizing and Maintaining the Performance of a Microsoft Dynamics CRM 2011 Server Infrastructure white paper. To download this white paper, go to the following Microsoft Download Center website: Optimizing and Maintaining the Performance of a Microsoft Dynamics CRM 2011 Server Infrastructure –http://www.microsoft.com/en-us/download/details.aspx?id=27139

  1. Disable the email pop-up reminder to speed up load times

  2. Name: DisablePendingEmailReminder

  3. Type: DWORD

  4. Value: 1

  5. Set a preferred Domain Controller to speed up AD checks

  6. Name: PreferredDC

  7. Type: String

  8. Value: DC_Name

There are a number of registry keys targeting different types of performance issues and types of environments, Microsoft is now releasing with each update Roll Up a package named:’tools’.This package contains a tool that can implement a number of updates/optimizations which were previously reserved for registry implementations, this way makes it easier to enable optimizations centrally and avoid creating registry keys across multiple front-end servers. http://support.microsoft.com/kb/2691237 e.g number of registry keys part of RU6

  1. DisableSmartMatching

  2. Default Value – False

  3. AutoCreateContactOnPromote

  4. Default Value – True

  5. BackgroundSendBatchFile

  6. Default Value – 10

  7. DisableInactiveRecordFilterForMailMerge

  8. Default Value – False

  9. LookupNameMatchesDuringImport

  10. Default Value – False

  11. EnableRetrieveMultipleOptimization

  12. Default Value – 1

  13. DoNotIgnoreInternalEmailToQueues

  14. Default Value – False

  15. SkipSuffixOnKBArticles

  16. Default Value – False

  17. SkipGettingRecordCountForPaging

  18. Default Value – False


Database

  1. CRM Indexes with DMVs

  2. http://quantusdynamics.blogspot.co.uk/2012/11/dynamics-crm-database-optimization-with.html

  3. Optimizing CRM built-in maintenance jobs with Indexes

  4. http://quantusdynamics.blogspot.co.uk/2013/08/dynamics-crm-2011-optimize-built-in.html

  5. CRM SQL Maintenance jobs

  6. https://community.dynamics.com/product/crm/crmtechnical/b/crminthefield/archive/2012/04/26/avoid-performance-issues-by-rescheduling-crm-2011-maintenance-jobs.aspx

  7. http://crmjobeditor.codeplex.com/

  8. Max parallelism set to 1

  9. http://technet.microsoft.com/en-us/library/dd979074.aspx

  10. Enable Lock Pages in memory forcing SQL queries to run using physical memory

  11. http://msdn.microsoft.com/en-us/library/ms190730(v=sql.105).aspx

  12. Enable Read Committed Snapshot isolation to avoid deadlocks

  13. http://www.microsoft.com/en-us/download/details.aspx?id=24923

  14. http://technet.microsoft.com/en-us/library/ms345124.aspx

  15. Maintenance of the Workflow Table AsyncOperationBase

  16. http://support.microsoft.com/kb/968520

  17. Maintenance of the Principal Object table PrincipalObjectAccess

  18. http://support.microsoft.com/kb/2664150

  19. SQL Deadlocks article

  20. http://quantusdynamics.blogspot.co.uk/2012/01/dynamics-crm-40-sql-dead-locks.html


Outlook Client

  1. Outlook client optimization

  2. http://quantusdynamics.blogspot.co.uk/2013/07/dynamics-crm-2011-outlook-client.html

  3. Registry Keys

  4. http://support.microsoft.com/kb/2585157

  5. Increase the CRM Sync options, this depends on your environment.Settings > Email

  6. Promote emails

  7. Syncronization

  8. Manage Outlook filters

  9. http://blogs.msdn.com/b/crm/archive/2011/06/02/controlling-user-synchronization-settings.aspx

  10. Disable cached pinned-views with a registry key on the client side

  11. Name: DisableMapiCaching

  12. Type: DWORD

  13. Value: 1

Note: Make sure you enable IIS WCF compression from point 2. IIS


Internet Explorer

  1. Ensure CRM url is added to the local intranet zone

  2. Authentication Options

  3. AutoLogon

  4. Windows Integrated Authentication

  5. Reset Zoom level for new windows and tabs

  6. Disk space for temporary internet files

  7. 250MB

  8. Increase IE connections to the server with Registry Keys

  9. http://support.microsoft.com/?kbid=282402

Email Router

  1. Installing email router on multiple servers

  2. http://quantusdynamics.blogspot.co.uk/2012/02/dynamics-crm-installing-email-router-on.html

  3. Load Balance Email router

  4. http://quantusdynamics.blogspot.co.uk/2012/03/dynamics-crm-load-balance-email-router.html

  5. Scalling Email router with Business Units

  6. http://quantusdynamics.blogspot.co.uk/2012/04/dynamics-crm-2011-scaling-email-router.html

  7. – Email router scalability and availability

  8. http://blogs.msdn.com/b/crminthefield/archive/2012/10/28/microsoft-dynamics-crm-2011-e-mail-router-availability-and-scalability.aspx

  9. Reduce the configuration update period

  10. Open the Microsoft.Crm.Tools.EmailAgent.xml in notepad and edit the following line to 86400000 this will set the email router to update the user list once a day, this is important if you have a large number of users in your environment.

  11. <configupdateperiod>86400000</configupdateperiod>

  12. Increase the number of emails to process on each batch

  13. On the same file as above you need to add an extra section to override some of the settings, this will stay included on the <systemconfiguration> section:</systemconfiguration>

  14. <provideroverrides>

  15. <cachecapacity>1024 </cachecapacity>

  16. <pendingstatusdelay>300000 </pendingstatusdelay>

  17. <sendingstatusdelay>1800000 </sendingstatusdelay>

  18. <maximumdeliveryattempts>10 </maximumdeliveryattempts>

  19. <retrievemessagecount>10 </retrievemessagecount>

  20. <batchsize>50 </batchsize>

  21. <requestbatchsize>50 </requestbatchsize>

  22. </provideroverrides>

  23. for more information on how to use <proveroverrides> </proveroverrides> go to:http://support.microsoft.com/kb/972150

If you have more than 5000 users in your environment you will need to increase email router limits on how many users to load from CRM by setting MaxRowsPerPage on the front-end server:

  1. Name: MaxRowsPerPage

  2. Type: DWORD

  3. Value: Number_of_rows (Decimal)


Monitoring

Use SSIS to monitor pending emails

Resources

  1. Optimizing and Maintaining the Performance of a Microsoft Dynamics CRM 2011 Server Infrastructure. http://www.microsoft.com/en-us/download/details.aspx?id=27139

  2. Optimizing and Maintaining Client Performance for Microsoft Dynamics CRM 2011 and CRM Online. http://www.microsoft.com/en-us/download/details.aspx?id=23261

  3. Security and Authentication in Microsoft Dynamics CRM: Connectivity and Firewall Port Requirements in On-Premise Deployments.http://www.microsoft.com/en-us/download/details.aspx?id=12774

  4. Security and Authentication in Microsoft Dynamics CRM: The Microsoft Dynamics CRM Security Model. http://www.microsoft.com/en-gb/download/details.aspx?id=12108



  1. Outlook Synchronization in Microsoft Dynamics CRM 4.0.http://www.microsoft.com/en-us/download/details.aspx?id=17594

  2. Offline and Online Synchronization in Microsoft Dynamics CRM. http://www.microsoft.com/en-us/download/details.aspx?id=2737

  3. Sharing Data across Microsoft Dynamics CRM Deployments.http://www.microsoft.com/en-us/download/details.aspx?id=10151

  4. Optimizing and Maintaining Microsoft Dynamics CRM 4.0.http://www.microsoft.com/en-us/download/details.aspx?id=3997

  5. How to configure the Microsoft Dynamics CRM on-premises and Microsoft Dynamics CRM Online E-mail Router in different deployment scenarios. http://www.microsoft.com/en-us/download/details.aspx?id=21445

  6. Deploying Microsoft Dynamics CRM 2011 and CRM Online Solutions from Development through Test and Production Environments.http://www.microsoft.com/en-us/download/details.aspx?id=27824

From Technet:

http://social.technet.microsoft.com/wiki/contents/articles/13661.dynamics-crm-2011-quick-optimization-guide.aspx#SQL_Jobs

#CRM2011 #CRM2011Optimization

0 views0 comments

Recent Posts

See All