[dba-SQLServer] How To: Running Database Engine Tuning Advisor to analyse the query from a query window

Salakhetdinov Shamil mcp2004 at mail.ru
Thu Sep 10 02:15:09 CDT 2015


 Hi All --

Busy here with an urgent work so I'm asking maybe an easy question, but no time for intensive googling - and you may know the answer from your everyday experience, and I have no experience with the subject tool:

I somehow "automagically" (Tools->Database Engine Tuning Adviser->... ???) got the subject tool to analyze the results of a query from SQL Server Management Studio query window (or a whole current database? - the database is small and query uses a good half part of the main production tables of this database), but when I have tried to run the subject tool against another query window it started to look for db connection, I have provided it no problem, but then all "magic" disappeared - it needs to provide some more info to start analysis and I don't know how to "give it" the current query window to work on.... 

Question: How can I "ask" this tool to analyze the current query window?

Thank you.

-- 
Салахетдинов Шамиль


More information about the dba-SQLServer mailing list