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 command line utilityVersion 11.0.2100.60 ((SQL11_RTM).120210-1846 ...