Database Tuning Advisor - T-SQL

The Database Tuning Advisor (DTA) can analyze SQL Server scripts or SQL Server Profiler traces to evaluate the effective use of indexes. It can also be used to get recommendations for building new indexes, indexed views, or for creating physical table partitions. The DTA is a useful tool for database administrators and is described in detail in the book Beginning SQL Server 2005 Administration (Wrox).

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

T-SQL Topics