most sql books have chapters on profiler, I imagine there's a fair bit on technet/msdn. The sql performance tuning guide ( for sql 2000 ) has a good chapter on profiler.
The best way is to run some test traces. It all depends exactly what you want to capture and what for.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/