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

Sql Server Query to Get the Option Set label name

In some of our requirements we may need to query the Option set label name from the back end Sql Server.

For this we need to Query the StringMap table in CRM DB.

Query to get the columns from StringMap table will be Select * from StringMap .

 

In order to get option set label name we need to pass the AttributeValue ,ObjectTypeCode,AttributeName.

for eg : if you want to get the gendercode option set label name in Contact entity need to pass the AttributeValue =’1′ ,ObjectTypeCode=’2′,AttributeName=’gendercode ‘.

Total query is as follows.
select cn.LastName,cn.New_age,cn.New_Nationality,sm.Value as Gender
from Contact cn LEFT JOIN [Orgname_MSCRM].dbo.StringMap sm On sm.AttributeValue=’1′ AND sm.ObjectTypeCode=2 AND sm.AttributeName=’gendercode’ AND sm.LangId=’1033′.

Hope this will helps you.

 

Cheers,