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