Database Maintenance for SharePoint

  • Article

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