February 27, 2008 at 10:22 am
Hi once again. I originally posted under 'Administering' but for some reason my post does not appear to be there? So I apologise if this duplicates my question.
I am relatively new to SQL and was hoping for some insight into 'General SQL Administration' (Maintenance Plans).
The database in question will be around (60GB). I was looking through the maintenance plan wizard at the various options.
When would it be advised to set a plan to:
A: Check Database Integrity
B: Reorganize Index
C: Rebuild Index
D: Update Statistics
What schedule might be appropriate (Weekly / Monthly). I appreciate that the correct answer will vary depending on individual circumstances, I am looking for a general rule. An earlier post advised NOT to shrink database (so I will leave that one alone!!).
Finally can you advise regards the appropriate use of the 'Database Engine Tuning Advisor'. How should this tool be used effectively? Will this make recommendations regards indexes (rebuilding).
Advice from you experts from real world experiences would be very much appreciated.
Regards,
Phil
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
February 27, 2008 at 10:30 am
Do a bi-weekly schedule for this. and in non production week end nights should be the best tim for these tasks.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 27, 2008 at 1:10 pm
This is a duplicate post, apologies.
Please DO NOT comment on this post as I posted here:
http://www.sqlservercentral.com/Forums/Topic461018-146-1.aspx
Regards,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply