Bookshelf Home | Contents | Index | Search | PDF |
Siebel Server Installation Guide for Microsoft Windows > Creating the Microsoft SQL Server Database > Ongoing Microsoft SQL Server Database Administration >
Monitoring Fragmentation
Use the following Microsoft SQL Server command to determine whether a clustered index and its associated tables are highly fragmented:
DBCC SHOWCONTIG
If this command returns a value for scan density of less than 60%, use the following Microsoft SQL Server command to defragment tables without having to drop indexes:
DBCC INDEXDEFRAG
You may want to use this option periodically against the entire database.
If
DBCC SHOWCONTIG
returns a value of less than 30%, or when you suspect that indexes might be interleaved on the disk, consider rebuilding the index, using:DBCC DBREINDEX
You have completed configuring your Microsoft SQL Server database. Proceed to Installing the Siebel Database Server for Microsoft SQL Server. For more information about monitoring fragmentation, see the appropriate Microsoft SQL Server documentation.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Server Installation Guide for Microsoft Windows Published: 25 June 2003 |