This documentation is archived and is not being maintained.

Microsoft Dynamics CRM Server performance is less than expected

[Applies to: Microsoft Dynamics CRM 4.0]

Microsoft Dynamics CRM Server may perform less than expected and users may experience slow page-load times. This issue can occur if the computer that is running SQL Server where the Microsoft Dynamics CRM databases are stored is configured to support parallel plan queries. This configuration can cause Microsoft Dynamics CRM Server performance to decrease. We recommend that you disable parallel plan query support on this instance of SQL Server.

To resolve this issue, disable parallel plan query support on the instance of SQL Server. To disable parallel plan query support, run the following stored procedure:

exec sp_configure 'show adv', 1;

RECONFIGURE WITH OVERRIDE;

exec sp_configure 'max degree', 1

RECONFIGURE WITH OVERRIDE;

Exec sp_configure

Verify the output row for 'max degree of parallelism' displays a configured value and a run value of 1.

If you want to re-enable parallel plan queries, set the value for 'max degree of parallelism' back to zero. For more information about parallel plan query support, see the SQL Server Books Online.


© 2011 Microsoft Corporation. All rights reserved.

Show: