Microsoft KB Archive/932687

= The processing operation may stop responding when you process a SQL Server 2005 Analysis Services database on a server that has a single processor =

Article ID: 932687

Article Last Modified on 3/22/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Analysis Services

-



SYMPTOMS
When you process a Microsoft SQL Server 2005 Analysis Services database on a server that has a single processor, the processing operation may stop responding. Additionally, you cannot cancel the processing operation. This problem is likely to occur when the database contains a complex cube or a mining model that has multiple nested tables.



CAUSE
This problem occurs because the maximum number of parallel operations is insufficient when the database contains a complex cube or a mining model that has multiple nested tables.



RESOLUTION
To resolve this problem, adjust the CoordinatorExecutionMode configuration value for the server to allow more parallel operations.



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
By default, the maximum number of parallel operations on a server that is running Analysis Services is four operations per processor. This number may be insufficient in some instances. You can adjust the CoordinatorExecutionMode configuration value for the server to allow more parallel operations. For more information, visit the following Microsoft Web site:

http://www.microsoft.com/technet/prodtechnol/sql/2005/ssasproperties.mspx

Keywords: kbtshoot kbexpertiseadvanced kbsql2005as kbprb KB932687

-

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

© Microsoft Corporation. All rights reserved.