Database engine tuning advisor


The database engine tuning advisor is a computer software 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 enabled online or offline tuning.