Preliminary

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:

  1. From the Windows desktop click Start | All Programs | Microsoft SQL Server 2008 R2 and select Microsoft SQL Server Management Studio.
    Microsoft SQL Server Management Studio opens.
  2. Log on as Administrator.
  3. Right-click on the SQL server name and select Properties from the context menu.
    The Server Properties dialog opens.
  4. Click Memory.

    The Memory page opens.

  5. In the Maximum server memory setting, enter your SQL server memory limit in MB.
  6. Click OK.

A restart of the server is not necessary, but recommended.


Copyright © 2015 Grass Valley USA, LLC. All rights reserved. K2 Summit 9.5 generated_at_build_time_by_ABS_macro Preliminary
Other Topic Library Versions