SQL Server Performance

dtm: how can I see recommendations

Discussion in 'ALL SQL SERVER QUESTIONS' started by ggolub, Apr 30, 2012.

  1. ggolub New Member

    Hello Forum,

    I test dta utility, command line:
    1 c:/working/binn/dta -F -D dev2 -E -S wl4243 -d dev2 -if t2.sql -s sess3 -of t1.out -m 20 -fa IDX -rl ALL

    my t2.sql:
    select top 1000 * from sourceprices_archive where isin_iix = 'SG1X13940751'

    This sql produces cl. index recommendation if ran through windows dta.
    If I run it through command line, it produces xml file and I do not see any new index recommendation.

    I also want to confirm that sql containing stored procs, temp. tables can not be processed through dta. At least I was not able to get clean run with dta if sql file contains execution of stored procs.
  2. Luis Martin Moderator

    Did you try the same using graphics version?
  3. ggolub New Member

    Thank you for your answer.
    Yes, I did try to use it.
    However I know the answer already. Need to use -of. If not, it won't display answer on counsel.
    It was the task to use command line version.

Share This Page