Simple XML Input File Sample (DTA)

Copy and paste this sample of a simple XML input file to use for tuning workloads into your favorite XML editor or text editor. Then replace the values specified for the Server, Database, Schema, Table, Workload, and TuningOptions elements with those for your specific tuning session. For more information about the attributes and child elements that you can use with these elements, see the XML Input File Reference (DTA). The following sample uses only a subset of available attribute and child element options.

Code

<?xml version="1.0" encoding="utf-16" ?>
<DTAXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="https://schemas.microsoft.com/sqlserver/2004/07/dta">
  <DTAInput>
    <Server>
      <Name>MyServerName</Name>
<!-- To tune multiplate databases, list them and their associated tables in the following section. -->
      <Database>
        <Name>MyDatabaseName</Name>
        <Schema>
          <Name>MyDatabaseSchemaName</Name>
<!-- You can list as many tables as necessary in the following section. -->
          <Table>
            <Name>MyTableName1</Name>
          </Table>
          <Table>
            <Name>MyTableName2</Name>
          </Table>
        </Schema>
      </Database>
    </Server>
    <Workload>
<!-- The following element specifies a workload file, which can be a trace file or a Transact-SQL script file. -->
      <File>c:\PathToYourWorkloadFile</File>
    </Workload>
    <TuningOptions>
      <TuningTimeInMin>60</TuningTimeInMin>
      <FeatureSet>IDX_IV</FeatureSet>
      <Partitioning>NONE</Partitioning>
      <KeepExisting>NONE</KeepExisting>
      <OnlineIndexOperation>OFF</OnlineIndexOperation>
    </TuningOptions>
  </DTAInput>
</DTAXML>

See Also

Reference

XML Input File Reference (DTA)

Other Resources

How to: Create XML Input Files
How to: Tune a Database by Using the dta Utility
How to: Perform Exploratory Analysis

Help and Information

Getting SQL Server 2005 Assistance