August 10, 2010 at 12:09 pm
Do I need to rebuild indexes on system databases? Even if I may not need to, should I?
My old maintenance plan included rebuilding indexes on the system databases (through the maintenance plan tasks). It was mostly set up that way because I didn't see anything that told me not to, and it was really easy to set up. It apparently doesn't break anything if you do, because it was running like that for a long time.
Now we have multiple servers and I'm scripting out my maintenance tasks. I found a really comprehensive script for rebuilding indexes, but it explicitly excluded all of the system databases. Should I modify it to run on system databases as well? If so, I'd probably make it a parameter so I can run it for user and system databases seperate (the way my old plan was built). Is it worth the effort?
August 10, 2010 at 1:19 pm
You need not reindex system databases, unless you have really a big number of DML operations on them.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply