Go to documentation repository
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 Axxon PSIM database | - | - | - |
3 | The Maximum memory usage (MB) indicator | Enter the value in the field | Sets the space of RAM in MB for SQL Server operation | MB | 4096 | Depends on full space of RAM. |
4 | The SQL database size field | Automatically | Displays the current size of all MS SQL databases on the Server | Positive real number with amount precision − two decimals | - | Depends on the capacity of storage where the database is. |