Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

How does DTA make an index recommendation? What is the technology behind that? If we can use same on our side then we can shorten the whole process of Tuning recommendation:

  1. creating trace file using SQL Profiler
  2. Use that trace file in DTA
  3. Then look for recommendations
  4. Follow the recommendations & see the results in the Query Execution Plan.

I just wanted to know if it is there any way to create a predictable index.

share|improve this question
    
Worth mentioning Don't just blindly create those "missing" indexes! (sqlperformance.com/2013/06/t-sql-queries/missing-index) by Aaron Bertrand. Use DTA with caution !! –  Kin Sep 20 '13 at 17:14

1 Answer 1

How does DTA make an index recommendation? What is the technology behind that?

You can find the answers in a detailed paper on the Database Tuning Advisor published by Microsoft (click on the PDF link on that page to download the complete document).

The missing index DMVs are not a good substitute for a full DTA analysis. The DMVs show only very limited information opportunistically gathered during query optimization. DTA performs a much more thorough analysis, though you should not automatically create every index it suggests. You need to assess each recommendation on its merits.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.