Export (0) Print
Expand All

Microsoft Dynamics CRM 2011 Maintenance Jobs

Dynamics CRM 2011

This section applies only to on-premises versions of Microsoft Dynamics CRM 2011. By default, Microsoft Dynamics CRM 2011 creates several maintenance jobs. With the exception of the Create Audit Partition job that runs monthly, all Microsoft Dynamics CRM 2011 maintenance jobs run daily. These jobs are executed by the Microsoft Dynamics CRM Asynchronous Processing Service (maintenance) service and are designed to keep the Microsoft Dynamics CRM databases in a stable and optimal state.

 

Name Task Type Number Frequency Description Origin

Deletion Service

14

Daily

Performs periodic cleanup of objects that are associated to deleted records. For more information, see Dynamics CRM 2011 DeletionService Async Maintenance Operation Demystified.

RTM

Indexing Management

15

Daily

Checks to make sure system-managed indexes exist for all entities and recreates missing indexes.

RTM

Cleanup Workflows

21

Daily

Looks for instances of workflow assemblies that are no longer referenced in either rules or in-process jobs. Assemblies that no longer have references are deleted. Consider the scenario where you register a 2.0 version of a custom workflow assembly. You may have updated your rules to reference the new version, but some in-progress jobs may still be referencing the earlier 1.0 version. After those jobs have completed, this maintenance job will cleanup the 1.0 version assembly that no longer contains any references to rules or jobs.

RTM

Reindex All

30

Daily

First, this job reorganizes or rebuilds fragmented indexes based on the amount of fragmentation. Next, if the version of Microsoft Dynamics CRM 2011 is earlier than Microsoft Dynamics CRM 2011 Update Rollup 12, it performs a DBCC SHRINKDATABASE command to release the unused physical drive space for both database and transaction log files.

noteNote
With Microsoft Dynamics CRM 2011 Update Rollup 12 or later update rollup, you should assess the organization database and log file growth to determine whether running a DBCC SHRINKDATABASE is necessary. For more information, see DBCC SHRINKDATABASE (Transact-SQL).

RTM

Create Audit Partition

41

Monthly

Alters the partitioning scheme for the auditbase table (SQL Server Enterprise editions only).

RTM

Check for MUI Updates

42

Daily

Detects upgrades to Microsoft Dynamics CRM language packs and schedules workers to perform the provisioning.

RTM

RefreshRowCountSnapshots

46

Daily

Refreshes the Record Count snapshot statistics used in the updated query plans.

Update Rollup 10

RefreshReadSharingSnapshots

47

Daily

Refreshes the PrincipalObjectAccess (POA) table read snapshot statistics.

Update Rollup 10

Verifying run times and duration

The Microsoft Dynamics CRM Asynchronous Processing Service (maintenance) service records an event when the job scheduler, a component of the service, completes a maintenance job and includes the task type, and start and finish time. To view these events in Event Viewer, sort on MSCRMAsyncService$maintenance. For example, the event here is recorded for the Reindex All maintenance job, which is task type 30, and had a duration of one hour.

Host CONTOSO.MSCRMAsyncService$maintenance.39ce9fb1-d2bd-410e-82c8-76e5eccd75ad: Job Scheduler has executed tasktype=30, organizationid=a4e88e84-34b6-44da-8fde-3cab23a242df, starttime=11/20/2012 9:42:47 PM, endtime=11/20/2012 10:42:48 PM, resultcode=0, message=TotalIndexesToRebuild=0, rebuiltWithOnlineON=0, rebuiltWithOnlineOFF=0 in 3601064 milliseconds.

Effect on performance and user experience

Depending on when the organization was created, some maintenance jobs may run when users are accessing the system. During this time Microsoft Dynamics CRM users may notice a decrease in performance or timeouts. For example, when maintenance jobs run during late morning hours while users are accessing Microsoft Dynamics CRM, form loads and saves may occur slowly. Here are some options available that let you reschedule or postpone Microsoft Dynamics CRM 2011 maintenance jobs.

CautionCaution
Postponing maintenance jobs can affect Microsoft Dynamics CRM in ways that reduce system performance such as those caused by file and index fragmentation. Carefully assess the optimal time to reschedule maintenance jobs and monitor the system performance after a schedule change is introduced.

Job Editor tool

The Job Editor is a tool that can be used for editing the scheduling of Microsoft Dynamics CRM 2011 maintenance jobs, which are automatically scheduled by the installation of Microsoft Dynamics CRM Server 2011 as described earlier. Using the tool, you can reschedule maintenance jobs during a time when there will be a limited number of users in the system to avoid impact on the users, such as early morning or overnight or to run less frequently.

ImportantImportant
The Job Editor tool is a community provided tool and is not supported by Microsoft. Use the Job Editor tool at your own risk. For more information, see Avoid Performance Issues by Rescheduling CRM 2011 Maintenance Jobs. To download the tool, Job Editor.

Custom solutions for file and index fragmentation

If you choose to disable the Reindex All job, you should configure and schedule your own database maintenance procedure to resolve file and index fragmentation. For more information, see Top Tips for Effective Database Maintenance.

See Also

Send comments about this article to Microsoft.

© 2013 Microsoft Corporation. All rights reserved.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft