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