Friday, February 29, 2008

SQL Database Management for SharePoint

Bill Baer as a new whitepaper on database management for SharePoint. This is a must read for SharePoint admins.

Some highlights from the paper:

  • rebuild and reorganize (reindex) the clustered index is what defragments a table.
  • reindex = defragment
  • In order to avoid a huge performance hit, do not set maintenance plans to shink the db.
  • be prepared - maintenance plans can be long running processes.

1 comment:

  1. Wonderful post! We will be linking to this particularly great article on our site. Keep up the great writing.
    Oracle Training

    ReplyDelete