Article ID: 943345 - View products that this article applies to.
This article describes how to defragment the following Windows SharePoint Services 3.0 databases and Microsoft Office SharePoint Server 2007 databases:
When the following Microsoft SQL Server script runs, it measures the degree of fragmentation. The degree of fragmentation is defined as the number of blocks that are logically linear but physically nonlinear.
Depending on the extent of the SQL index fragmentation, either an online or an offline defragmentation occurs. An online defragmentation is defined as a defragmentation that does not take SQL locks and that defragments only leaf nodes. An offline defragmentation takes SQL locks and defragments all nodes.
If the percentage of fragmentation is less than 10 percent, no defragmentation occurs. If the degree of fragmentation is from 10 to 90 percent, an online defragmentation occurs. If the percentage of fragmentation is greater than 90 percent, an offline defragmentation occurs.
The following script tries to perform an online defragmentation first and then switches to offline defragmentation if offline defragmentation is required.
Important The following SQL Server stored procedure makes changes to Windows SharePoint Services 3.0 databases and to SharePoint Server 2007 databases. This script must be run exactly as specified in this article. Changes that you make to SharePoint Server 2007 databases must follow the Support guidelines that are specified in the following Microsoft Knowledge Base article:
841057Note We recommend that you host the SharePoint Server 2007 databases on a computer that is running SQL Server 2005. We recommend that you monitor the level of fragmentation before and after you run this script. We recommend that you schedule the script to run daily, weekly, or monthly, as appropriate for your situation.
(https://support.microsoft.com/kb/841057/ )Support for changes to the databases that are used by Office server products and by Windows SharePoint Services
Note After you install Windows SharePoint Services 3.0 SP2, you do not have to schedule this script to run for WSS databases (content and config) if you are running SQL 2005. This is because the scheduling and running of the script are included in SP2.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
932744For more information about how to perform database maintenance, see the following white paper:
(https://support.microsoft.com/kb/932744/ )Information about the Maintenance Plan Wizard in SQL Server 2005 and about tasks that administrators can perform against SharePoint databases
Database maintenance for Office SharePoint Server 2007
Article ID: 943345 - Last Review: June 21, 2014 - Revision: 7.0