As far as I know, the Database Tuning Advisor works off of a Profiler trace (or a workload) you ran during peak business hours. And, AFAIK, it doesn't actually alter stored procedures. Mind you, it's been a long time since I actually ran it, but I thought it was only supposed to change stuff if you told it to, after it gave you the recommendations.
Anyone else have experience with this one?
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"