Database Engine Tuning Advisor

[manmaria]

If I have a job running using a store procedure and at the same time if I am trying to run the DB Tuning advisor, is it going to affect or stop the job?

Thanks,

 

[Catadmin]

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"

 

[mrdenny]

The tuning advisor doesn't change your procedures. It looks at what indexes are needed or not used based on the profiler workload that you have provided it.

If I remember correctly it can also analyze the database based on the stored procs and give index ideas without a workload file.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com