Database engine tuning advisor
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.
This article is issued from Wikipedia - version of the 10/22/2014. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.