Search code examples
sqlsql-servert-sqldynamics-crmmicrosoft-dynamics

SQL Queries tuning into CRM

I have question regarding MS Dynamics CRM and SQL.

We have CRM 2015 on-prem., we do get lot of warning messages in windows app log that such and such queries exceeded threshold value. Eventually bunch of this warnings lead to an error of failed workflow/plugin.

We ask MS and they recommended to use SQL Server Tuning Advsior and Profiler to optimize those queries, when we ran SQL Server Tuning Advsior and profiler, we got result that this query can be improved by 54% or 65% via applying following changes. Most of them are indexing.

My question is how to create/modify/apply these recommendations in running/live CRM application?

Any guidance will be really helpful.

Thanks.

Solution

  • Creating indexes is a expensive operation, because it has to build the index for the existing records.

    If you could do it in the evenings, and you can afford having some downtime, go for that option. If you have a SQL Server cluster / high availability solution, it would be best to do it for each node separately to avoid downtime.