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