Setting the SQL server memory limit
The SQL server depends on memory to cache information from databases on disk for fast access. If more data exists on disk than can be held in memory, the SQL server performance will degrade.
To avoid low memory issues on the GV STRATUS Core server, the memory that should be assigned to SQL server depends on the memory size of the physical device.
Grass Valley recommends the setting of SQL server memory limit according to the table below:
Physical Memory | SQL server memory limit | Approximate number of assets supported |
---|---|---|
12 GB | 5 GB | 200,000 – 350,000 |
16 GB | 8 GB | 320,000 – 560,000 |
32 GB | 18 GB | 720,000 – 1,260,000 |
48 GB | 32 GB | 1,280,000 – 2,240,000 |
64 GB | 46 GB | 1,900,000 – 3,360,000 |
Set the SQL server memory limit as follows:
A restart of the server is not necessary, but recommended.