This article has been archived. It is offered "as is" and will no longer be updated.
The hotfix that is discussed in this article is unavailable for the Chinese version of Microsoft Dynamics CRM or for the Japanese version of Microsoft Dynamics CRM.
After you change a security role or after you import a customization file in Microsoft Dynamics CRM 3.0, you experience timeouts or slow performance on the computer that is running Microsoft SQL Server. (The Microsoft Dynamics CRM databases are installed on this computer.) You may notice high CPU usage and high memory usage. This problem occurs until the role change operation is complete or until the import process is completed.
Microsoft Dynamics CRM 3.0 updates the privileges for new custom entities after you import a customization file.
If you have more than several hundred business units set up in Microsoft Dynamics CRM, the role change operation may take several hours.
Typically, this problem occurs if the Microsoft Dynamics CRM 3.0 database contains more than 50 business units.
Update rollup information
This problem is fixed in Microsoft Dynamics CRM 3.0 Update Rollup 2.
For more information about Microsoft Dynamics CRM 3.0 Update Rollup 2, click the following article number to view the article in the Microsoft Knowledge Base:
922815 Update Rollup 2 is available for Microsoft Dynamics CRM 3.0
About the changes included in this fix
Although you typically experience the problem that is described in the "Symptoms" section when you have more than 50 business units in Microsoft Dynamics CRM, this fix improves performance even when you have fewer than 50 business units in Microsoft Dynamics CRM.
To change the security roles, follow these steps:
In the Settings pane, click Settings, click Business Unit Settings, and then click Security Roles.
Double-click a security role.
In the Role dialog box, change privileges for the security role.
To import a customization file, follow these steps:
In the Settings pane, click Customization, click Import Customization, and then click Browser.
In the Choose file dialog box, locate and then click the customization file that you want to import, and then click Open.
Click Import All Customizations.
For more information about the problem that occurs when you import customizations in Microsoft Dynamics CRM 3.0 with Windows Internet Explorer 7 installed, click the following article number to view the article in the Microsoft Knowledge Base:
927667 The Import Customizations Web page does not close as expected when you try to import customizations in Microsoft Dynamics CRM 3.0 after you install Internet Explorer 7
For information about performance tuning for CRM 3.0, see the following white paper: