Go to documentation repository
Previous page Next page
The MSDE (MS SQL) configuration section is designed for limiting the amount of RAM allocated for the MS SQL Server operation with databases of the SQL format. The limitation of RAM serves to enhance the system performance.
The settings panel for the MSDE (MS SQL) configuration section is shown in the figure.
The setting parameters of the MSDE (MS SQL) configuration section are described in the table.
№ | Parameter name | 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 window for selecting the database of the MS SQL format, the RAM amount for which you want to limit | NA | NA | NA |
2 | The Use current DB button | Click the button | Selects the main Axxon PSIM database | NA | NA | NA |
3 | The Maximum memory usage (MB) field | Enter the value in the field | Sets the space of RAM (in MB) allocated for the SQL server operation | MB | 4096 | Depends on the full space of RAM |
| 4 | The Current SQL DB size field | Automatically | Displays the size of the current MS SQL database on the server | Positive real number with amount precision—two decimals | NA | Depends on the capacity of the storage where the database is stored |
| 5 | The Total SQL DB size field | Automatically | Displays the current size of all MS SQL databases on the server | Positive real number with amount precision—two decimals | NA | Depends on the capacity of the storage where databases are stored |