Click to Rate and Give Feedback
TechNet
TechNet Library
Office
 Database maintenance for Office Sha...

  Switch on low bandwidth view
Database maintenance for Office SharePoint Server 2007 (white paper)

Updated: 2009-11-05

This white paper provides information and guidelines for maintaining the databases that host Microsoft SharePoint Products and Technologies data and configurations. It describes and provides examples of the database maintenance tasks that we recommend when using SharePoint Products and Technologies. It has been updated to refer to Microsoft SQL Server 2008.

Download this white paper as a Microsoft Office Word document (.doc) file.

Database Maintenance for SharePoint Products and Technologies

See Also

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
What about disc-level defrags      DeutschDelf   |   Edit   |   Show History
Hi - great whitepaper - thanks so much! One question is outstanding for me... how should one design a normal disc defrag around these items? Does it even make sense to run them? If so, how often and what else needs to be kept in mind when running defrag on a SQL server?
Tags What's this?: defrag (x) disk (x) Add a tag
Flag as ContentBug
If the database is growing on the disk you should defrag      dillons   |   Edit   |   Show History
Keep in mind the default autogrowth is 1mb.... this should be changed to something sensible like 10% to avoid a heavily fragmented disk.
Tags What's this?: Add a tag
Flag as ContentBug
Watch those autogrowth setting      Neil Hodgkinson - MSFT   |   Edit   |   Show History
Setting autogrowth to 10% is not the best idea. This will lead to a huge number of very small database file increments while the datafile is small but imagine now growing a 500GB database by 10%. That's a 50GB file growth and followed by zero initialization you have a performance hit right there.

Better to use autogrowth with a setting of say 100MB and proactively monitor the growth, adding more space if the growth patterns dictates a need for it.
Tags What's this?: Add a tag
Flag as ContentBug
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker