Use of Microsoft SQL Server resources
August 7, 2024
ID 204633
Brief description of tables in the database structure of Kaspersky Security for Microsoft Exchange Servers
Table name | Brief description |
[dbo].[AntispamDeferredStatisticsSchema]
| This table stores statistics on messages checked against Reputation Filtering. |
[dbo].[AntispamStatisticsSchema]
| This table stores Anti-Virus operation statistics. Before being added to the table, data is accumulated at fifteen-minute intervals with one record per verdict. The size of the table grows linearly as the product operates and is virtually independent of the load on the mail system. |
[dbo].[AntivirusStatisticsSchema]
| This table stores Anti-Virus operation statistics. Before being added to the table, data is accumulated at fifteen-minute intervals with one record per verdict. The size of the table grows linearly as the product operates and is virtually independent of the load on the mail system. |
[dbo].[Metadata] | This table stores metadata on objects in Backup (the objects themselves are not added to the database). The number of records in the table directly depends on the number of objects in Backup. |
Actual sizes of tables in the database
Name of the table in the Kaspersky Security database | Row count Number of rows created in the table | Data Space (MB) Amount of disk space occupied by the table | Average row size (B) Average size of each record |
AntispamDeferredStatisticsSchema | 15608 | 1 | 60 |
AntispamStatisticsSchema | 2858674 | 347 | 121.385 |
AntivirusStatisticsSchema | 1559450 | 210 | 134.663 |
Metadata | 54433 | 422 | 7752.65 |
Total | 4488165 | 980 | - |
The size of some tables has not been taken into account because their volume is negligible compared to those indicated above. Data was collected under the default settings of the product.
Parameters in the Settings node in the Data storage field:
- The Restrict the Backup storage size check box is selected.
Backup size must not exceed 5120 MB.
- The Restrict the duration of object storage in Backup check box is selected.
Store objects no longer than 45 days.
It should be noted that the actual size of the SQL database may differ from the occupied disk space due to the particularities of its operation. When using several installed instances of Kaspersky Security, you must allocate space for the SQL database for each server.