July 1, 2008 at 5:45 am
Hello,
I hope somebody can give me an ideal really, of how brutal the tuning advisor can be on resources. I have a DB of about 130mb, and I really want to run the tuning advisor on it to see what happens and what it recommends, the machine is beefy to say the least, but it also runs exchange and is a file server. Do you think I might get away with it or just play it safe and do it out of hours? The DB and logs are on their own physical disks if it make any difference.
I would have thought that being as the DB is only 130mb, it might be over in no time.
Kind Regards,
D.
July 1, 2008 at 5:48 am
I would strongly recommend that you run the tuning advisor against a copy of your production databse, not your production database itself.
Take a profile of the prod server to serve as a workload, then restore a backup to another server and let the tuning advisor work against that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 1, 2008 at 6:03 am
Hello Gail,
Thanks for getting back, I should have pointed out that it is in fact a copy of the production database that have restored to the server. Also the production DB is on another machine. Sorry, I should have mentioned that originally.
Regards,
D.
July 1, 2008 at 6:08 am
But the server in question is running production exchange and file server?
Do you not have a development server somewhere?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 1, 2008 at 7:08 am
ah see what you mean, yes we have a development server, but it is somewhat underpowered and runs SQL 2000 whereas I really want to run it on SQL 2005, where it also needs to be tested on. Perhaps I should run the tuning advisor at 3 or 4 in the morning or something. I've never used it before, presumably it can be scheduled?
Regards,
D.
July 1, 2008 at 7:14 am
Not that I'm aware of.
The power of the machine won't affect the results of the tuning advisor. Only the volumnes of data and the workload trace affect that.
The SQL versions are a problem though.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 1, 2008 at 7:37 am
Hi Gail,
I have just been looking at the online tutorial on the tuning advisor, I think I am going to have a read up and go from there.
Thank you for all your replies, have a good one.
Kind Regards,
D.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply