Database administrators in enterprises today grappling the hard duty of determining an pertinent fleshly organisation that consists of divided tables, indexes, and indexed views and that both optimizes computer action and is cushy to manage.
Database Engine Tuning Advisor (DTA) in Microsoft SQL Server 2005 crapper support in this task. Given a workload of SQL queries and updates, DTA recommends an pertinent fleshly design, and generates a playscript to compel the advisable fleshly design.
For more modern database administrators, DTA exposes a coercive execution to action economical preliminary what-if psychotherapy of assorted fleshly organisation alternatives. DTA crapper be utilised against both SQL Server 2005 and SQL Server 2000.
http://freeprogrammingebooks.com/database-engine-tuning-advisor-dta-in-sql-server-2005/
Tags: Programming