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 or the standalone Database 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:
Set the SQL server memory limit as follows:
- From the Windows desktop click Start | All Programs | Microsoft SQL Server and select Microsoft SQL Server Management Studio. Microsoft SQL Server Management Studio opens.
- Log on as an Administrator.
- Right-click on the SQL server name and select Properties from the context menu. The Server Properties dialog opens.
-
Click Memory.
The Memory page opens.
- In the Maximum server memory setting, enter your SQL server memory limit in MB.
- Click OK.
A restart of the server is not necessary, but recommended.