Database Maintenance for SharePoint

Bill Baer’s white paper: Database Maintenance for SharePoint is now live. 

Table of Contents

• Check for and repair consistency errors by using DBCC CHECKDB 1
• About DBCC CHECKDB 1
• DBCC CHECKDB and performance 2
• Measure and reduce fragmentation 3
• Measure fragmentation in a SQL Server 2005 database (sys.dm_db_index_physical_stats) 4
• Measure fragmentation in a SQL Server 2000 database (DBCC SHOWCONTIG) 5
• Reducing Fragmentation for a Database 6
• Reducing fragmentation for a specific table and its indexes 9
• Using ALTER INDEX 9
• Fine tuning index performance by setting fill factor 10
• Shrinking data files 10
• Shrinking a database by using Transact-SQL commands 11
• Shrinking a database by using SQL Server 2005 Management Studio 12
• Creating SQL Server 2005 Maintenance Plans 13
• Configure a SQL Server 2005 Database Maintenance Plan 13
• Summary 22