Configuring SQL server memory in Genetec Patroller™ - Genetec Patroller™ 6.6

Genetec Patroller™ Administrator Guide 6.6

Applies to
Genetec Patroller™ 6.6
Last updated
2022-04-22
Content type
Guides > Administrator guides
Language
English (United States)
Product
Genetec Patroller™
Version
6.6

Genetec Patroller™ Install Shield configures the memory correctly. For older systems, if you are using the Sharp with both context and wheel images in high-definition, then you’ll need to configure the SQL server memory on the in-vehicle computer running the Genetec Patroller™ application.

What you should know

On the Genetec Patroller™ computer, you must set the SQL maximum server memory according to the RAM installed on the in-vehicle computer. In general, set the maximum to ¼ of the available memory. For example, if 8 GB of RAM are available, set the maximum to 2 GB which is represented as 2048 MB in the example below.

Procedure

To change the SQL server memory in SQL Server Management Studio:

  1. In Object Explorer, right-click a server and select Properties.
  2. Click the Memory node.
  3. Under Server Memory Options, enter a Maximum server memory of 2048 MB.

To change the SQL server memory at the command prompt:

  1. Depending on the version of SQL running, do one of the following:
    • For SQL 2012, type:
      cd C:\Program Files\Microsoft SQL Server\110\Tools\Binn
    • For SQL 2014, type:
      cd C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn
  2. Type the following:
    Sqlcmd -S (local)\<name of DB server, ex: sqlexpress2014>
    sp_configure 'show advanced options', 1
    RECONFIGURE WITH OVERRIDE
    GO
    sp_configure 'max server memory', 2048
    RECONFIGURE WITH OVERRIDE
    GO