Documentation for Intellect 4.10.4. Documentation for other versions of Intellect is available too.

Previous page The Settings panel of the Distributed configuration section  The Settings panel of the Video subsystem section Next page


The MSDE (MS SQL) configuration section is designed for setting the limits of RAM space for MS SQL Server operation with databases of SQL format. This limitation enhances the performance of the system.

The settings panel for the MSDE (MS SQL) configuration section is shown in the figure.

The parameters of the settings panel are described in the table.

№

Parameter name

Field type

Description

Representation

Default value

Value range

1

The Select database button

Click the button

Opens the standard Data Link Properties dialog box for choosing the database of MS SQL format the RAM space for which is to be limited.

-

-

-

2

The Use current DB button

Click the button

Selects the main Intellect database

-

-

-

3

The Maximum memory usage (MB) indicator

Automatically

Displays the relative (red strip) and absolute (in MB) space of RAM for SQL Server operation

%, MB

-

Depends on full space of RAM; not more than 2048.

 

 

4

The Maximum memory usage (MB) slider

Set in the position

Specifies the required space of  RAM for SQL Server operation

-

Corresponds to the indicator’s state.

Depends on full space of RAM; not more than 2048.

If more memory is to be allocated to SQL server, then use SQL Server Management Studio – see Limiting memory usage by an MS SQL server.

 

5The SQL database size fieldAutomaticallyDisplays the current size of all MS SQL databases on the ServerPositive real number with amount precision - two decimals-Depends on the capacity of storage where the database is.
  • No labels