Microsoft KB Archive/308932

= FIX: Enterprise Manager May Show Incorrect Number of Configured CPUs =

Article ID: 308932

Article Last Modified on 11/17/2003

-

APPLIES TO

 Microsoft SQL Server 2000 Enterprise Edition, when used with:  Microsoft SQL Server 2000 Enterprise Edition

 Microsoft SQL Server 2000 Developer Edition 

-



This article was previously published under Q308932



BUG #: 352327 (SHILOH_BUGS)

BUG #: 354362 (SHILOH_BUGS)



SYMPTOMS
If you configure SQL Server for more than 16 processors, then in the SQL Server Properties dialog box on the Processor tab in Enterprise Manager, only 16 processors are selected. If you close the SQL Server Properties dialog box with either the OK, Apply or Close command buttons, the affinity mask value incorrectly changes to 16 processors.

This is an issue with the Enterprise Manager display; the sp_configure stored procedure shows the correct affinity mask value configured for SQL Server.



RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack

<div class="workaround_section">

WORKAROUND
To work around this problem, use the sp_configure stored procedure to check the configured number of processor for SQL Server and to configure the number of processors for SQL Server.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 2.

Keywords: kbbug kbfix KB308932

-

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

© Microsoft Corporation. All rights reserved.