Table 1: Table size estimate for one Safeguard Privilege Manager for Windows user

Table Name	Number of Rows	Byte Size per Row	Total Size (bytes)
Activity	1,000	4,222.68	422,268.00
Computer	1	84.38	84.38
DatabaseVersion	1	72.09	72.09
DataError	20	8,834.25	176,685.00
DeployedRules	20	49.15	983
Discovery	30	3,8049.23	1,141,476.9
Domain	1	84.38	84.38
ElevationRequest	20	54,540.61	1,090,812.2
Reports_Scheduled	10	4,575.25	45,752.50
Reports_SharedFiles	10	9,436.70	94,367.0
Rule	20	304.99	6,099.8
User	1	4,443.48	4,443.48
Total Size 4,683,128.73 Bytes

As the number of users grow, some tables increase in size more rapidly than others. For this reason, the database size does not grow proportionately.

Database size calculation uses the following rules:

1. The Activity table generates one thousand records per user.

2. The number of Computer records are equal to the number of user records.

3. 20 reports represent one user.

4. The DatabaseVersion table should be one record irrespective of the number of user in the environment.

5. The DataError table is estimated to be twenty records to one user.

6. The DeployedRules table should generate twenty records per one user.

7. The Discovery table should generate roughly thirty records per user.

8. The number of Domain table records are set to one per user.

9. Twenty ElevationRequest records are generated per user.

10. There are ten Reports_Scheduled records per user.

11. There are ten Reports_SharedFilters per user.

12. Twenty Rule records are generated per user.

13. One user record exists in the User table per user.

Table 2: Database size for multiple users

Users	Database size
1	4.7 MB
10	10.5 MB
100	73.0 MB
1,000	692.6 MB
2,000	1,378.6 MB
5,000	3,439.9 MB
10,000	6,876.4 MB
15,000	10,313.0 MB
20,000	13,749.5 MB
50,000	34,368.8 MB
100,000	68,734.2 MB