Siebel Architect Interview on Database Server Best Practice

Siebel Architect Interview on Database Server Best Practice collected from various sources.

Ongoing regular maintenance
Establish maintenance windows to provide for conducting regular maintenance of the database. Without these opportunities to conduct maintenance, every task must be arranged separately with the user community and this can lead to user satisfaction issues.

Regular maintenance tasks would include defragmentation of database objects, creating new indexes. The database administrator should establish the program for regular maintenance in accordance with the requirements of the chosen database platform.

Performance testing & tuning
As with all aspects of the Siebel Enterprise, the database server must be the subject of an effective performance test. This must include the initial deployment as well as ongoing releases of new functionality, since these can have a significant impact on overall performance.

Conduct the testing and necessary tuning effort on a database instance that is representative of the production volume, especially data volumes and distribution. Conducting performance tests on a database that has minimal data will not provide an indication of the likely response times, resource requirements or query access plans.

When conducting performance tuning, consider testing new indexes on the database prior to defining them in Siebel Tools and also consider removing indexes. At all times the effect of the index changes must be evaluated for all areas of the application that access the affected data object. An index created to enhance one area of the application may in fact become and impediment to another area, depending how the data is accessed.

When migrating to the production environment, the Siebel Repository must contain the index definitions to be used. The migration process will build the indexes as they are defined in the Siebel Repository.

These are the questions expected for a Siebel Architect related to Siebel Database Server
#siebel