Siebel Installation Guide for Microsoft Windows > Configuring the RDBMS > Configuring a Microsoft SQL Server Database for Siebel Business Applications >

Guidelines for Ongoing Microsoft SQL Server Administration

After you have installed your Siebel Business Applications on Microsoft SQL Server, some other tasks must be performed on a periodic basis. These are in addition to such common database administration tasks as monitoring and backing up.

This topic is part of Configuring a Microsoft SQL Server Database for Siebel Business Applications.

Updating Microsoft SQL Server Statistics

The cost-based optimizer in Microsoft SQL Server uses statistics about tables and indexes to compute the most efficient access plans. When the statistics become inaccurate, as can happen for tables with high insertion or deletion rates and for their associated indexes, the performance of database operations can degrade dramatically.

Perform a full scan of all of the tables under the following circumstances, even if you implement automatic statistics updating:

• After installing the Siebel database and before starting Siebel Business Applications.
• After running concurrent Siebel EIM threads.
• After inserting, updating, or deleting large amounts of data.

Using Query Analyzer, perform a full scan of each table by entering the following command:

update statistics TableName with full scan

It is strongly recommended that you enable the automatic creation and updating of statistics, by using the parameters documented in Configuring a Microsoft SQL Server Database for Siebel Business Applications. This way, statistics are automatically kept up to date and the administrative overhead of updating them manually is removed.

If you do not implement automatic statistics updating, then periodically perform the full scan described in this topic.

Managing Microsoft SQL Server 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%, then use the following Microsoft SQL Server command to defragment tables without having to drop indexes:

DBCC INDEXDEFRAG

You might want to use this option periodically against the entire database.

If DBCC SHOWCONTIG returns a value of less than 30%, or if you suspect that indexes might be interleaved on the disk, then consider rebuilding the index, by using the following command:

DBCC DBREINDEX

For more information about monitoring fragmentation, see Microsoft SQL Server documentation.