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 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.
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
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.
Tuning Options Not Supported by the dta Utility
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.