You can use the command monitor to analyze long-running SQL statements and identify bottlenecks.
Database Studio, Conducting an SQL Performance Analysis
Database Administration in CCMS, Command Monitor