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 only takes a minute to sign up.
Sign up to join this community
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:
I just wanted to know if it is there any way to create a predictable index.
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.
