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