MaxDB

Supported OS Linux Windows Mac OS

marketplace

Overview

The MaxDB integration monitors data and log areas and volumes, caches, sessions, locks, and other metrics for MaxDB instances to ensure the databases are running as they should be. The integration comes with a dashboard which can be filtered by database, as well as database host. The MaxDB integration also comes with monitors for some common metrics that relate to the overall health of the database.

Monitors

  1. MaxDB Connection Check
  2. MaxDB State
  3. MaxDB Data Volume Usage
  4. MaxDB Lock Utilization
  5. MaxDB Log Area Usage

Data Collected

Metrics

rapdev.maxdb.backup.io_operations
(gauge)
Number of I/O Operations of the latest or current backup
rapdev.maxdb.backup.io_pages
(gauge)
Number of pages written during the I/O operation of the backup
rapdev.maxdb.backup.io_time
(gauge)
The total time spent on the I/O operations
rapdev.maxdb.backup.pending_io_operations
(gauge)
The number of pending I/O operations
rapdev.maxdb.cache.accesses
(gauge)
Total number of accesses to the cache
rapdev.maxdb.cache.hit_rate
(gauge)
Rate at which accesses to the cache were hits
rapdev.maxdb.cache.hits
(gauge)
Total number of hits to the cache
rapdev.maxdb.cache.miss_rate
(gauge)
Rate at which accesses to the cache were misses
rapdev.maxdb.cache.misses
(gauge)
Total number of misses to the cache
rapdev.maxdb.catalog_cache.entrycount
(gauge)
Number of objects currently in the catalog cache
rapdev.maxdb.catalog_cache.invalid_entrycount
(gauge)
Number of objects marked as invalid currently in the catalog cache
rapdev.maxdb.catalog_cache.lru_entrycount
(gauge)
Number of entries corrently stored in the LRU list
rapdev.maxdb.command_cache.usable_size
(gauge)
Size of the command cache
Shown as byte
rapdev.maxdb.command_cache.used_size
(gauge)
Size of the area of the command cache that is actually used
Shown as byte
rapdev.maxdb.command_cache.in_use
(gauge)
Size of the area of the command cache that is actually used (%)
rapdev.maxdb.command_cache.command_count
(gauge)
Number of stored commands
rapdev.maxdb.command_cache.insert_command
(gauge)
Number of inserts
rapdev.maxdb.command_cache.delete_command
(gauge)
Number of deletes
rapdev.maxdb.command_cache.cleanup
(gauge)
Number of operations that encountered a lack of space in the main memory
rapdev.maxdb.command.execute_count
(gauge)
Number of executions of a specific SQL statement
rapdev.maxdb.command.io_reads
(gauge)
Number of read calls requested during execution of this SQL statement and done by I/O thread
rapdev.maxdb.command.io_writes
(gauge)
Number of write calls during execution of this SQL statement and done by an I/O thread
rapdev.maxdb.command.pages_read
(gauge)
Number of pages read during execution of this SQL statement
rapdev.maxdb.command.pages_written
(gauge)
Number of pages written during the execution of this SQL statement
rapdev.maxdb.command.physical_reads
(gauge)
Number of reads in the data cache that triggered reads on the disk
rapdev.maxdb.command.rows_read
(gauge)
Number of rows read during execution of this SQL statement
rapdev.maxdb.command.runtime
(gauge)
Kernel execution time for this SQL statement (microseconds)
Shown as microsecond
rapdev.maxdb.command.total_io
(gauge)
Total number of read and write calls during execution of this SQL statement and done by an I/O thread
rapdev.maxdb.command.virtual_reads
(gauge)
Number of virtual reads during execution of this SQL statement
rapdev.maxdb.data_cache.usable_size
(gauge)
Size of the data cache
Shown as byte
rapdev.maxdb.data_cache.used_size
(gauge)
Used area of the data cache
Shown as byte
rapdev.maxdb.data_cache.oms_size
(gauge)
Size of the area of the data cache that is used for storing the OMS data
Shown as byte
rapdev.maxdb.data_cache.history_size
(gauge)
Size of the area of the data cache that is required for consistent reads and transaction management
Shown as byte
rapdev.maxdb.data_cache.sql_size
(gauge)
Size of the area of the data cache that is not required either for OMS or for consistent reads and transaction management
Shown as byte
rapdev.maxdb.data_cache.pinarea_used_size
(gauge)
Size of the area of the data cache that is used for storing data which should not be replaced
Shown as byte
rapdev.maxdb.data_cache.pinarea.usable_size
(gauge)
Maximim size of the data cache that could be used for data which should not be replaced
Shown as byte
rapdev.maxdb.data_cache.in_use
(gauge)
Memory in data cache that is actually used (%)
rapdev.maxdb.data_cache.pinarea.in_use
(gauge)
Memory in data cache pinarea that is actually used (%)
rapdev.maxdb.data_volume.in_use
(gauge)
Area of the volume used as a percentage of the total area that can be used for data (%)
rapdev.maxdb.data_volume.usable_size
(gauge)
Area of the volume that can be used for data
Shown as byte
rapdev.maxdb.data_volume.used_size
(gauge)
Area of the volume used for data
Shown as byte
rapdev.maxdb.data.free
(gauge)
Memory in data are that is available to store data (%)
rapdev.maxdb.data.free_size
(gauge)
Memory in data area that is available to store data
Shown as byte
rapdev.maxdb.data.in_use
(gauge)
Memory in data area that is actually used for data (%)
rapdev.maxdb.data.pending_incremental_backup_size
(gauge)
Amount of data that needs to be backed up in next incremental backup
Shown as byte
rapdev.maxdb.data.permanent_converter_data_used
(gauge)
Total amount of permanent converter data in the active converter (disregarding shadow storage data and the converter data which belongs to a snapshot)
Shown as byte
rapdev.maxdb.data.permanent_data_used
(gauge)
Data area used for permanent data
Shown as byte
rapdev.maxdb.data.shadow_used_size
(gauge)
Amount of shadow storage data which can be released at the next savepoint
Shown as byte
rapdev.maxdb.data.temporary_converter_data_used
(gauge)
Amount of temporary converter data
Shown as byte
rapdev.maxdb.data.temporary_data_used
(gauge)
Data area used for temporary data
Shown as byte
rapdev.maxdb.data.usable_size
(gauge)
Data area available for data
Shown as byte
rapdev.maxdb.data.used_size
(gauge)
Memory in data area that is actually used for data
Shown as byte
rapdev.maxdb.db_state
(gauge)
State of the database expressed as an integer where each integer represents a different state
rapdev.maxdb.locks.available
(gauge)
Number of entries available for locks and lock requests
rapdev.maxdb.locks.deadlocks
(gauge)
Number of dead locks recognized
rapdev.maxdb.locks.lock_escalations
(gauge)
Number of lock escalations executed
rapdev.maxdb.locks.oms_collisions
(gauge)
Number of lock collisions for OMS objects
rapdev.maxdb.locks.oms_timeouts
(gauge)
Number of unfulfilled lock requests for OMS objects
rapdev.maxdb.locks.row_locks
(gauge)
Number of row locks held
rapdev.maxdb.locks.sql_collisions
(gauge)
Number of lock collisions for SQL database objects
rapdev.maxdb.locks.sql_timeouts
(gauge)
Number of unfulfilled lock requests for SQL database objects
rapdev.maxdb.locks.table_locks
(gauge)
Number of table locks held
rapdev.maxdb.locks.used
(gauge)
Number of lock entries used
rapdev.maxdb.locks.utilization
(gauge)
Percentage of lock entries used
rapdev.maxdb.log.in_use
(gauge)
Used log area (%)
rapdev.maxdb.log.not_saved
(gauge)
Size of log area not yet saved (%)
rapdev.maxdb.log.not_saved_size
(gauge)
Size of log area not yet saved
Shown as byte
rapdev.maxdb.log.queue_size
(gauge)
Size of the log queue
Shown as byte
rapdev.maxdb.log.usable_size
(gauge)
Size of the log area
Shown as byte
rapdev.maxdb.log.used_size
(gauge)
Used log area
Shown as byte
rapdev.maxdb.log_volume.usable_size
(gauge)
Area of the volume that can be used for log entries
Shown as byte
rapdev.maxdb.oms_heap.reserved_size
(gauge)
Memory managed by the allocator
Shown as byte
rapdev.maxdb.oms_heap.used_size
(gauge)
Currently used memory
Shown as byte
rapdev.maxdb.oms_heap.utilization
(gauge)
Currently used memory of the total heap allocated (%)
rapdev.maxdb.schema.used_size
(gauge)
Space used for tables and indexes that belong to the schema
Shown as byte
rapdev.maxdb.session.catalog_cache_used_size
(gauge)
Space used by the catalog cache assigned to the database session
Shown as byte
rapdev.maxdb.session.count
(gauge)
Total number of sessions
rapdev.maxdb.session.oms_heap_used_size
(gauge)
Memory consumption in the OMS heap
Shown as byte
rapdev.maxdb.session.paging_file_used_size
(gauge)
Size of the paging file in which information displaced from the catalog cache is written
Shown as byte
rapdev.maxdb.session.temp_used_size
(gauge)
Space used for temporary information from your database session
Shown as byte
rapdev.maxdb.session.utilization
(gauge)
Number of active sessions as a percentage of the total number of sessions allowed by the database (%)
rapdev.maxdb.table.row_count
(gauge)
Number of rows in the table
rapdev.maxdb.table.used_size
(gauge)
Space used by the table
Shown as byte
rapdev.maxdb.uptime
(gauge)
Amount of time the database has been in an online or admin state
Shown as second

Service Checks

rapdev.maxdb.can_connect

Returns OK if the agent check is successful, or CRITICAL for errors.

Statuses: ok, critical

Support

For support or feature requests, contact RapDev.io through the following channels:


This application is made available through the Marketplace and is supported by a Datadog Technology Partner. Click Here to purchase this application.