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.


 Siebel Server Installation Guide for Microsoft Windows 
 Published: 25 June 2003