Trace database query

I need an advice. I would need to trace one particular procedure in SQL Server. It happens to me that one procedure ends up with a timeout and I need to find out which select, insert or update this happens. I want to ask, I don't know much about SQL profiler, so my question is, is it really the best tool for my problem? Can I look at a certain procedure in a different way? Is there a better tool?