Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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: