Friday, May 13, 2016

Tip #302: Optimize CRM by updating statistics and reorganizing indexes

http://community.dynamics.com/crm/b/dynamicscrmtipoftheday/archive/2015/01/14/tip-302-optimize-crm-by-updating-statistics-and-reorganizing-indexes

If you’re running CRM (any variant) on-premise you can optimize the speed of the system by setting up two management jobs inside SQL. First, update statistics of the organization_MSCRM database every day (outside business hours). Second is to reorganize the indexes of the organization_MSCRM database every 2-4 days.

No comments:

Post a Comment