The rebuild index task in a maintenance plan allows you to choose
system databases. I noticed that some of the system database tables
do have indexes. Should you run this task on system databases
within the maintenance plan. Is it necessary and will it do anything.
Also will it cause any issue with these databases. What about reorganize
index task or update statistics will this cause any issues and should it be run.
Lastly can you shrink a system database. For instance should you run the
shrink database task. Any help would be greatly appreciated thank you.i have never even thought about doing this. are you experiencing performance problems related to the system databases? do you have index fragmentation in the system databases? if not leave well enough alone. if it ain't broke...
if you do this, try it on your local sql install or a dev machine first and do a sanity check.|||This was an inherited system and there was a maintenance plan that did
all of these things. I was a little bit skeptical myself. I was just wondering
if anybody has tried some of these things and what it would do.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment