Hello, Zabbix folks.
We’re trying to setup some Zabbix monitoring, and have run into an issue. Here is an example of a server we are trying to monitor:
Server01
=> Oracle databases:
=>=> PROD
=>=>=> Tablespaces:
=>=>=>=> SYSTEM
=>=>=>=> SYSAUX
=>=>=>=> . . .
=>=> TEST
=>=>=> Tablespaces:
=>=>=>=> SYSTEM
=>=>=>=> SYSAUX
=>=>=>=> . . .
=>=> DEV
=>=>=> Tablespaces:
=>=>=>=> SYSTEM
=>=>=>=> SYSAUX
=>=>=>=> . . .
The things that we want to monitor (servers, multiple databases living on each server, multiple tablespaces in each database, etc.) are naturally organized hierarchically. Kind of a one-to-many relationship.
I can’t find a scalable way to monitor these. I can monitor like this:
Server01
Database: PROD
Dataasse: PROD:tablespace:SYSTEM
Database: PROD:tablespace:SYSAUX
. . .
Database: TEST
Dataasse: TEST:tablespace:SYSTEM
Database: TEST:tablespace:SYSAUX
. . .
Database: DEV
Dataasse: DEV:tablespace:SYSTEM
Database: DEV:tablespace:SYSAUX
. . .
Where the hierarchy has been flattened. However, that is not very scalable. For a large database, with hundreds of tablespaces, it can become non-scalable pretty quickly.
Is there a way to create a hierarchy of items, going down several levels:
{Server}:{Oracle DB}:{PROD}:{tablespaces}:{SYSTEM}:{total KB alloc}
And have the triggers or alerts on the items bubble up to items (or objects) that are higher up in the hierarchy?
We wouldn't want to display the entire hierarchy on the main console, but have the ability to drill down into the hierarchy, to see what the underlying issue is.
Can you do this in Zabbix?
Thanks in advance for your help.
Jeff Kayser
We’re trying to setup some Zabbix monitoring, and have run into an issue. Here is an example of a server we are trying to monitor:
Server01
=> Oracle databases:
=>=> PROD
=>=>=> Tablespaces:
=>=>=>=> SYSTEM
=>=>=>=> SYSAUX
=>=>=>=> . . .
=>=> TEST
=>=>=> Tablespaces:
=>=>=>=> SYSTEM
=>=>=>=> SYSAUX
=>=>=>=> . . .
=>=> DEV
=>=>=> Tablespaces:
=>=>=>=> SYSTEM
=>=>=>=> SYSAUX
=>=>=>=> . . .
The things that we want to monitor (servers, multiple databases living on each server, multiple tablespaces in each database, etc.) are naturally organized hierarchically. Kind of a one-to-many relationship.
I can’t find a scalable way to monitor these. I can monitor like this:
Server01
Database: PROD
Dataasse: PROD:tablespace:SYSTEM
Database: PROD:tablespace:SYSAUX
. . .
Database: TEST
Dataasse: TEST:tablespace:SYSTEM
Database: TEST:tablespace:SYSAUX
. . .
Database: DEV
Dataasse: DEV:tablespace:SYSTEM
Database: DEV:tablespace:SYSAUX
. . .
Where the hierarchy has been flattened. However, that is not very scalable. For a large database, with hundreds of tablespaces, it can become non-scalable pretty quickly.
Is there a way to create a hierarchy of items, going down several levels:
{Server}:{Oracle DB}:{PROD}:{tablespaces}:{SYSTEM}:{total KB alloc}
And have the triggers or alerts on the items bubble up to items (or objects) that are higher up in the hierarchy?
We wouldn't want to display the entire hierarchy on the main console, but have the ability to drill down into the hierarchy, to see what the underlying issue is.
Can you do this in Zabbix?
Thanks in advance for your help.
Jeff Kayser
Comment