The Asyncoperation tables grow very large in Microsoft Dynamics CRM 4.0

The Asyncoperation tables grow very large in Microsoft Dynamics CRM 4.0.

This problem is fixed in the latest cumulative update rollup for Microsoft Dynamics CRM 4.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

To enable this hotfix, the following registry key must be added: AsyncRemoveCompletedJobs. To add the registry key, complete the following steps:

1. Click Start, click Run, type regedit, and then click OK.
2. Locate the following registry subkey:
   HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM
3. Right-click MSCRM, point to New, and then click DWORD Value.
4. Type AsyncRemoveCompletedJobs for the name of the key.
5. Right-click AsyncRemoveCompletedJobs, click Modify and then type 1 in the Value data field.

When the value of this registry key is set to 1, the following asynchronous jobs will be removed immediately after completion:

• CollectSQMData
• PersistMatchCode
• FullTextCatalogIndex
• UpdateContractStates