locked
CRM 2011 database tuning RRS feed

  • Question

  • Dears /

    We have MS Dynamics CRM 2011 and we are facing a slow performance on the production environment.

    kindly we need a SQL tuning script for CRM database without affecting the performance because the application is online 24/7.

    BR.

    Sunday, November 16, 2014 1:08 PM

All replies

  • Hi Silini,

    You can use the below KB Article.

    http://support.microsoft.com/kb/968520

    --

    Regards,

    Gopinath

    Monday, November 17, 2014 9:51 AM
  • Hi,

    First we need to identify the performance bottleneck.

    It can be because of many reasons like

    1.missing index or high index fragmentation

    2.Principle object access table growth

    3.Async table and workflow base table growth

    4.frequent lock in the database etc..

    try to identify the root cause

    Thanks,

    Seban

    Tuesday, November 18, 2014 4:36 PM