Go to documentation repository
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.
The setting parameters of the settings panel MSDE (MS SQL) configuration section are described in the table.
№ | 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. | |||
| 4 | The SQL database size fieldThe 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 | Serverserver | Positive real number with amount | precision − twoprecision—two decimals | -NA | Depends on the capacity | of storage where the database is.of the storage where databases are stored |