Using Profiler to Identify Poorly Performing SQL Server Queries
http://www.sql-server-performance.com/sql_server_performance_audit10.asp

This article covers the basics to capturing SQL Traces that assist in finding the long-running stored procedures that run on a SQL box. Not very in depth but a good reference for making sure you have everything you need.


Jeffrey Kelly
http://sailwhatcom.com