Database engine tuning advisor

From Wikipedia, the free encyclopedia
Jump to: navigation, search

The database engine tuning advisor (DETA) 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.