April 22, 2004 at 7:22 am
I was wondering if you are meant to periodically rebuild / de-fragment the indexes on the master and msdb databases?
It's just we all do it on our user databases but i've never seen anything with regards to whether you're meant to do it on the system databases ( I know its probably in BOL but I can't find it)
Ta
Dave
April 22, 2004 at 8:13 am
AFAIK sql server is pretty good at keeping statistics relating to indexes etc. There is a wealth of information relating to the optimisation of sql server in various places (BOL, MSDN, the web etc). There are also maintenance jobs that can be run periodically to update stats etc.
cheers
dbgeezer
April 22, 2004 at 8:17 am
I've got jobs that rebuild the indexes on my user databases and a script for defragmenting them when they become too defragmented but it just whether this should be extended to cover the system databases.
April 22, 2004 at 8:39 am
it can't do any harm if it is out of hours - i used to do all databases over night
cheers
dbgeezer
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply