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

Arthur Fuller fuller.artful at gmail.com
Sat Sep 12 05:52:16 CDT 2015

As I recall, it's just an option you can choose on the Query menu.


On Thu, Sep 10, 2015 at 3:15 AM, Salakhetdinov Shamil <mcp2004 at mail.ru>

>  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.
> --
> Салахетдинов Шамиль
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com


More information about the dba-SQLServer mailing list