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

Intergraph Smart Engineering Manager Web API Installation and Configuration

Language
English
Product
Intergraph Smart Engineering Manager
Subproduct
Web API
Search by Category
Installation & Upgrade
Smart Engineering Manager Web Version
4.0

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.

    SHARED Tip 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.