So I use the SQL Profiler to see the queries, then...
# social
n
So I use the SQL Profiler to see the queries, then use the query plans in SSMS to look for missing indexes