tuning advisor in sql server

Question

Hi all When i run tuning advisor in sql server. It gives some statistics .Is it useful??? How to use this?

Jaganathan Bantheswaran · Answer

Hi Tuning Advisor in SQL Server is a tool to tune your DB for your Environment. In a DTA gives you the statistics that will enhance query performance; like Adding indexes (clustered nonclustered and indexed views) Adding partitioning Adding statistics including multi-column statistics which are not created automatically even when you have the AUTO_CREATE_STATISTICS database option set to ON For more read these How to Use SQL Server Profiler and Tuning Advisor Performance Tuning High Level- SQL SERVER How to Use the SQL Server 2005 Tuning Advisor DATABASE TUNING - Maintenance Plan