sp_sqltrace is open-source tool written by Lee Tudor which is an excellent tool when you to find out why a specific process is slow, particularly when it's running loops. It's also very powerful when you want to look at a single plan from a batch that runs hundreds of statements. You can even use it as a statement debugger.