Sunday 19 August 2012

Dynamics CRM 2011 Optimization guide

View the wiki technet article here:  http://social.technet.microsoft.com/wiki/contents/articles/13661.dynamics-crm-2011-quick-optmization-guide.aspx

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.
  1. Authentication
  2. IIS
  3. CRM Registry Keys
  4. Database
  5. Outlook Client
  6. Internet Explorer
  7. Email Router
  8. Monitoring
  9. Resources

1. Authentication
The number of authentication request's and authentication challenges takes valuable seconds deteriorating performance.
Resources:


2. IIS

  • AppPool Recycling
    • Configure to recycle after hours.


3. CRM Registry Keys
A number of tweaks can be done on the CRM side to improve performance.
  • 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.
    • Name: AsyncRemoveCompletedWorkflows
    • Type: DWORD
    • Value: 1
  • Improve SQL Performance EnableRetrieveMultiple
    • Type: DWORD
    • Value: 2 (Decimal)
    • Fixes a number of issues around the SQL tempdb database and improves performance
    • http://support.microsoft.com/kb/2535245
    • Note that with RU10 the suggested default option is 0 read more on the [1] resource document optimizing and maintaining performance.
  • Disable the email pop-up reminder to speed up load times
    • Name: DisablePendingEmailReminder
    • Type: DWORD
    • Value: 1
  • Set a preferred Domain Controller to speed up AD checks
    • Name: PreferredDC
    • Type: String
    • 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
  • DisableSmartMatching
    • Default Value – False
  • AutoCreateContactOnPromote
    • Default Value - True
  • BackgroundSendBatchFile
    • Default Value – 10
  • DisableInactiveRecordFilterForMailMerge
    • Default Value - False
  • LookupNameMatchesDuringImport
    • Default Value - False
  • EnableRetrieveMultipleOptimization
    • Default Value - 1
  • DoNotIgnoreInternalEmailToQueues
    • Default Value - False
  • SkipSuffixOnKBArticles
    • Default Value - False
  • SkipGettingRecordCountForPaging
    • Default Value – False

4. Database


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

6. Internet Explorer
  • Ensure CRM url is added to the local intranet zone
  • Authentication Options
    • AutoLogon
    • Windows Integrated Authentication
  • Reset Zoom level for new windows and tabs
  • Disk space for temporary internet files
    • 250MB
  • Increase IE connections to the server with Registry Keys


7. Email Router








  • 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:

    • Name: MaxRowsPerPage
    • Type: DWORD
    • Value: Number_of_rows (Decimal)

    8. Monitoring





     8. Resources 


    1. [CRM 2011] 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. [CRM 2011] 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. [CRM 4][NB] 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. [CRM4][NB] Security and Authentication in Microsoft Dynamics CRM: The Microsoft Dynamics CRM Security Model. http://www.microsoft.com/en-gb/download/details.aspx?id=12108
    5. [CRM4] Outlook Synchronization in Microsoft Dynamics CRM 4.0. http://www.microsoft.com/en-us/download/details.aspx?id=17594
    6. [CRM4] [NB] Offline and Online Synchronization in Microsoft Dynamics CRM. http://www.microsoft.com/en-us/download/details.aspx?id=2737
    7. [CRM4] Sharing Data across Microsoft Dynamics CRM Deployments. http://www.microsoft.com/en-us/download/details.aspx?id=10151
    8. [CRM4] Optimizing and Maintaining Microsoft Dynamics CRM 4.0. http://www.microsoft.com/en-us/download/details.aspx?id=3997
    9. [CRM2011] [Email Router] 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
    10. [CRM 2011] 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






    6 comments:

    1. This comment has been removed by a blog administrator.

      ReplyDelete
    2. Anything changed or no longer applicable for CRM 2016?

      ReplyDelete
    3. I've put together a high level list of optimisations 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. customer-relationship-management

      ReplyDelete
    4. This comment has been removed by the author.

      ReplyDelete
    5. This comment has been removed by the author.

      ReplyDelete
    6. A software company brand's reputation may be built on its crm development. Having a positive relationship with a consumer can be considered as critical to a company's success. The ability to build a relationship with a consumer helps the customer to trust the vendor. This provides the buyer an incentive to buy from the firm in addition to the service.

      ReplyDelete