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

[Arthur Fuller]

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

Arthur

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

>  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
>
>


-- 
Arthur