SQL Server Performance Forum – Threads Archive
does DTA really apply statements to the tuned db?Hi all, I am wondering if the new tuning tool Database Tuning Advisor really apply the statements to the production database? I know the replay does, so although I am fairly certain that DTA does not, I am not 100% sure. Thanks
No it does not apply until you replay. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.