torrus/xmlconfig/generic/rfc1697.rdbms.xml

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <!--
   3    Copyright (C) 2003 Shawn Ferry
   4
   5    This program is free software; you can redistribute it and/or modify
   6    it under the terms of the GNU General Public License as published by
   7    the Free Software Foundation; either version 2 of the License, or
   8    (at your option) any later version.
   9
  10    This program is distributed in the hope that it will be useful,
  11    but WITHOUT ANY WARRANTY; without even the implied warranty of
  12    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  13    GNU General Public License for more details.
  14
  15    You should have received a copy of the GNU General Public License
  16    along with this program; if not, write to the Free Software
  17    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
  18
  19    Shawn Ferry <sferry at sevenspace dot com > <lalartu at obscure dot org>
  20
  21   Authors: Shawn Ferry
  22
  23   $Id: rfc1697.rdbms.xml,v 1.1 2010-12-27 00:04:29 ivan Exp $
  24 -->
  25 <configuration>
  26   <definitions>
  27     <!-- rdbmsDbTable -->
  28     <def name="rdbmsDbName" value="1.3.6.1.2.1.39.1.1.1.4"/>
  29
  30     <!-- rdbmsDbInfoTable -->
  31     <def name="rdbmsDbInfoSizeAllocated" value="1.3.6.1.2.1.39.1.2.1.4"/>
  32     <def name="rdbmsDbInfoSizeUsed" value="1.3.6.1.2.1.39.1.2.1.5"/>
  33
  34     <!-- rdbmsDbSrvInfoTable -->
  35     <def name="rdbmsSrvInfoFinishedTransactions"
  36                                      value="1.3.6.1.2.1.39.1.6.1.2"/>
  37     <def name="rdbmsSrvInfoDiskReads" value="1.3.6.1.2.1.39.1.6.1.3"/>
  38     <def name="rdbmsSrvInfoLogicalReads" value="1.3.6.1.2.1.39.1.6.1.4"/>
  39     <def name="rdbmsSrvInfoDiskWrites" value="1.3.6.1.2.1.39.1.6.1.5"/>
  40     <def name="rdbmsSrvInfoLogicalWrites" value="1.3.6.1.2.1.39.1.6.1.6"/>
  41     <def name="rdbmsSrvInfoPageReads" value="1.3.6.1.2.1.39.1.6.1.7"/>
  42     <def name="rdbmsSrvInfoPageWrites" value="1.3.6.1.2.1.39.1.6.1.8"/>
  43     <def name="rdbmsSrvInfoRequestsHandled" value="1.3.6.1.2.1.39.1.6.1.10"/>
  44
  45     <!-- Network Services applTable -->
  46     <def name="applInboundAssociations" value="1.3.6.1.2.1.27.1.1.8"/>
  47
  48     <def name="DB_IDX"
  49          value="M($rdbmsDbName,%dbName%)"/>
  50   </definitions>
  51
  52   <datasources>
  53
  54     <template name="rdbms-dbtable">
  55       <subtree name="DB_Stats">
  56         <param name="precedence" value="1000"/>
  57         <param name="data-file"
  58                  value="%system-id%_%vendor%_%dbName%_RDBMS.rrd"/>
  59         <param name="rrd-hwpredict" value="disabled" />
  60         <leaf name="DB_Allocated">
  61           <param name="leaf-type"   value="rrd-def"/>
  62           <param name="hidden"      value="no"/>
  63           <param name="rrd-cf"      value="AVERAGE"/>
  64           <param name="rrd-create-dstype" value="GAUGE"/>
  65           <param name="collector-scale" value="%dbSizeUnits%,*"/>
  66           <param name="snmp-object" value="$rdbmsDbInfoSizeAllocated.$DB_IDX"/>
  67           <param name="rrd-ds"      value="dbAllocated"/>
  68           <param name="comment" value="Space Allocated to this Database"/>
  69           <param name="graph-legend"   value="Allocated Space"/>
  70           <param name="vertical-label" value="Bytes"/>
  71           <param name="descriptive-nickname"
  72             value="%system-id%:%snmp-host% %dbName% Allocated Space"/>
  73         </leaf>
  74         <leaf name="DB_Used">
  75           <param name="leaf-type"   value="rrd-def"/>
  76           <param name="hidden"      value="no"/>
  77           <param name="rrd-cf"      value="AVERAGE"/>
  78           <param name="rrd-create-dstype" value="GAUGE"/>
  79           <param name="collector-scale" value="%dbSizeUnits%,*"/>
  80           <param name="snmp-object" value="$rdbmsDbInfoSizeAllocated.$DB_IDX"/>
  81           <param name="rrd-ds"      value="dbUsed"/>
  82           <param name="comment" value="Space Allocated to this Database"/>
  83           <param name="graph-legend"   value="Used Space"/>
  84           <param name="vertical-label" value="Bytes"/>
  85           <param name="descriptive-nickname"
  86             value="%system-id%:%snmp-host% %dbName% Used Space"/>
  87         </leaf>
  88         <leaf name="DB_Finished_Transactions">
  89           <param name="leaf-type"   value="rrd-def"/>
  90           <param name="hidden"      value="no"/>
  91           <param name="rrd-cf"      value="AVERAGE"/>
  92           <param name="rrd-create-dstype" value="COUNTER"/>
  93           <param name="snmp-object"
  94               value="$rdbmsSrvInfoFinishedTransactions.$DB_IDX"/>
  95           <param name="rrd-ds"      value="FinishedTrans"/>
  96           <param name="comment" value="Finished Transactions (COMMIT/ABORT)"/>
  97           <param name="graph-legend"   value="Transactions/s"/>
  98           <param name="vertical-label" value="Transactions"/>
  99           <param name="descriptive-nickname"
 100               value="%system-id%:%snmp-host% %dbName% Finished Transactions"/>
 101         </leaf>
 102         <leaf name="DB_Disk_Reads">
 103           <param name="leaf-type"   value="rrd-def"/>
 104           <param name="hidden"      value="no"/>
 105             <param name="rrd-cf"      value="AVERAGE"/>
 106         <param name="rrd-create-dstype" value="COUNTER"/>
 107           <param name="snmp-object" value="$rdbmsSrvInfoDiskReads.$DB_IDX"/>
 108           <param name="rrd-ds"      value="DiskReads"/>
 109           <param name="comment" value="Disk Reads/s"/>
 110           <param name="graph-legend"   value="Disk Reads"/>
 111           <param name="vertical-label" value="Disk Reads/s"/>
 112           <param name="descriptive-nickname"
 113               value="%system-id%:%snmp-host% %dbName% Disk Reads/s"/>
 114         </leaf>
 115         <leaf name="DB_Logical_Reads">
 116           <param name="leaf-type"   value="rrd-def"/>
 117           <param name="hidden"      value="no"/>
 118           <param name="rrd-cf"      value="AVERAGE"/>
 119           <param name="rrd-create-dstype" value="COUNTER"/>
 120           <param name="snmp-object" value="$rdbmsSrvInfoLogicalReads.$DB_IDX"/>
 121           <param name="rrd-ds"      value="LogicalReads"/>
 122           <param name="comment" value="Logical Reads/s"/>
 123           <param name="graph-legend"   value="Logical Reads"/>
 124           <param name="vertical-label" value="Logical Reads/s"/>
 125           <param name="descriptive-nickname"
 126               value="%system-id%:%snmp-host% %dbName% Logical Reads/s"/>
 127         </leaf>
 128         <leaf name="DB_Disk_Writes">
 129           <param name="leaf-type"   value="rrd-def"/>
 130           <param name="hidden"      value="no"/>
 131           <param name="rrd-cf"      value="AVERAGE"/>
 132           <param name="rrd-create-dstype" value="COUNTER"/>
 133           <param name="snmp-object" value="$rdbmsSrvInfoDiskWrites.$DB_IDX"/>
 134           <param name="rrd-ds"      value="DiskWrites"/>
 135           <param name="comment" value="Disk Writes/s"/>
 136           <param name="graph-legend"   value="Writes"/>
 137           <param name="vertical-label" value="Writes/s"/>
 138           <param name="descriptive-nickname"
 139               value="%system-id%:%snmp-host% %dbName% Disk Writes/s"/>
 140         </leaf>
 141         <leaf name="DB_Logical_Writes">
 142           <param name="leaf-type"   value="rrd-def"/>
 143           <param name="hidden"      value="no"/>
 144           <param name="rrd-cf"      value="AVERAGE"/>
 145           <param name="rrd-create-dstype" value="COUNTER"/>
 146           <param name="snmp-object"
 147                    value="$rdbmsSrvInfoLogicalWrites.$DB_IDX"/>
 148           <param name="rrd-ds"      value="LogicalWrites"/>
 149           <param name="comment" value="Logical Writes/s"/>
 150           <param name="graph-legend"   value="Logical Writes"/>
 151           <param name="vertical-label" value="Logical Writes/s"/>
 152           <param name="descriptive-nickname"
 153               value="%system-id%:%snmp-host% %dbName% Logical Writes/s"/>
 154         </leaf>
 155         <leaf name="DB_Page_Writes">
 156           <param name="leaf-type"   value="rrd-def"/>
 157           <param name="hidden"      value="no"/>
 158           <param name="rrd-cf"      value="AVERAGE"/>
 159           <param name="rrd-create-dstype" value="COUNTER"/>
 160           <param name="snmp-object" value="$rdbmsSrvInfoPageWrites.$DB_IDX"/>
 161           <param name="rrd-ds"      value="PageWrites"/>
 162           <param name="comment" value="Page Writes/s"/>
 163           <param name="graph-legend"   value="Page Writes"/>
 164           <param name="vertical-label" value="Page Writes/s"/>
 165           <param name="descriptive-nickname"
 166               value="%system-id%:%snmp-host% %dbName% Page Writes/s"/>
 167         </leaf>
 168         <leaf name="DB_Page_Reads">
 169           <param name="leaf-type"   value="rrd-def"/>
 170           <param name="hidden"      value="no"/>
 171           <param name="rrd-cf"      value="AVERAGE"/>
 172           <param name="rrd-create-dstype" value="COUNTER"/>
 173           <param name="snmp-object" value="$rdbmsSrvInfoPageReads.$DB_IDX"/>
 174           <param name="rrd-ds"      value="PageReads"/>
 175           <param name="comment" value="Page Reads/s"/>
 176           <param name="graph-legend"   value="Page Reads"/>
 177           <param name="vertical-label" value="Page Reads/s"/>
 178           <param name="descriptive-nickname"
 179               value="%system-id%:%snmp-host% %dbName% Page Reads/s"/>
 180         </leaf>
 181         <leaf name="DB_Request_Rate">
 182           <param name="leaf-type"   value="rrd-def"/>
 183           <param name="hidden"      value="no"/>
 184           <param name="rrd-cf"      value="AVERAGE"/>
 185           <param name="rrd-create-dstype" value="COUNTER"/>
 186           <param name="snmp-object"
 187               value="$rdbmsSrvInfoRequestsHandled.$DB_IDX"/>
 188           <param name="rrd-ds"      value="RequestsHandled"/>
 189           <param name="comment" value="Requests Handled/s"/>
 190           <param name="graph-legend"   value="Requests Handled"/>
 191           <param name="vertical-label" value="Requests Handled/s"/>
 192           <param name="descriptive-nickname"
 193               value="%system-id%:%snmp-host% %dbName% Requests Handled/s"/>
 194         </leaf>
 195         <leaf name="DB_Inbound_Associations">
 196           <param name="leaf-type"   value="rrd-def"/>
 197           <param name="hidden"      value="no"/>
 198           <param name="rrd-cf"      value="AVERAGE"/>
 199           <param name="rrd-create-dstype" value="GAUGE"/>
 200           <param name="snmp-object" value="$applInboundAssociations.$DB_IDX"/>
 201           <param name="rrd-ds"      value="InboundAssociations"/>
 202           <param name="comment" value="Inbound Associations"/>
 203           <param name="graph-legend"   value="Inbound Associations"/>
 204           <param name="vertical-label" value="Inbound Associations"/>
 205           <param name="descriptive-nickname"
 206             value="%system-id%:%snmp-host% %dbName% Inbound Associations"/>
 207         </leaf>
 208       </subtree>
 209     </template>
 210   </datasources>
 211 </configuration>