Installation and Configuration › How to 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 MM 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 MM 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. Add users.

   For users to access the mart you must either add existing logins as users to the database or create new logins and add them as users of the database. A login is an entity permitted to connect to the database server; a user gives a login the right to use a particular database. If you use Windows user names and passwords to secure database access (Windows Authentication), you must add the Windows users to your DBMS.

3. Check 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.