STATISTICS in CRM SQL Server DB

• Question

• 

  

  0

  Sign in to vote

  Hi All,

  We have CRM SQL Server DB with the size of 200 GB.

  The Database Engine Tuning Advisor (DTA) tool is suggested to create 192 STATISTICS and 2 non-clustered indexes. For these recommendations tool is showing 58% estimated improvement. We have already enabled auto create STATISTICS and auto update STATISTICS on CRM DB.

  Will it create any performance issues If we create suggested 192 STATISTICS on CRM SQL Server DB?

  Please share your suggestion/advise on this. 

  ** I have executed DTA with the option "Plan Cache"

  Saturday, October 22, 2016 7:49 AM