FIX: Enterprise Manager May Show Incorrect Number of Configured CPUs (308932)

The information in this article applies to:

Microsoft SQL Server 2000 Enterprise Edition, when used with:
- Microsoft SQL Server 2000 Enterprise Evaluation 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

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.

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.

Modification Type:	Major	Last Reviewed:	11/17/2003
Keywords:	kbbug kbfix KB308932 kbAudDeveloper