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 |