Microsoft KB Archive/910095

= You experience slow performance when workflows are running in Microsoft Dynamics CRM 3.0 =

Article ID: 910095

Article Last Modified on 3/27/2007

-

APPLIES TO


 * Microsoft Dynamics CRM 3.0

-





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



RESOLUTION
To 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 



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
For information about performance tuning for CRM 3.0, see the following white paper:

Optimizing the Performance of Microsoft Dynamics CRM 3.0 White Paper

Keywords: kbtshoot kbmbsworkflow kbmbsadministration kbmbsmigrate kbprb KB910095

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.