--- title: MaxDB description: Monitor volume, cache, schema, table and more from MaxDB databases breadcrumbs: Docs > Integrations > MaxDB --- # MaxDB Supported OS marketplace Database Status & Data/Log MetricsDatabase Cache MetricsSession, OMS, and Schema Metrics ## Overview{% #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{% #monitors %} 1. MaxDB Connection Check 1. MaxDB State 1. MaxDB Data Volume Usage 1. MaxDB Lock Utilization 1. MaxDB Log Area Usage ## Data Collected{% #data-collected %} ### Metrics{% #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{% #service-checks %} **rapdev.maxdb.can\_connect** Returns `OK` if the agent check is successful, or `CRITICAL` for errors. *Statuses: ok, critical* ## Support{% #support %} For support or feature requests, contact RapDev.io through the following channels: - Email: [support@rapdev.io](mailto:support@rapdev.io) - Chat: [rapdev.io](https://www.rapdev.io/#Get-in-touch) - Phone: 855-857-0222 This application is made available through the Marketplace and is supported by a Datadog Technology Partner. Click Here to purchase this application.