Microsoft KB Archive/906649

= Unsupported tuning options for some editions of SQL Server 2000 and of SQL Server 2005 =

Article ID: 906649

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Developer Edition
 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 2000 Enterprise Edition 64-bit
 * Microsoft SQL Server 2000 Developer Edition
 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Enterprise X64 Edition
 * Microsoft SQL Server 2005 Express Edition
 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Standard X64 Edition
 * Microsoft SQL Server 2005 Workgroup Edition

-



INTRODUCTION
Microsoft SQL Server 2005 Books Online incorrectly lists the editions of SQL Server that are supported by the Database Engine Tuning Advisor graphical user interface (GUI) and the dta utility.

Note The dta utility is the command prompt version of the Database Engine Tuning Advisor.

The Database Engine Tuning Advisor GUI and the dta utility can be used to tune databases only on the following editions of SQL Server:
 * SQL Server 2005 Developer Edition
 * SQL Server 2005 Enterprise Edition
 * SQL Server 2005 Enterprise Evaluation Edition
 * SQL Server 2005 Standard Edition
 * SQL Server 2000 Developer Edition
 * SQL Server 2000 Enterprise Edition
 * SQL Server 2000 Enterprise Evaluation Edition
 * SQL Server 2000 Standard Edition

However, not all tuning options are supported for SQL Server 2005 Standard Edition or for the editions of SQL Server 2000.



Unsupported tuning options for SQL Server 2005 Standard Edition
Tuning options that involve indexed views, partitioning, and generating online recommendations are not supported for SQL Server 2005 Standard Edition.

Unsupported tuning options for SQL Server 2000
Tuning options that involve partitioning and generating online recommendations are not supported for any edition of SQL Server 2000. Additionally, tuning options that involve indexed views are not supported for SQL Server 2000 Standard Edition.

Unsupported tuning options in detail
The following table lists the tuning options that are not supported by the Database Engine Tuning Advisor GUI.

Note The Indexes and indexed views option and the Indexed views option are disabled in the Database Engine Tuning Advisor GUI.

The following table lists the tuning options that are not supported by the dta utility.

Keywords: kbinfo kbtshoot kbsql2005engine KB906649

-

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

© Microsoft Corporation. All rights reserved.