How would you use a SQL profiler to optimize the database?
Utilisateur anonyme
Look for bottlenecks and opportunities to index data, use views, or other things based on the trace. (From this question, I'm not sure the delineation between DBA and Software Dev when it comes to performance tuning.)