Estimating the size of the SQL database
August 7, 2024
ID 204634
Metadata table
To estimate the approximate size of the Metadata table, you need to know the quantity of messages placed into Backup and the expected storage time for objects in Backup.
((BackupItems)*Days)*8 (KB)= MetadataSize
Where:
BackupItems
– expected number of objects in Backup per day. This number can be obtained based on statistics on the number of viruses and/or spam in the client stream (as percentages) and the stream size.
Days
- number of days objects are stored in Backup.
8 KB
– average size of one record containing metadata in the Metadata SQL table.
In addition to the number of storage days, you can also limit the cumulative size of files in Backup. The default limit is 5120 MB.
Example estimation of the number of objects:
BackupItems= ((VirusTrafficPercent+SpamTrafficPercent)*(MailTrafficPerDay/100))
Where:
VirusTrafficPercent
– approximate expected percentage of viruses in mail traffic.
SpamTrafficPercent
– approximate expected percentage of spam in mail traffic.
MailTrafficPerDay
– approximate expected mail traffic over the course of one day.
AntispamStatisticsSchema
+ AntivirusStatisticsSchema
Based on our data, the average number of records in the statistics table is as follows:
AntivirusStatisticsSchema
- approximately 1700 strings per day.
AntispamStatisticsSchema
- approximately 3000 strings per day.
Average size of statistics tables in the SQL database per year, where the average size of one record is 150 B:
(1700+3000)*150 = 0.7 MB per day
Therefore, the size of tables will make up approximately 250 MB per year.