A couple of weeks back, RedGate/SimpleTalk contacted me for a short article about ANTS Profiler. I've been using it for sometime and has definitely been very useful so I won't think twice about recommending it.
Here's the link (below) and please do drop by to read it. Feel free to rate/comment
Using a profiler to speed (up) application Performance