Installing and Configuring Mart › Prepare Your DBMS Environment › Tasks to Create a Microsoft SQL Server DBMS

Tasks to Create a Microsoft SQL Server DBMS

The following tasks must be performed by the DBA and system administrator responsible for installing CA ERwin Data Modeler Workgroup Edition on a Microsoft SQL Server DBMS:

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

   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