Databases - Security Center 5.9

Security Center Administrator Guide 5.9

Applies to
Security Center 5.9
Last updated
2022-10-25
Content type
Guides > Administrator guides
Language
English
Product
Security Center
Version
5.9

A database is a collection of data that is organized so that its contents can easily be accessed, managed, and updated.

How database hosting works in Security Center

By default, a role’s database is hosted on the same server that hosts the role. This is shown in the role’s Resources tab by the value (local)\SQLEXPRESS in the Database server field, where “(local)” is the server where the role is running.

If you plan to change the server hosting the role or add secondary servers for failover, the database must be hosted on a different computer.

In addition, the computer hosting the database server does not have to be a Security Center server (meaning a computer where Genetec Server service is installed), unless you are configuring Directory database failover using the backup and restore method.

How SQL Server uses memory

If you are using a licensed edition of SQL Server (like SQL Server Standard, SQL Server Business Intelligence, or SQL Server Enterprise) please keep in mind that all databases are managed by Microsoft SQL Server in Security Center. By default, SQL Server is configured to use as much memory as it is available on the system. This could lead to memory issues if you are hosting SQL Server and many roles on the same server, especially on a virtual machine with little memory resources. If you are running out of memory on one of your servers, you can fix the problem by setting a maximum limit to the amount of memory SQL Server is allowed to use.