Wednesday, September 12, 2012

CRM 2011 Better performance for dashboards and advanced find


Recently Microsoft released an updated implementation guide.
I read an interesting note in there about the groups that are created by the CRM 2011 installer.
An new account is added to the SQL server called MSCRMSqlClrLogin.
mscrmsqlclrlogin

This account is used for time zone conversions when you use dashboards, charts and also when using advanced find.
But only when SQL server is enabled to use CLR. As Microsoft says this can significantly improve performance for these features.
To enable CLR in SQL Server you need to run the following query in SQL Management Studio.
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO
Also make sure you are not using lightweight pooling in SQL server before you activate CLR. This is not supported with CLR enabled.
I hope this helps! Cheers

3 comments:

  1. Hi,,

    I am finding really nice information related to Microsoft Dynamic CRM. your post help me a lot. I love this. I agree with all of the points, it's amazing - thanx a lot for that one ..!

    If you any query about Microsoft Dynamics CRM are welcome.

    Thanks!!!!

    ReplyDelete
  2. Do you have any reference to Microsoft whitepapers about CLR and CRM? I have not been able to find any good examples on this.

    ReplyDelete
    Replies
    1. Hi Frode.
      If you download CRM 2011 implementation guide from Microsoft:
      http://www.microsoft.com/en-us/download/details.aspx?id=3621
      Search the document CRM2011IG_Installing.docx for CLR and you will find a little information about it.
      Regards,
      Hans

      Delete