Цитата из Microsoft_Dynamics_CRM_IG_Operating.doc (для CRM 4.0):
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, view SQL Server Books Online.
Если пять минут погуглить ища "SQL Server parallelism", то находится множество описаний.
В том числе и очень подробное на MSDN
http://msdn.microsoft.com/en-us/library/ms181007.aspx