1 <?xml version="1.0" encoding="UTF-8"?>
3 Copyright (C) 2003 Shawn Ferry
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.
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.
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.
19 Shawn Ferry <sferry at sevenspace dot com > <lalartu at obscure dot org>
23 $Id: rfc1697.rdbms.xml,v 1.1 2010-12-27 00:04:29 ivan Exp $
28 <def name="rdbmsDbName" value="1.3.6.1.2.1.39.1.1.1.4"/>
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"/>
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"/>
45 <!-- Network Services applTable -->
46 <def name="applInboundAssociations" value="1.3.6.1.2.1.27.1.1.8"/>
49 value="M($rdbmsDbName,%dbName%)"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>