Maintance plan Order

Question

Maintance plan Order

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

ps. One Orange Chip Points: 29423 More actions · Answer 1

normally you reorganize your indexes if fragmentation is between 5-30% and rebuild if fragmentation>30%

Ref : http://technet.microsoft.com/en-us/library/ms189858.aspx%5B/url%5D

I suggest you keep reorganizing as a part of maintenance plans and rebuilding on ad-hoc basis when fragmentation exceeds 30% as rebuilding is more resource intensive..

Also i think online index rebuilding is available only in enterprise edition (someone pls correct if i'm wrong here).

Pradeep Singh

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 2

In 2005, online rebuilds are enterprise only;

http://msdn.microsoft.com/en-us/library/cc966402.aspx

ps. One Orange Chip Points: 29423 More actions · Answer 3

Thanks Steve for the link. Doc says it's available only in enterprise edition in sql 2k5. I somehow couldn't find it at that time.:-D

Pradeep Singh

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 4

I had to look around and check as well. They keep changing these things!

Halcyon Ten Centuries Points: 1331 More actions · Answer 5

However, if I am talking about system database maintenance - shall I also rebuild and reorganize indexes and update statistics?

Please note that I do not have a lot of the jobs/backups running and all the data is being held for 6 weeks only.

Thank you