I order to check for the performance, I normally check for the disk reads and the milliseconds columns of the trace file.
These are the only 2 things I am looking so far. But would like to learn from you
1) How to interpret this trace file and understand all the sql statements shown in the trace file.
also at the end of the trace files, it shows totals for all recursive sql..
2) What are these recursive sql's and non-recursive sqls'