Finding Problem Queries with SQL Profiler - Professional SQL Server 2005 Performance Tuning - page 122

Click the first entry. You see DTA made a suggestion to add a clustered index for the people table
(see Figure 5-24).
Figure 5-24
After carefully studying the logic in the stored procedure marriage , you found that all index suggestions
are valid. After implementing new indexes, the performance increases dramatically.
Case Summary
In this case scenario, you used Profiler to identify long-running queries directly; long-running queries
were sorted by Profiler in ascending order. After long-running queries were identified, you demonstrated
that the SQL DTA tool could provide valuable information for tuning opportunities.
Tracing Costly Queries by Using Profiler
to Generate Server-Side Trace Code
Proactive database administrators want to keep track of costly database queries in order to analyze them.
Costly queries have symptoms of high CPU and I/O utilizations.