Post reply

where can we select a particular query to tune in DTA

  • March 31, 2008 at 8:02 pm

    #204980

    HI,

    where can we select a particular query to tune in DTA? I can see the options for workload trace file n trace table but I did not find the option to select a particular query to tune.

    But I read in bol that we can tune a particular query. could you please explain me how to do this?

    regards

    madhu

  • April 2, 2008 at 3:37 am

    #797069

    Hi,

    You have to open the query in Management Server. From there you can select option "Database Engine Tuning Advisor" from the menu "Tools". This will pars the query to the DTA.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • April 4, 2008 at 6:25 am

    #798369

    Sorry, my mistake...

    In SSMS you open the query. There you have to right click the query and then choose "analyse query in DTA"

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • April 4, 2008 at 1:58 pm

    #798673

    ... or save the query in a file, and specify file with full path in the DTA.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply