Can someone please give me a link to a tutorial or give me a few step by step insights into how to use the Database Engine Tuning Advisor?
Say I have a query I want to analyze. So I open the database, open a new query window, paste in the query, right click and say "Analyze query in Database Engine Tuning Advisor." I put in my credentials and log in.
Now here I am. I want to run that query and have it analyzed. But I don't know how to do that.
What do I do next?