Article ID: 2535245 - View products that this article applies to.
When you perform RetrieveMultiple queries on large datasets in Microsoft Dynamics CRM 2011, you experience slow performance.
This problem occurs because large datasets cache the Microsoft SQL query plans for the RetrieveMultiple queries. The RetrieveMultiple optimization for the basic depth is required for the "local depth" read privilege and for the "deep depth" read privilege.
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/322756/ )How to back up and restore the registry in Windows
This problem is fixed in the latest cumulative update rollup for Microsoft Dynamics CRM 2011. For more information about the latest cumulative update rollup for Microsoft Dynamics CRM 2011, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/2466086/ )Update Rollup 2 for Microsoft Dynamics CRM 2011 is available
If Update Rollup 8 or an earlier upudate rollup is installed, follow these steps to enable this hotfix on the computer that is running Microsoft Dynamics CRM 2011:
Optimizing and Maintaining the Performance of a Dynamics CRM 2011 Server Infrastructure
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/824684/ )Description of the standard terminology that is used to describe Microsoft software updates
(http://support.microsoft.com/kb/887283/ )Microsoft Business Solutions CRM software hotfix and update package naming standards