Database Engine Tuning Advisor

The Database Engine Tuning Advisor (DETA) is a tool for Microsoft SQL Server that enables database tuning. It can improve performance for query by tuning the indexes, creating, modifying and deleting partition and or indexes.

It can be configured to be enabled for online or offline tuning.