Submitted by:

Egor Puzanov

This ZenPack provides basic "Database" and "DBSrvInst" component class. The ZenPack also provide community.snmp.DatabaseMap collector plugin for  generic RDBMS databases (o.e. Posgresql with pgsnmpd agent) modelin and following components templates on /Server Device Class.

• /Server Device Class 
  • DBSrvInst Template provides: 
    • Data Sources 
      • diskReads (SNMP)
      • diskWrites (SNMP)
      • finishedTransactions (SNMP)
      • handledRequests (SNMP)
      • logicalReads (SNMP)
      • logicalWrites (SNMP)
      • pageReads (SNMP)
      • pageWrites (SNMP)
    • Graph Definitions
      • Operations
        • Disk Reads
        • Disk Writes
        • Logical Reads
        • Logical Writes
        • Page Reads
        • Page Writes
      • Requests
        • Handled Requests
      • Transactions
        • Finished
  • Database
    • Data Sources
      • Total (SNMP)
      • usedSize (SNMP)
    • Graph Definitions
      • Usage
        • Used
        • Total

It also provides MIBs and the /Peformance Reports/Database Util Report.

Screenshots:

REQUIREMENTS:

     Zenoss Version: 2.5, 3.0

     ZenPack Dependencies: Advanced Device Details (optional)

     External Dependencies:

     Installation: zenoss restart after ZenPack installation

Source: https://github.com/epuzanov/ZenPacks.community.RDBMS

Tagged Releases:

• http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/rdbms-1.0
• http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/rdbms-1.1
• http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/rdbms-1.2
• http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/rdbms-1.3
• https://github.com/epuzanov/ZenPacks.community.RDBMS/tree/rdbms-2.0
• https://github.com/epuzanov/ZenPacks.community.RDBMS/tree/rdbms-2.1
• https://github.com/epuzanov/ZenPacks.community.RDBMS/tree/rdbms-2.2
• https://github.com/epuzanov/ZenPacks.community.RDBMS/tree/rdbms-2.3
• https://github.com/epuzanov/ZenPacks.community.RDBMS/tree/rdbms-2.4

Change History:

• 1.0 initial release
• 1.1 Report plugin rewrited using AliasPlugin class and deleted snmp modeler plugin.
• 1.2 Zenoss 3.0 support
• 1.3 fix database components link on software tab page
• 2.0 multiple Database Server Instances support and generic RDBMS-MIB compatible databases modeling and monitoring
• 2.1 fix problem with displaying DB Server Instances in Zenoss 3.0.3
• 2.2 fix setDBSrvInst method, remove 'zendoc' attributes and enable 'Monitoring...' menu item on components grid
• 2.3 removed Advanced Device Details ZenPack dependency
• 2.4 Perf/DB events class added

Trac tickets: http://zenpacks.zenoss.org/trac-zenpacks/report/1

Known issues: