Skip to main content

SAP MAX DB

  • version: 1.0
  • Compatibility: v 7.5.3
  • Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Database Name (Mandatory), Metric Collect Interval (Second)
  • Operation: monitors the SAP Max DB.
  • Plugin-Metrics:
MetricData Type
Connection Time (MS)Numeric
Kernel VersionString
Running DirectoryString
Instance TypeString
Sequence Cache (MB)Numeric
Catalog Cache (MB)Numeric
OMS Heap (MB)Numeric
Shared SQL Cache (MB)Numeric
Used Data (KB)Numeric
Total Data (KB)Numeric
Used Temporary Converter (KB)Numeric
Incremental Backup (KB)Numeric
Used Permanent Data (KB)Numeric
Used Temporary Data (KB)Numeric
Used Shadow Data (KB)Numeric
Used Permanent Converter (KB)Numeric
Used Data (%)Numeric
Free Data (%)Numeric
Free Data (KB)Numeric
Used Log (MB)Numeric
Total Log (MB)Numeric
Used Log (%)Numeric
Log Area FullString
Logging StatusString
Log Auto OverwriteString
Log Flush ModeString
Log Device StateString
Log Writer StatusString
IO Buffer File Directory (KB)Numeric
IO Buffer Block Allocator (KB)Numeric
IO Buffer Converter Used (KB)Numeric
IO Buffer Log Queue Cache (KB)Numeric
IO Buffer Index Creation (KB)Numeric
IO Buffer Cache (KB)Numeric
IO Buffer Data Cache (KB)Numeric
IO Buffer Management (KB)Numeric
IO Buffer Unused (KB)Numeric
Changed Data Cache (KB)Numeric
OMS Data Cache (KB)Numeric
SQL Data Cache (KB)Numeric
History Data Cache (KB)Numeric
Used Pin Area Data Cache (KB)Numeric
SQL Request Timeout LocksNumeric
Used LocksNumeric
Lock EscalationsNumeric
Dead LocksNumeric
OMS Lock CollisionsNumeric
Row LocksNumeric
Maximum LocksNumeric
SQL Lock CollisionsNumeric
Used Entry Locks (%)Numeric
OMS Request Timeout LocksNumeric
Table LocksNumeric
Latest Backup Thread IDString
Latest Backup Thread NameString
Automatic Log BackupString
Latest Backup IO CountNumeric
Latest Backup IO Page CountNumeric
Latest Backup Pending IO CountNumeric
Latest Backup PathString
Latest Backup IO Time (MS)Numeric

Instance Columns:

Cache Statistic

MetricData Type
Cache StatisticString
Unsuccessful AccessNumeric
Successful AccessNumeric
AccessNumeric
Hit Rate (%)Numeric

Data Volume

MetricData Type
Data VolumeString
Data Volume (MB)Numeric
Used Data Volume (MB)Numeric
Used Data Volume (%)Numeric
Data Volume PathString

Log Volume

MetricData Type
Log VolumeString
Log Volume (MB)Numeric
Used Log Volume (MB)Numeric
Log Volume PathString
Used Log Volume (%)Numeric

Schema

MetricData Type
SchemaString
Schema Used (KB)Numeric
Total TablesNumeric

OMS Heap Allocator

MetricData Type
OMS Heap AllocatorString
OMS Heap Used (KB)Numeric
OMS Max Heap Usage (KB)Numeric
OMS Reserved Heap Memory (KB)Numeric

Resource Monitor ID

MetricData Type
Resource Monitor IDString
SQL QueryString
Called Count

This document was truncated here because it was created in the Evaluation Mode.