Configure SQL Server Database Server - Intergraph Smart Engineering Manager - 3.0 - 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. Select Start > Microsoft SQL Server > SQL Server Management Studio.

2. On the Connect to Server dialog, 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. Enter a login name.

   5. Enter 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. Select 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, select 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.