SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

Table Element for Schema (DTA)

SQL Server 2012

Specifies the table for tuning.

Copy 

<Schema>
...code removed here...
    <Table>...</Table>

Attribute

Description

NumberOfRows

Optional. Integer that allows you to simulate tables of different sizes.

Characteristic

Description

Data type and length

string, between 1 and 255 characters.

Default value

None.

Occurrence

Optional. List as many tables as appropriate for your workload.

If you do not specify a Table element, Database Engine Tuning Advisor will assume all tables on the specified database can be tuned.

For a usage example, see Server Element (DTA).

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.