Here is a free profiler kind-of tool for if you're using SQL Express:

http://code.google.com/p/sqlexpressprofiler/downloads/list