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