Disk sizing for Production database
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
- Evaluation results
- 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
Number of assets | Approximate database size after one scan for 350 checks (GB) | Approximate increase in database size for 10 scans (GB) |
|---|---|---|
1000 | 1 | 15 |
5000 | 5 | 60 |
10000 | 10 | 120 |
30000 | 20 | 250 |
100000 | 70 | 750 |
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).