3xLOGIC VIGIL Server - Manual (Page 176)

POS Data Enables POS data information to be stored on a central SQL database.
SQL Server Location
The network path of the central SQL database. It is possible to use two different servers for each
video/audio and POS data by inputting 2 different server locations.
Port SQL Server port being used on the server running the central SQL database
VIGIL Server ID Each VIGIL Server connecting to the central SQL database must have a unique VIGIL Server ID.
Local Database Memory Usage
The Database Memory Usage section is used to limit the amount of memory used by the local SQL database. This will
not affect the disk space usage of the database - only the memory usage. Minimum memory usage should always be
set to 0 MB. Maximum memory usage should be set according to the amount of memory installed in the VIGIL Server
(see table below). Setting the appropriate maximum memory usage level for the VIGIL Server will improve VIGIL
Server performance. To change the maximum memory usage, drag the slide bar to the appropriate MB amount. Check
Adjust SQL Server Memory Automatically checkbox to have the memory set automatically.
MB of RAM installed in VIGIL Server Max MB of Memory Usage Recommended
512MB 250MB
1024MB 700MB
2048Mb 1536Mb
3xLOGIC's VIGIL Server 7.1 User Guide
Pg. 172