Export (0) Print
Expand All

Unsupported Tuning Options

Database Engine Database Engine Tuning Advisor and the dta utility can be used to tune databases only on the Standard, Enterprise, Developer, and Enterprise Evaluation editions of SQL Server, starting with SQL Server 2000. However, not all tuning options are supported in every edition. These limitations are discussed in detail below.

NoteNote

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

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

Option

SQL Server 2008 Standard edition

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

Not supported

Supported

Indexed views 1

Not supported

Not supported

Supported

Include filtered indexes 2

Supported

Not supported

Not supported

Full partitioning

Not supported

Not supported

Not supported

Aligned partitioning

Not supported

Not supported

Not supported

Keep aligned partitioning

Not supported

Not supported

Not supported

Generate online recommendations where possible

Not supported

Not supported

Not supported

Generate only online recommendations

Not supported

Not supported

Not supported

1 These options are disabled in the user interface.

2 Filtered indexes are not supported on any edition before SQL Server 2008.

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

Option

SQL Server 2008 Standard edition

SQL Server 2005 and SQL Server 2000 Standard editions

SQL Server 2000 Enterprise, Developer, and Enterprise Evaluation editions

-fa IDX_IV

Not supported

Not supported

Supported

-fa IV

Not supported

Not supported

Supported

-fi 1

Supported

Not supported

Not supported

-fp FULL

Not supported

Not supported

Not supported

-fp ALIGNED

Not supported

Not supported

Not supported

-fk ALIGNED

Not supported

Not supported

Not supported

-N MIXED

Not supported

Not supported

Not supported

-N ON

Not supported

Not supported

Not supported

1 Filtered indexes are not supported on any editions prior to SQL Server 2008.

Community Additions

ADD
Show:
© 2014 Microsoft