There are a couple of good articles about SQL tracing in the
MSDN SQL Server Developer Center pulled from SQL Server
Professional magazine.
Trace-scrubbing Tools and
OpenSQLTrace: Automated Trace Processing and Analysis System
discuss how to trace, scrub, and analyse data about the
transactions occurring in SQL to identify possibly troublesome
operations.