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.
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