Database Maintenance for SharePoint

Christophe Fiessinger's Blog

The latest news you need to know about Microsoft Enterprise Social & Project Portfolio Management

Database Maintenance for SharePoint

  • Comments 2

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
Leave a Comment
  • Please add 3 and 7 and type the answer here:
  • Post
Page 1 of 1 (2 items)