July 30, 2010 at 5:13 am
Hi Everybody
When I tried to analyze one ad-hoc query with DTA, the DTA suggested nothing for creating a nonclustered index, but when I reviewed it's execution plan there was a message for missing ncl index and also verified through missing_index_detail DMV. How it was happened?. Why this contradiction?
To analyze 1 query or representative workload with DTA over LAN can be time intensive? If it takes time than what can I do?
Waiting
Rgds
Snehal Trivedi
January 12, 2011 at 11:46 am
can u elaborate ur query pls?
January 12, 2011 at 12:12 pm
DTA's not perfect. It's far from it. Take any recommendations as suggestions to start from, nothing more.
Yes, it takes time to do an analysis. Run it locally against a test database or be patient. Do not ever run DTA directly against a production DB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply