Unsupported tuning options for some editions of SQL Server 2000 and of SQL Server 2005 (906649)


The information in this article applies to:

  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Enterprise Evaluation Edition
  • Microsoft SQL Server 2000 Enterprise Edition 64-bit
  • Microsoft SQL Server 2000 Developer Edition 64 bit
  • 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
  • SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Workgroup

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.

MORE INFORMATION

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.
OptionNot supported for SQL Server 2005 Standard Edition and SQL Server 2000 Standard EditionNot supported for SQL Server 2000 Developer Edition, Enterprise Edition, and Enterprise Evaluation Edition
Indexes and indexed views X
Indexed views X
Full partitioning X X
Aligned partitioning X X
Keep aligned partitioning X X
Generate online recommendations where possible X X
Generate only online recommendations X X
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.
OptionNot supported for SQL Server 2005 Standard Edition and SQL Server 2000 Standard EditionNot supported for SQL Server 2000 Developer Edition, Enterprise Edition, and Enterprise Evaluation Edition
-fa IDX_IV X
-fa IV X
-fp FULL X X
-fp ALIGNED X X
-fk ALIGNED X X
-N MIXED X X
-N ON X X
Modification Type:MinorLast Reviewed:11/2/2005
Keywords:kbsql2005engine kbtshoot kbinfo KB906649 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.