Calculation of database space
Nov 27, 2023
The approximate amount of space that must be reserved in the database can be calculated using the following formula:
(600 * C + 2.3 * E + 2.5 * A + 1.2 * N * F), KB
- C is the number of devices.
- E is the number of events to store.
- A is the total number of Active Directory objects:
- Device accounts
- User accounts
- Accounts of security groups
- Active Directory organizational units
If scanning of Active Directory is disabled, A is considered to equal zero.
- N is the average number of inventoried executable files on an endpoint device.
- F is the number of endpoint devices, where executable files were inventoried.
If you plan to enable (in the Kaspersky Endpoint Security policy settings) notification of Administration Server on applications that you run, you will need additional (0.03 * C) gigabytes to store in the database the information about applications that you run.
If Administration Server distributes Windows updates (thus acting as the Windows Server Update Services server), the database will require an additional 2.5 GB.
During operation, a certain unallocated space is always present in the database. Therefore, the actual size of the database file (by default, the KAV.MDF file, if you use SQL Server as the DBMS) often turns out to be approximately twice as large as the amount of space occupied in the database.
It is not recommended to limit explicitly the size of the transaction log (by default, the file KAV_log.LDF, if you use SQL Server as the DBMS). It is recommended to leave the default value of th MAXSIZE parameter. However, if you have to limit the size of this file, take into consideration that the typical necessary value of the MAXSIZE parameter for KAV_log.LDF is 20480 MB.