You experience slow performance when workflows are running in Microsoft Dynamics CRM 3.0 (910095)
The information in this article applies to:
SYMPTOMSWhen workflows are running in Microsoft Dynamics CRM 3.0, you experience slow performance in Microsoft Dynamics CRM. The problem occurs when you process lots of data and lots of transactions.RESOLUTIONTo resolve this problem, create a new index to optimize the performance of Microsoft Dynamics CRM. To do this, run one of the following statements in Microsoft SQL Query Analyzer. Note Make a backup of the SQL databases before you make any modifications to the databases. CREATE INDEX [foo] ON [dbo].[WFActionLog]([ObjectId], [processinstanceid]) WITH FILLFACTOR = 80 ON [PRIMARY]
GO
DROP INDEX [dbo].[WFProcessInstance].[ndx_Core]
CREATE INDEX [ndx_Core] ON [dbo].[WFProcessInstance]([ProcessInstanceId], [DeletionStateCode], [StateCode]) WITH FILLFACTOR = 80 ON [PRIMARY]
GO
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
| Modification Type: | Major | Last Reviewed: | 6/22/2006 |
|---|
| Keywords: | kbtshoot kbMBSworkflow kbMBSadministration kbMBSMigrate kbprb KB910095 kbAudEndUser kbAudKnowledgeWorker |
|---|
|