DTA is also available in a batch mode so that you don’t have to be around to run it online (because doing so can often take hours if you have a large workload to analyze). In addition, this mode enables you to run the same tests over and over, with varying options.
You can easily view DTA command-line options by using the help option of the command itself (that is, the
-? option). You simply run this option at the command line and have its output piped into a file for viewing in Notepad (or another editor):
C:> DTA -? > dta.outMicrosoft (R) SQL Server Microsoft SQL Server Database Engine Tuning Advisor commandline utilityVersion 12.0.2000.8 ((SQL14_RTM).140220-1832 ...