Jaa


Unsupported Tuning Options

New: 5 December 2005

Database Engine Tuning Advisor graphical user interface (GUI) and the dta utility can be used to tune databases only on the Standard, Enterprise, Developer, and Enterprise Evaluation editions of SQL Server 2005 and SQL Server 2000. However, tuning options involving indexed views, partitioning, and generating recommendations online are not supported on the SQL Server 2005 Standard Edition. In addition, tuning options involving partitioning and generating online recommendations are not supported by any edition of SQL Server 2000, and options involving indexed views are not supported by SQL Server 2000 Standard Edition. These limitations are discussed in greater detail below.

Note

Unless otherwise specified, the information in this topic applies to both 32-bit and 64-bit versions of SQL Server.

Tuning Options Not Supported by Database Engine Tuning Advisor GUI

The following table lists the unsupported options in detail for the Database Engine Tuning Advisor GUI.

Option SQL Server 2005 and SQL Server 2000 Standard Editions SQL Server 2000 Enterprise, Developer, and Enterprise Evaluation Editions

Indexes and indexed views 1

Not supported

Supported

Indexed views 1

Not supported

Supported

Full partitioning

Not supported

Not supported

Aligned partitioning

Not supported

Not supported

Keep aligned partitioning

Not supported

Not supported

Generate online recommendations where possible

Not supported

Not supported

Generate only online recommendations

Not supported

Not supported

1. These options are disabled in the GUI.

Tuning Options Not Supported by the dta Utility

The following table lists the unsupported options in detail for the dta command prompt utility.

Option SQL Server 2005 and SQL Server 2000 Standard Editions SQL Server 2000 Enterprise, Developer, and Enterprise Evaluation Editions

-fa IDX_IV

Not supported

Supported

-fa IV

Not supported

Supported

-fp FULL

Not supported

Not supported

-fp ALIGNED

Not supported

Not supported

-fk ALIGNED

Not supported

Not supported

-N MIXED

Not supported

Not supported

-N ON

Not supported

Not supported

See Also

Other Resources

Available Tuning Options

Help and Information

Getting SQL Server 2005 Assistance