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 Patroller application.
What you should know
On the 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:
In Object Explorer, right-click a server and select Properties.
Click the Memory node.
Under Server Memory Options, enter a Maximum server
memory of 2048 MB.
To change the SQL server memory at the command prompt:
Depending on the version of SQL running, do one of the following:
For SQL 2022,
type:
Code
cd C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn
For SQL 2014,
type:
Code
cd C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn
For SQL 2012,
type:
Code
cd C:\Program Files\Microsoft SQL Server\110\Tools\Binn
Type the following:
Code
Sqlcmd -S (local)\<name of DB server, ex: sqlexpress2022>
sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
GO
sp_configure 'max server memory', 2048
RECONFIGURE WITH OVERRIDE
GO