Automation task for the Database tuning advisor

  • Hi,

    i am trying to implementing trace file in database tuning adviser and after loading that it will give recommendations for the sql server.

    this is manual process.i am trying to implement in automation task by scripting

    i will give server name, database name, trace file as inputs for scripts.

    then it will tune the database and give the recommendations....

    is it possible through script...

    can any one help me on this by designing the script..please

  • You can run DTA from the command line (bat file). Look in Books Online for Database Engine Tuning Advisor [SQL Server], command prompt


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

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