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.

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:

http://msdn.microsoft.com/en-us/library/ms345360.aspx