Microsoft SQL Server 2008 R2 Unleashed- P237:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 2324 CHAPTER 55 Configuring Tuning and Optimizing SQL Server Options TAB_ACCESS Table access report. COL_ACCESS Column access report. By default all reports are generated. -ox OutputXmlFileName Indicates the name of the XML file to which the application writes output. -F Permits Database Engine Tuning Advisor to overwrite existing output files specified using any of the o options . -ID SessionID Specifies the ID of a session for which Database Engine Tuning Advisor should generate results. -ix InputXmlFileName Indicates the name of the XML file that specifies a user configuration that is a user-specified configuration . Note that command-line options take precedence in the event that duplicate parameters are found in the file. -A TuningTime Indicates the maximum amount of time in minutes that Database Engine Tuning Advisor will spend tuning. In general longer times produce higher-quality recommendations. When 0 is specified as a value the tuning time is unlimited. When a value is not specified the tuning time is limited to 8 hours. -n NumberOfEvents Specifies the number of events to tune. -m MinimumImprovement Specifies that Database Engine Tuning Advisor should offer only recommendations for which the estimated improvement meets or exceeds the supplied value in percentages . If no value is specified recommendations are provided regardless of the degree of improvement. -fa PhysicalDesignStructure Specifies the physical design structures for which Database Engine Tuning Advisor should consider proposing new recommendations. You select one of the available options IDX_IV Clustered and nonclustered indexes and indexed views. IDX Clustered and nonclustered indexes. IV Indexed views. NCL_IDX Nonclustered indexes. When no option is specified IDX is used. -fp PartitionStrategy Specifies the partitioning support requested that Database Engine Tuning Advisor should consider adding. You select one of the available options NONE No partitioning strategies. FULL Full .
