Install and Configure a SQL Server Mart › How to Install and Configure a SQL Server Mart › Create a SQL Server Database

Create a SQL Server Database

If you are a DBA or a system administrator responsible for installing the software on a Microsoft SQL Server database management system, perform the following tasks:

1. Use a graphical user interface (GUI) tool, ISQL (all versions), SQL Administrator, or Enterprise Manager to create the Mart database. If a GUI tool is not available, you can use ISQL to type in the appropriate commands manually.

   Note: CA ERwin Data Modeler does not support creating a database in a Server Cluster environment.

   Your database should meet the following criteria:

   • The initial size of the database file should be set to 60 MB.
   • The initial size of the transaction log file should be set to 50 MB.
   • Set the maximum file size to unrestricted file growth for both files (recommended, but not required).
   • Increase the Set Auto grow file by 10 percent (recommended, but not required).

   The new database is owned by the user who created it.

   Set the Truncate Log on Checkpoint option and have the server generate checkpoints frequently. By selecting this option, the log is emptied periodically and should not fill up and cause rollbacks.

   Note: For best performance ensure that separate devices are used to store the data and the transaction log.

2. Verify tempdb size.

   Significant temporary space is required for installation and use. The temporary segments need at least 16 MB of available space. You should also increase available space as the number of concurrent users increase.

Back to Top