Microsoft® SQL Server 2012 Unleashed

The dta Command-Line Utility

dta is the command-line version of the graphical Database Engine Tuning Advisor. Both the command-line utility and graphical tool provide performance recommendations based on the workload provided to them. The syntax for dta is as follows:

Click here to view code image

       Dta [ -? ] |[     [ -S server_name[ \instance ] ]     {         { -U login_id [-P password ] }         | –E             }         { -D database_name [ ,...n ] }             [-d database_name ]             [ -Tl table_list | -Tf table_list_file ]         { -if workload_file | -it workload_trace_table_name }         { -s session_name | -ID session_ID }             [ -F ]                     [ -of output_script_file_name ]                     [ ...