rajemessage 14195 (12/20/2013)
Thank u sirs ,I will read those topics again from the books.
but if possible please write a word for use of (tsql vs trace) in Database Engine Tuning Advisor .
Finally i will check thing like query plan,dmo,dta.
If any thing else exist please tel me.
yours sincerely
You can run a single statement through the Database Tuning Advisor. It will attempt to suggest indexes and statistics that my result in improvements in performance. But it's absolutely one at a time. Running the output of trace through the Database Engine Tuning Advisor results in lots of queries being checked. That's the difference.
Do not trust the output of the Database Tuning Advisor. It's wrong a lot of the time. Very wrong.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning