Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Overview of Siebel Data Warehouse > Siebel Data Warehouse Requirements >

SQL Server-Specific Database Requirements

---

SQL Server Databases should be created with ANSI NULL option checked.

NOTE:  SQL Server users must make sure the SQL Server client software is installed.

To set the ANSI NULL option

In Enterprise Manager, select Database.
Right-click and choose Database properties.
Click the Options tab and check the box for ANSI NULL default.

In a SQL Server 2000 environment, when loading Analytics tables with international data, or loading more than one language, modify the DB Library Options setting.

To modify the DB Library Options setting

In the program menu Microsoft SQL Server, launch the Client Network utilities.
Select the DB Library Options tab.
Uncheck the option Automatic ANSI to OEM.

NOTE:  SQL Server 2000 automatically tunes many of the server configuration options, therefore an administrator is required to do little, if any, tuning. Although these configuration options can be modified, the general recommendation is that these options be left at their default values, allowing SQL Server to automatically tune itself based on run-time conditions.

To create the user accounts that access the database

Assign these user accounts SSE_ROLE.
Set these accounts to run the DDL commands (that is, set permissions to create tables).

If necessary, the following components can be configured to optimize performance:

SQL Server memory: Make sure adequate memory is available.
Transaction logs and TempDB: Reside on a separate disk from those used by database data.
Full load: Full Recovery model for the database.
Incremental load: Change from Full to Bulk-Logged Recovery model.

Bookshelf Home | Contents | Index | Search | PDF