Post reply

Best practice for maintenance of the system databases

  • February 24, 2012 at 9:05 am

    #391644

    Hi All,

    I have recently learnt that reindexing entire is a bad practice. Both our SQL Servers we have were setup to reindex all database and system databases every night. I am now in the process of changing this so indexes are only rebuild when > 30% fragmented.

    My question is considered best practice for the maintenance system databases? Should they follow the same practice was the production database, or should something else be considered?

    Thanks

    Chris

  • February 24, 2012 at 9:22 am

    #1451473

    For system databases, backups and integrity checks for all three, also index rebuilds (as for a user database) for msdb. Neither master nor model should change enough to warrant reindexing.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 24, 2012 at 10:00 am

    #1451493

    Thanks for the reply. I will bear this in mind. 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

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