Microsoft Dynamics CRM Server performance is less than expected

Microsoft Dynamics CRM Server performance is less than expected

 

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.

Link from : http://msdn.microsoft.com/en-us/library/dd979074(v=crm.6).aspx

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s