To get helpful output from dbcc traceon(302), be sure that your tests cause the optimizer to make the same decisions that it would make while optimizing queries in your application.
You must supply the same parameters and values to your stored procedures or where clauses.
If the application uses cursors, use cursors in your tuning work
If you are using stored procedures, make sure that they are actually being optimized during the trial by executing them with recompile.
