Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools > Guidelines for Configuring the RDBMS > Guidelines for Ongoing MS SQL Server Administration >

Monitoring MS SQL Server Database 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 more information about monitoring fragmentation, see the appropriate Microsoft SQL Server documentation.