You can use the resource monitor to monitor resource usage in the database and identify expensive SQL statements.
Database Administration in CCMS, Resource Monitor
Database Studio, Analyzing the Performance of SQL Statements