The built in Database Engine Tuning Advisor makes it a lot easier to optimise performance and to allow fine tuning to your queries. Fine tuning is required for SQL databases on occasion.
There are three different ways to use the Database Engine Tuning Advisor: you can enter your script in the SQL Server Management Studio Query Editor window and fine tune it or you can create a workload file using the SQL Server Profiler and finally you can use the dta utility from a command prompt instead of the graphical user interface
The report will contain an analysis of implementing the recommendations such as table and column access statistics, disk usage of new indexes and expected performance improvements.
The tool fully supports XML input files.