The disk size that a SQL server computer hosting production database requires, depends on the following variables:
Number of assets in the system
Number of standards in the system
Frequency of evaluation of a standard against number of assets
Production database purge criteria
To determine disk requirements for SQL server computer hosting production database, the following guidelines should be followed:
No. of assets*No. of checks*constant 2 * No. of iterations =Size in KB
The following table gives the disk sizing for the Production database
Table: Disk sizing for the Production database
No. of Assets
Approx. production db size after one scan for 350 checks (GB)
Approx. increase in production db size for 10 scans (GB)
Considering that purge criteria for production database is set at 10 scans by default, the disk space requirement for storing evaluation results should not exceed the figures mentioned in the above table.
The above disk sizing requirements are estimated for Windows assets. For other platforms the disk size may vary due to increase in evidence size as well as type of evidence ( positive / negative).