-
Notifications
You must be signed in to change notification settings - Fork 0
/
template_db_firebird_odbc.yaml
483 lines (481 loc) · 17.4 KB
/
template_db_firebird_odbc.yaml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
zabbix_export:
version: '5.4'
date: '2022-06-06T10:59:51Z'
groups:
-
uuid: 748ad4d098d447d492bb935c907f652f
name: Templates/Databases
templates:
-
uuid: 01896636376747a8a5ba2fd1acab94d3
template: 'Firebird by ODBC'
name: 'Firebird by ODBC'
description: |
Firebird template to monitoring database and server.
1. Install Firebird ODBC driver on Zabbix server or Zabbix proxy. See Firebird documentation for instructions: https://firebirdsql.org/file/documentation/html/en/refdocs/fbodbc20/firebird-odbc-driver-20-manual.html#fbodbc205-configure
2. Set the macro value {$FIREBIRD.DSN} as defined in the data source.
groups:
-
name: Templates/Databases
items:
-
uuid: 47c4bbc32c0046a09bff7a0f4b133959
name: 'Firebird: Get performance counters'
type: ODBC
key: 'db.odbc.get[get_status_variables,"{$FIREBIRD.DSN}"]'
delay: 10m
history: '0'
trends: '0'
value_type: TEXT
params: |
SELECT 'Version' as counter_name, RDB$GET_CONTEXT('SYSTEM', 'ENGINE_VERSION') as cntr_value
FROM RDB$DATABASE
UNION
SELECT 'Active Transactions' as counter_name, count(*) as cntr_value
FROM MON$TRANSACTIONS
WHERE MON$STATE = 1
UNION
SELECT 'Open Connections' as counter_name, count(*) as cntr_value
FROM MON$ATTACHMENTS
UNION
SELECT 'IDLE Connections' as counter_name, count(*) as cntr_value
FROM MON$ATTACHMENTS
WHERE MON$STATE = 0
UNION
SELECT 'Database State' as counter_name, MON$SHUTDOWN_MODE as cntr_value
FROM MON$DATABASE
UNION
SELECT 'Database Creation Date' as counter_name, MON$CREATION_DATE as cntr_value
FROM MON$DATABASE
UNION
SELECT 'Pages Allocated Externally' as counter_name, MON$PAGES as cntr_value
FROM MON$DATABASE
UNION
SELECT 'Backup State' as counter_name, MON$BACKUP_STATE as cntr_value
FROM MON$DATABASE
UNION
SELECT 'Page Fetches' as counter_name, MON$PAGE_FETCHES as cntr_value
FROM MON$IO_STATS
WHERE MON$STAT_GROUP = 0
UNION
SELECT 'Page Writes' as counter_name, MON$PAGE_WRITES as cntr_value
FROM MON$IO_STATS
WHERE MON$STAT_GROUP = 0
UNION
SELECT 'Database Memory Used' as counter_name, MON$MEMORY_USED as cntr_value
FROM MON$MEMORY_USAGE
WHERE MON$STAT_GROUP = 0
UNION
SELECT 'Database Page Size' as counter_name, MON$PAGE_SIZE as cntr_value
FROM MON$DATABASE
UNION
SELECT 'Database Allocated Pages' as counter_name, MON$PAGE_BUFFERS as cntr_value
FROM MON$DATABASE
UNION
SELECT 'Stalled Statements' as counter_name, count(*) as cntr_value
FROM MON$STATEMENTS
WHERE MON$STATE = 2
UNION
SELECT 'Running Statements' as counter_name, count(*) as cntr_value
FROM MON$STATEMENTS
WHERE MON$STATE = 1 AND MON$ATTACHMENT_ID <> CURRENT_CONNECTION
description: 'The item gets server global status information.'
-
uuid: 86466d2bab6544389e7a2f6b055caf32
name: 'Firebird: Database allocated pages'
type: DEPENDENT
key: firebird.allocated_pages
delay: '0'
history: 7d
description: 'The number of allocated pages in the database.'
preprocessing:
-
type: JSONPATH
parameters:
- '$[?(@.COUNTER_NAME==''Database Allocated Pages'')].CNTR_VALUE.first()'
master_item:
key: 'db.odbc.get[get_status_variables,"{$FIREBIRD.DSN}"]'
tags:
-
tag: Application
value: Firebird
-
uuid: 2e3f03e94def446fbc20576bea496f33
name: 'Firebird: Backup state'
type: DEPENDENT
key: firebird.backup_state
delay: '0'
history: 7d
trends: '0'
value_type: TEXT
description: |
Backup state:
0 - Normal;
1 - Stalled;
2 - Merge.
preprocessing:
-
type: JSONPATH
parameters:
- '$[?(@.COUNTER_NAME==''Backup State'')].CNTR_VALUE.first()'
-
type: STR_REPLACE
parameters:
- '0'
- Normal
-
type: STR_REPLACE
parameters:
- '1'
- Stalled
-
type: STR_REPLACE
parameters:
- '2'
- Merge
master_item:
key: 'db.odbc.get[get_status_variables,"{$FIREBIRD.DSN}"]'
tags:
-
tag: Application
value: Firebird
triggers:
-
uuid: 2eab34ab732f45209fef07fa55c92966
expression: 'last(/Firebird by ODBC/firebird.backup_state,#1)<>last(/Firebird by ODBC/firebird.backup_state,#2)'
name: 'Firebird: Physical Backup (nBackup) is running (the state is: {ITEM.VALUE})'
priority: INFO
description: |
Firebird database is running nBackup. Backup state:
0 - Normal;
1 - Stalled;
2 - Merge.
manual_close: 'YES'
-
uuid: c74338424af14ab8972e7c60726faf6f
name: 'Firebird: Database creation date'
type: DEPENDENT
key: firebird.database_date
delay: '0'
history: 7d
trends: '0'
value_type: TEXT
description: 'The date and time when the database was created or was last restored.'
preprocessing:
-
type: JSONPATH
parameters:
- '$[?(@.COUNTER_NAME==''Database Creation Date'')].CNTR_VALUE.first()'
master_item:
key: 'db.odbc.get[get_status_variables,"{$FIREBIRD.DSN}"]'
tags:
-
tag: Application
value: Firebird
triggers:
-
uuid: 79f852d61f1f4c708e4acfb6a31c4eab
expression: 'last(/Firebird by ODBC/firebird.database_date,#1)<>last(/Firebird by ODBC/firebird.database_date,#2) and length(last(/Firebird by ODBC/firebird.database_date))>0'
name: 'Firebird: Database has restored'
priority: INFO
description: 'Firebird database has restored.'
manual_close: 'YES'
-
uuid: 1b5989ea37d84008a81820d0f4bb18e2
name: 'Firebird: Database state'
type: DEPENDENT
key: firebird.database_state
delay: '0'
history: 7d
description: |
Database state:
0 - Online;
1 - Multi-user shutdown;
2 - Single-user shutdown;
3 - Full-shutdown.
preprocessing:
-
type: JSONPATH
parameters:
- '$[?(@.COUNTER_NAME==''Database State'')].CNTR_VALUE.first()'
master_item:
key: 'db.odbc.get[get_status_variables,"{$FIREBIRD.DSN}"]'
tags:
-
tag: Application
value: Firebird
triggers:
-
uuid: 92d73308024c4852a3e603c7f7e4a0b2
expression: 'last(/Firebird by ODBC/firebird.database_state)<>0'
name: 'Firebird: Database is down'
priority: HIGH
description: |
The Firebird Database is shutdown. (The current state is {ITEM.VALUE}):
0 - The database is online;
1 - Multi-user shutdown;
2 - Single-user shutdown;
3 - Full shutdown.
-
uuid: e2c8a080f2494e70a6f28385257f3eff
name: 'Firebird: Pages allocated externally'
type: DEPENDENT
key: firebird.external_pages
delay: '0'
history: 7d
description: 'The number of external pages allocated.'
preprocessing:
-
type: JSONPATH
parameters:
- '$[?(@.COUNTER_NAME==''Pages Allocated Externally'')].CNTR_VALUE.first()'
master_item:
key: 'db.odbc.get[get_status_variables,"{$FIREBIRD.DSN}"]'
tags:
-
tag: Application
value: Firebird
-
uuid: 10b639140c3c45799917ea73e418e0f9
name: 'Firebird: Idle connections'
type: DEPENDENT
key: firebird.idle_connections
delay: '0'
history: 7d
description: 'Number of currently idle connections.'
preprocessing:
-
type: JSONPATH
parameters:
- '$[?(@.COUNTER_NAME==''IDLE Connections'')].CNTR_VALUE.first()'
master_item:
key: 'db.odbc.get[get_status_variables,"{$FIREBIRD.DSN}"]'
tags:
-
tag: Application
value: Firebird
triggers:
-
uuid: 142ca8d7cf144f619d21fa4f68349497
expression: 'min(/Firebird by ODBC/firebird.idle_connections,5m)>{$FIREBIRD.IDLE_CONNECTION.WARN}'
name: 'Firebird: Number of idle connections too high (over {$FIREBIRD.IDLE_CONNECTION.WARN} for 5m)'
priority: WARNING
description: 'Too high number of idle connections.'
-
uuid: f908880b79d04b6eb4e54d4bd8bec96b
name: 'Firebird: Database memory usage'
type: DEPENDENT
key: firebird.memory_usage
delay: '0'
history: 7d
description: 'Database memory usage in bytes.'
preprocessing:
-
type: JSONPATH
parameters:
- '$[?(@.COUNTER_NAME==''Database Memory Used'')].CNTR_VALUE.first()'
master_item:
key: 'db.odbc.get[get_status_variables,"{$FIREBIRD.DSN}"]'
tags:
-
tag: Application
value: Firebird
-
uuid: 2d007697e3544badb38b870aa6a5c9ae
name: 'Firebird: Open connections'
type: DEPENDENT
key: firebird.open_connections
delay: '0'
history: 7d
description: 'Number of currently open connections.'
preprocessing:
-
type: JSONPATH
parameters:
- '$[?(@.COUNTER_NAME==''Open Connections'')].CNTR_VALUE.first()'
master_item:
key: 'db.odbc.get[get_status_variables,"{$FIREBIRD.DSN}"]'
tags:
-
tag: Application
value: Firebird
triggers:
-
uuid: c3ba746e408541dc897e246cf7488efe
expression: 'min(/Firebird by ODBC/firebird.open_connections,5m)>{$FIREBIRD.CONNECTION.MAX}'
name: 'Firebird: Number of connections too high (over {$FIREBIRD.CONNECTION.MAX} for 5m)'
priority: AVERAGE
description: 'Too high number of connections.'
-
uuid: 0e2187734c5c4c588302cab8f92e0a5c
name: 'Firebird: Page fetches'
type: DEPENDENT
key: firebird.page_fetches
delay: '0'
history: 7d
description: 'Number of page fetches in the database.'
preprocessing:
-
type: JSONPATH
parameters:
- '$[?(@.COUNTER_NAME==''Page Fetches'')].CNTR_VALUE.first()'
master_item:
key: 'db.odbc.get[get_status_variables,"{$FIREBIRD.DSN}"]'
tags:
-
tag: Application
value: Firebird
-
uuid: d2bc555ce8954a8fbd721dbc564e7e9b
name: 'Firebird: Database page size'
type: DEPENDENT
key: firebird.page_size
delay: '0'
history: 7d
description: |
The number of pages configured to use for the database.
Allowed page sizes: 4096, 8192, 16384 or 32768 (>= Firebird 4)
preprocessing:
-
type: JSONPATH
parameters:
- '$[?(@.COUNTER_NAME==''Database Page Size'')].CNTR_VALUE.first()'
master_item:
key: 'db.odbc.get[get_status_variables,"{$FIREBIRD.DSN}"]'
tags:
-
tag: Application
value: Firebird
-
uuid: 00266696b5a04dbcbe77f62e36d1d909
name: 'Firebird: Page writes'
type: DEPENDENT
key: firebird.page_writes
delay: '0'
history: 7d
description: 'Number of page writes in the database.'
preprocessing:
-
type: JSONPATH
parameters:
- '$[?(@.COUNTER_NAME==''Page Writes'')].CNTR_VALUE.first()'
master_item:
key: 'db.odbc.get[get_status_variables,"{$FIREBIRD.DSN}"]'
tags:
-
tag: Application
value: Firebird
-
uuid: 874a3fa0e94b4a698b20209291885d73
name: 'Firebird: Running statements'
type: DEPENDENT
key: firebird.running_statements
delay: '0'
history: 7d
description: 'The number of running statements.'
preprocessing:
-
type: JSONPATH
parameters:
- '$[?(@.COUNTER_NAME==''Running Statements'')].CNTR_VALUE.first()'
master_item:
key: 'db.odbc.get[get_status_variables,"{$FIREBIRD.DSN}"]'
tags:
-
tag: Application
value: Firebird
-
uuid: abc9566c443844b1bf3c35f0aa8cb874
name: 'Firebird: Stalled statements'
type: DEPENDENT
key: firebird.stalled_statements
delay: '0'
history: 7d
description: 'The number of stalled statements.'
preprocessing:
-
type: JSONPATH
parameters:
- '$[?(@.COUNTER_NAME==''Stalled Statements'')].CNTR_VALUE.first()'
master_item:
key: 'db.odbc.get[get_status_variables,"{$FIREBIRD.DSN}"]'
tags:
-
tag: Application
value: Firebird
triggers:
-
uuid: c88f10213b1d4d5ea5d9513f26904458
expression: 'min(/Firebird by ODBC/firebird.stalled_statements,5m)>{$FIREBIRD.STALLED_STATEMENTS.MAX}'
name: 'Firebird: Number of stalled statements too high (over {$FIREBIRD.STALLED_STATEMENTS.MAX} for 5m)'
priority: AVERAGE
description: 'Too high number of stalled statements.'
-
uuid: a53c56f027d444f08e66d6a50bcf1716
name: 'Firebird: Total active transactions'
type: DEPENDENT
key: firebird.transactions
delay: '0'
history: 7d
description: 'The number of currently active transactions of all types.'
preprocessing:
-
type: JSONPATH
parameters:
- '$[?(@.COUNTER_NAME==''Active Transactions'')].CNTR_VALUE.first()'
master_item:
key: 'db.odbc.get[get_status_variables,"{$FIREBIRD.DSN}"]'
tags:
-
tag: Application
value: Firebird
-
uuid: 9b0014028d9a4ec8b268a2041a111378
name: 'Firebird: Version'
type: DEPENDENT
key: firebird.version
delay: '0'
history: 2w
trends: '0'
value_type: CHAR
description: 'Firebird Server version.'
preprocessing:
-
type: JSONPATH
parameters:
- '$[?(@.COUNTER_NAME==''Version'')].CNTR_VALUE.first()'
-
type: DISCARD_UNCHANGED_HEARTBEAT
parameters:
- 1d
master_item:
key: 'db.odbc.get[get_status_variables,"{$FIREBIRD.DSN}"]'
tags:
-
tag: Application
value: Firebird
triggers:
-
uuid: 9fb187cdf7a7442da33d0508eb823bce
expression: 'last(/Firebird by ODBC/firebird.version,#1)<>last(/Firebird by ODBC/firebird.version,#2) and length(last(/Firebird by ODBC/firebird.version))>0'
name: 'Firebird: Version has changed (new version value received: {ITEM.VALUE})'
priority: INFO
description: 'Firebird version has changed. Ack to close.'
manual_close: 'YES'
macros:
-
macro: '{$FIREBIRD.CONNECTION.MAX}'
value: '60'
description: 'The maximum connections - for the trigger expression.'
-
macro: '{$FIREBIRD.DSN}'
value: '<Put your DSN here>'
description: 'System data source name.'
-
macro: '{$FIREBIRD.IDLE_CONNECTION.WARN}'
value: '30'
description: 'The maximum idle connections stalled to warning - for the trigger expression.'
-
macro: '{$FIREBIRD.STALLED_STATEMENTS.MAX}'
value: '10'
description: 'The maximum stalled statements - for the trigger expression.'