9.2 ZENworks Audit Database Sizing

The ZENworks Audit database, is used to store change and agent audit events that you have enabled. The amount of data that will be present in the database depends on the following data:

  • How many devices do you have?

  • How frequently are objects changed?

  • Which events are enabled?

  • How frequently do those events occur?

  • How long is the data configured to be stored in the database?

While it is difficult to give an exact size for the database, Novell recommends at least 10 GB of hard disk size for every 5,000 devices and 512 MB RAM for every 5,000 devices if you have enabled all the events. However, if it is a dedicated server for the Audit database, it is recommended to maintain at least 4 GB of RAM for the initial 5,000 devices.

Based on the Novell Superlab testing and internal production testing, the following are the approximate values. Based on the size of the zone and type of events enabled, these values might differ in your environment.

 

Device Audit Events

Change Audit Events

Number of enabled events

20

183

Number of devices or administrators

5000 (devices)

3 (admins)

Average events/day

5/device

5/administrator

Number of days to keep events

30 days

30 days

Average size of events in the database

.5 KB

.4 KB

With these values, the 10 GB recommendation was arrived at using the following formulas:

  • Total Change Audit Size

    Events x Devices x Events/Day x Days to Keep x Average Size / 1024 / 1024 = total size in GB

    20*5000*5*30*.5 / 1024 /1024 = 7.15 GB

  • Total Device Audit Size

    Events x Admins x Changes per Admin per Day x Days to Keep x Average Size / 1024 / 1024 = total size in GB

    183*3*5*30*.4=0.31 GB

  • Reference Tables

    Reference tables allow names to be properly mapped in the Audit database. For every 5,000 devices, these tables are approximately 2 GB in size.