ZENworks 11 SP3 introduces the Audit database, which 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.