SQL Profiler and Tuning Advisor for Reporting Services - what events should be selected?
- by chris
I've used the SQL Profiler to generate a trace file, and tuning advisor to take that trace file and provide some recommendations on db updates.
However, the SQL Profiler doesn't seem to track the queries when running against a Reporting Server, the profiler doesn't seem to be capturing any of the queries. I'm logging the defaults (SQL:BatchCompleted and Starting, RPC:completed, and Sessions - Existing Connections)
What events should I be capturing in SQL Profiler in order to run the tuning advisor?