Sql Server Database Engine Tuning Advisor : funzionalità non supportate
Il Database Engine Tuning Advisor può essere utilizzato per ottimizzare i database di Sql Server. Non tutte le funzionalità sono però supportate a seconda della versione di Sql utilizzata. Di seguito trovate la tabella e il link al documento che ne descrive i dettagli.
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.
Riferimenti utili: