Folks, I used Sql Server Profiler and let it run for a while. I now have a fairly large (8GB) trace file. I'm only interested in getting the SQL statements besides the duration for Sql:BatchCompleted events. This can either be in the form of a table or exported to Excel. Basically I want to sort on Duration and see which queries are taking the longest. So ideal format is:
Sql Statment, Duration
Is there a way to do this without importing the whole trace file? Could you provide specific instructions on how to accomplish this?