Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

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

Image Modified

The setting parameters of the settings panel MSDE (MS SQL) configuration section are described in the table.

The SQL database size field Server precision − two - of storage where the database is.

Parameter nameField type

Method for setting the parameter value

Description

Representation

Default value

Value range

1

The Select database button

Click the button

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

-

-

you want to limit

NA

NA

NA-

2

The Use current DB button

Click the button

Selects the main Axxon PSIM database database 

-NA-

NA

-NA

3

The Maximum memory usage (MB) indicator field

Enter the value in the field

Sets the space of RAM (in MB) allocated for the SQL Server server operation

MB

4096

Depends on the full space of RAM.

4The Current SQL DB size fieldAutomaticallyDisplays the size of the current MS SQL database on the serverPositive real number with amount precision—two decimalsNADepends on the capacity of the storage where the database is stored
5The Total SQL DB size fieldAutomaticallyDisplays the current size of all MS SQL databases on the serverPositive real number with amount precision—two decimalsNADepends on the capacity of the storage where databases are stored