Monday, July 23, 2012

Database Tuning Advisor (DTA) Naming Conventions

DBAs are using Database Tuning Advisor a.k.a. DTA get recommendations for better performance of their databases.

Following is the index script created from the DTA.

image

in this index name is _dta_index_Contact_13_341576255__K1_4_6 and people might think that this does not have any standards, but it does have a standard.

You have four parts in this index naming.

image

A

This is straight forward. It is the object name or the table name.

B

13 is the database id for the Adventureworks.

image

C

Object Id of the contact.

image

D

Columns order of the key columns.

image

No comments:

Post a Comment