Improving performance and optimizing Microsoft Dynamics CRM 2011
This section describes methods and resources that can help you improve performance and optimize Microsoft Dynamics CRM, such as by improving web browser page load times when you open a form.
Custom SQL Server indexes
Like an index in a book, an index in a database lets you quickly find specific information returned from a database table or indexed view. An index contains keys built from one or more columns in the table, or view, and pointers that map to the storage location of the specified data.
You can significantly improve the performance of queries generated by Microsoft Dynamics CRM by creating well-designed indexes to support your queries. Indexes can reduce the amount of data that must be read to return the query result set. For example, you can create an index for each search field that is used in a Quick Find query. Each search field should be the leading column in an index.
While creating customized indexes can help improve query performance within a Microsoft Dynamics CRM implementation, be sure to avoid making any modifications to the default indexes that are included with Microsoft Dynamics CRM 2011.
Administrators cannot currently define indexes against a Microsoft Dynamics CRM Online organization.
Custom indexes will likely be removed during a Microsoft Dynamics CRM 2011 database upgrade. A recommended practice is to review any custom indexes in Microsoft Dynamics CRM 2011 databases and then confirm the availability of those indexes after the upgrade.
For more information, see the following topics.
Optimizing and Maintaining a Microsoft Dynamics CRM 2011 Server Infrastructure: Optimizing and Maintaining the Data Tier
Microsoft SQL Server 2012: Create Filtered Indexes
Microsoft SQL Server 2008: Nonclustered Index Design Guidelines
Microsoft SQL Server 2008: Optimizing Indexes
By default, Microsoft Dynamics CRM 2011 is configured to compress web responses that are sent to web browser clients. However, Microsoft Dynamics CRM 2011 does not configure the compression of HTTP responses sent to SDK clients, which includes Microsoft Dynamics CRM for Outlook. This is because HTTP compression of dynamic content is an IIS-wide setting that cannot be configured at the Microsoft Dynamics CRM website level.
To configure Microsoft Dynamics CRM Server 2011 to compress the HTTP responses that are sent to Microsoft Dynamics CRM SDK clients, turn on IIS dynamic compression for the SOAP responses that are returned by Microsoft Dynamics CRM Server. To do this, run the following command on each of your Microsoft Dynamics CRM web application or API servers and then restart each server:
Because IIS dynamic compression for SOAP responses is an IIS server-wide setting, enabling it may cause unexpected behavior or failure in applications running on the IIS server that cannot use it.
%SYSTEMROOT%\system32\inetsrv\appcmd.exe set config -section:system.webServer/httpCompression /+"dynamicTypes.[mimeType='application/soap%u002bxml; charset=utf-8',enabled='true']" /commit:apphost
For more information about configuring HTTP compression of dynamic content on an IIS server, see HTTP Compression <httpCompression>.
Antivirus scans and Microsoft Dynamics CRM
When you run an antivirus application on a computer that is running Microsoft Dynamics CRM Server 2011 or a dependent technology, Microsoft Dynamics CRM performance can be adversely affected. Moreover, antivirus applications may lock certain files making them inaccessible. Because antivirus applications can reduce the performance of application servers, instances of SQL Server, Active Directory domain controllers, Microsoft SQL Server Reporting Services servers, and Microsoft Dynamics CRM client computers, you may want to exclude certain files from file level antivirus scanning.
Make sure that any plans to exclude files from antivirus scanning comply with your internal information technology (IT) management policies.
For more information, including a suggested list of files for exclusion from antivirus applications, see Antivirus exclusion considerations for Microsoft Dynamics CRM.
Performance and optimization resources for Microsoft Dynamics CRM
The following documentation can help you improve performance and reliability with Microsoft Dynamics CRM 2011 and Microsoft Dynamics CRM Online.
Microsoft Dynamics CRM Online system requirements and maintenance schedule
Microsoft Dynamics CRM 2011 Maintenance Jobs
Microsoft Dynamics CRM 2011 Operating and Maintaining Guide
Updating Microsoft Dynamics CRM 2011
How to upgrade a Microsoft Dynamics CRM Server application to Windows Server 2012