rajemessage 14195 (12/20/2013)
but if possible please write a word for use of (tsql vs trace) in Database Engine Tuning Advisor .
I answered that one
You need a representative workload for DTA to be even remotely accurate, so that's a trace file (or table, makes no difference) that recorded as much of a business cycle as possible and feasible, or a representative sample thereof.
Finally i will check thing like query plan,dmo,dta.
I'm not sure how the Database Management Objects (DMO), which is a programming interface for writing SQL Server management apps is going to help you identify indexes.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass