Disk sizing for Reporting database
The disk size that a SQL server computer hosting reporting 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
To determine disk requirements for SQL server computer hosting reporting database, the following guidelines should be followed:
No. of assets*No. of checks*constant 3.5 * No. of iterations =Size in KB
The disk requirements for SQL server computer hosting reporting database depends on the frequency of scans.
Table: Disk sizing for the Reporting database considering weekly scan
Table: Disk sizing for the Reporting database considering quarterly scan
Table: Disk sizing for the Reporting database considering quarterly scan
Table: Disk sizing for the Reporting database considering weekly scan
No. of Assets |
Approx. reporting db size after one scan for 350 checks (GB) |
Approx. increase in a month for reporting db size assuming Weekly scan(GB) |
Approx. Disk space needed for 1 year of usage. (GB) |
1000 |
2 |
8 |
100 |
5000 |
6 |
24 |
300 |
10000 |
12 |
50 |
600 |
30000 |
36 |
150 |
1800 |
Table: Disk sizing for the Reporting database considering monthly scan
No. of Assets |
Approx. reporting db size after one scan for 350 checks (GB) |
Approx. increase in a month for reporting db size assuming Weekly scan(GB) |
Approx. Disk space needed for 1 year of usage. (GB) |
1000 |
2 |
2 |
25 |
5000 |
6 |
6 |
80 |
10000 |
12 |
12 |
150 |
30000 |
36 |
36 |
450 |
Table: Disk sizing for the Reporting database considering quarterly scan
No. of Assets |
Approx. reporting db size after one scan for 350 checks (GB) |
Approx. increase in a month for reporting db size assuming Weekly scan(GB) |
Approx. Disk space needed for 1 year of usage. (GB) |
1000 |
2 |
1 |
8 |
5000 |
6 |
2 |
24 |
10000 |
12 |
4 |
50 |
30000 |
36 |
13 |
150 |
Note: |
The above database size recommendations are for one year. For 3 years of usage, disk space can be increased linearly. Reporting database purge criteria is 3 years, by default. |
Note: |
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). |
See Disk sizing for Production database.
See Recommendations for Reporting database deployment.
Thanks for your feedback. Let us know if you have additional comments below. (requires login)