Configure SQL Server Database Server - Intergraph Smart Engineering Manager - 11 - Installation & Upgrade - Hexagon

This procedure explains how to configure the server to avoid running out of memory.

• By default, the server is configured to use unlimited memory.

• As a quick alternative to this procedure, you can stop and then restart the server.

• To implement this procedure, you must have DBA permissions.

1. Click Start > Programs > Microsoft SQL Server > SQL Server Management Studio.

2. On the Connect to Server dialog box, do the following:

   1. Beside Server type, select Database Engine.

   2. Beside Server name, select the name of your server or instance.

   3. Beside Authentication, select SQL Server Authentication.

   4. Type a login name.

   5. Type a strong password of at least 6 characters; this is a password that must include upper- and lower-case characters, numeric and non-alphanumeric characters.

      Passwords are case-sensitive.

   6. Click Connect.

3. In the Microsoft SQL Server Management Studio window, under the Object Explorer, select the server (top-level node), right-click, and on the shortcut menu, click Properties.

   

   If it is likely that a large number of users will connect to the database concurrently, select the Memory page and under Maximum server memory (in MB), set a higher value to avoid poor performance.

   

4. Select the Database Settings page and change the value of Default index fill factor to 80.