Besides the Database Engine Tuning Advisor, you may want to have a look at the SQL Server Profiler.
Â