Article ID: 968755 - View products that this article applies to.
You use many workflows in Microsoft Dynamics CRM 4.0. The AsyncOperationBase and WorkflowLogBase tables grow very large, and performance issues occur.
This issue occurs because, when the workflow rules are fired, a workflow instance and a workflow record are created in the AsyncOperationBase and WorkflowLogBase tables of the MSCRM database. However, when the workflow instance is completed, the workflow record remains in the database. Therefore, the AsyncOperationBase and WorkflowLogBase tables continue to grow. Eventually, performance decreases.
Note The AsyncOperationType property for these records is set to 10.
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:
(http://support.microsoft.com/kb/949256/ )Microsoft Dynamics CRM 4.0 updates and hotfixes
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/322756/ )How to back up and restore the registry in Windows
After you install the hotfix, to have us enable this hotfix for you, go to the "Fix it for me" section. If you prefer to enable the hotfix yourself, go to the "Let me fix it myself" section.
Fix it for me
To enable the hotfix automatically, click the Fix it button or link. Then click Run in the File Download dialog box, and follow the steps in the Fix it wizard.
Fix this problem
Microsoft Fix it 50835
Then, go to the "Did this fix the problem?" section.
Let me fix it myselfTo enable this hotfix, follow these steps:
(http://support.microsoft.com/kb/968520/ )Performance is slow if the AsyncOperationBase table becomes too large in Microsoft Dynamics CRM 4.0
Did this fix the problem?
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684For more information about Microsoft Business Solutions CRM software hotfix and update package terminology, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/824684/ )Description of the standard terminology that is used to describe Microsoft software updates
(http://support.microsoft.com/kb/887283/ )Microsoft Business Solutions CRM software hotfix and update package naming standards
Article ID: 968755 - Last Review: February 29, 2012 - Revision: 3.0