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
Disk sizing for 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).