I have a task to locate and analyze most expensive queries in our database. I do it in 2 steps: 1. Using Management Studio I run a few Standard reports like ‘Performance - Top queries by Average CPU’ or ‘Performance - Top queries by Total CPU Time’ and then select a few top queries and try to analyze , after that I do 2. I use ‘Database Engine Tuning Adviser’
My preferred client is Toad for SQL.
My request: could someone please point me if Toad has option to run Standard reports … like Performance … and does Toad have a tool like Database Engine Tuning Adviser?