If you're interested, I've posted an article on http://www.sqlservernation.com that might complement the comments posted by Brad. 🙂

http://sqlservernation.com/blogs/tipweek/archive/2009/05/27/introduction-to-sql-server-profiler.aspx

Tim Chapman

SQL Server MVP