Applicable to v23.0 P01 upwards. If you are using an earlier version of Entuity, see version 1 of this article.

Support for Cloud-Based and Cluster Databases

Database Instance Attributes & Metrics

Schemas/Tablespaces Attributes & Metrics

Nodes Attributes

Engines Attributes

Jobs Attributes & Metrics

Tables Attributes & Metrics

Supported events and incidents

Permission Requirements

Licensing

How do I manage databases and view their information?

Introduction:

You can monitor databases and their performance metrics. This works by connecting to the database and executing various SQL queries to collect data for streams and attributes that are specific to the new Database type.

You can manage databases from the Database Management page, and view data for them from the Database Summary dashboard and the summary dashboard.

The Database Summary dashboard and the summary dashboard dynamically display different charts, based on the type of database you are viewing (Oracle, MySQL, MongoDB, and so on). The data displayed is specific to the collector being used by the database.

Support for Cloud-Based and Clustered Databases

Entuity supports monitoring the Azure SQL cloud-based database instance and the following clustered database instances:

Oracle Data Guard
MySQL Replication
SQL Database Nodes
PostgreSQL Replica Database
MongoDB Nodes

For each clustered database instance, you can view replication and fallback node information.

For information on the supported on-prem database types and polling prerequisites for each database type, s ee this article.

Monitored Objects within Databases:

Entuity monitors the following objects within a database:

Database Instances
Schemas/Tablespaces
Nodes
Engines
Jobs
Tables

Database Instance Attributes & Metrics:

Attribute	Description
Backup Timestamp	Timestamp of the last backup that was taken.
Path	The directory path where the database resides.
Recovery Model	The type of recovery model of the database such as SIMPLE.
System Version	The system version of the database.
Type	The type of database, for example, MySQL, MariaDB, MongoDB, PostgreSQL, Oracle, and so on.
Version	The version of the database.
Average Query Time	Average time for a query to execute in milliseconds on the database instance.
Buffer Cache Hit Rate	The buffer cache hit rate on the database instance within the last 5 minutes.
Connections Active	Number of connections active on the database.
Connections Attempted	Number of connection attempts on the database.
Connection Errors	Number of connection errors on the database.
Connection Errors Rate	The rate of connection errors on the database within the last 5 minutes.
Connections Max Limit	The max limit of connections allowed on the database.
Connections Usage Rate	The rate of connections being currently active compared to the max.
IO Latency Misc.	The misc. IO latency in milliseconds on the database within the last 5 minutes.
IO Latency Read	The read IO latency in milliseconds on the database within the last 5 minutes.
IO Latency Write	The write IO latency in milliseconds on the database within the last 5 minutes.
IOPS Misc.	The number of misc. IOPS on the database within the last 5 minutes.
IOPS Read	The number of read IOPS on the database within the last 5 minutes.
IOPS Write	The number of write IOPS on the database within the last 5 minutes.
IOPS Total	The number of total IOPS on the database within the last 5 minutes.
Lock Contention Rate	The lock contention rate on the database.
Lock Waits	The number of lock waits on the database within the last 5 minutes.
MBPS Received	The number of MBPS received on the database within the last 5 minutes.
MBPS Sent	The number of MBPS sent on the database within the last 5 minutes.
MBPS Total	The number of MBPS total on the database within the last 5 minutes.
Memory Size Allocated	Total memory size allocated for the database instance.
Memory Size Total	Total memory size allocated for the database instance.
Memory Size Used	Total memory size used within the database instance as bytes.
Memory Size Used Percent	Total memory size used within the database instance as a percentage.
Processor Utilization	Total processor utilization for the database instance as a percentage.
Query Latency Delete	The latency in milliseconds for delete queries executed on the database within the last 5 minutes.
Query Latency Fetch	The latency in milliseconds for fetch queries executed on the database within the last 5 minutes.
Query Latency Insert	The latency in milliseconds for insert queries executed on the database within the last 5 minutes.
Query Latency Update	The latency in milliseconds for update queries executed on the database within the last 5 minutes.
Query Rate	The rate of queries being executed on the database within the last 5 minutes.
Remaining Log Space	The total amount of log space remaining within the database instance as bytes.
Remaining Space	The total amount of space remaining within the database instance as bytes.
Replication Enabled	Whether replication is enabled for the database instance.
Replication Status	The replication status for the database instance.
Remaining Space Percent	The total amount of space remaining within the database instance as a percentage.
Slow Queries	The number of slow queries executed on the database within the last 5 minutes.
State Latency	The state latency in milliseconds of the database within the last 5 minutes.
Throughput Received, per second	The total number of transactions received by the database, per second.
Throughput Sent, per second	The total number of transactions sent by the database, per second.
Throughput Total, per second	The total number of database transactions, both sent and received, per second.
Total Space	The total amount of space on the database.
Uptime	The total time the database has been online.
Used Space	The total amount of space used within the database instance as bytes.
Used Space Percent	The total amount of space used within the database instance as a percentage.
State	The current state of the database instance (OK, Warning, Error, and so on)
State Detail	This is a message string of the current state of the database instance.

Schemas/Tablespace Attributes & Metrics:

Attribute	Description
Display Name	The name of the schema/tablespace, as displayed in the UI.
Average Query Time	Average time for a query to execute in milliseconds on the schema.
Buffer Allocated	The total amount of buffer space allocated for the schema as bytes.
Buffer Data	The total amount of buffer space data for the schema as bytes.
Buffer Pages	The total number of buffer pages allocated for the schema.
Buffer Pages Cached	The total number of cached buffer pages for the schema.
Buffer Pool Free	The total amount of buffer space free for the schema as bytes.
Buffer Rows Cached	The total number of cached buffer rows for the schema.
Indexes	The total amount of indexes on the schema.
IO Latency Misc.	The misc. IO latency in milliseconds on the schema within the last 5 minutes.
IO Latency Read	The read IO latency in milliseconds on the schema within the last 5 minutes.
IO Latency Write	The write IO latency in milliseconds on the schema within the last 5 minutes.
IOPS Misc.	The number of misc. IOPS on the schema within the last 5 minutes.
IOPS Read	The number of read IOPS on the schema within the last 5 minutes.
IOPS Write	The number of write IOPS on the schema within the last 5 minutes.
IOPS Total	The number of total IOPS on the schema within the last 5 minutes.
Query Latency Delete	The latency in milliseconds for delete queries executed on the schema within the last 5 minutes.
Query Latency Fetch	The latency in milliseconds for fetch queries executed on the schema within the last 5 minutes.
Query Latency Insert	The latency in milliseconds for insert queries executed on the schema within the last 5 minutes.
Query Latency Update	The latency in milliseconds for update queries executed on the schema within the last 5 minutes.
Query Rate	The rate of queries being executed on the schema within over 5 minutes.
Space Allocated	The total amount of space allocated on the schema.
Unused Indexes	The total amount of unused indexes on the schema.
Used Space	The total amount of space used within the schema, as bytes.
Used Space Percent	The total amount of space used within the schema, as a percentage.

Nodes Attributes:

Attribute	Description
Display Name	The name of the database node, as displayed in the UI.
Mode	The operational mode of the database node.
Role	The role that the database node assumes in the clustered database.

Engines Attributes:

Attribute	Description
Description	The description of the database engine.
Name	The name of the database engine.

Jobs Attributes & Metrics:

Attribute	Description
Host	The owning host of the job.
Name	The name of the job.
Schema	The schema that the job belongs to.
Type	The type of database job it is, such as a stored procedure, local, and so on.
Duration	The duration of time the job ran in milliseconds.
Last Executed	The last executed timestamp the job ran.
Status	The current status of the job.

Tables Attributes & Metrics:

Note, to avoid potential scalability issues, Entuity doesn't automatically monitor all tables in a database, by default. Instead, you can add the specific database tables that you want to monitor in Entuity when you add a database on the Database Management page.

Attribute	Description
Display Name	The name of the database table, as displayed in the UI.
Schema	The schema to which the database table belongs.
Status	The current status of the database table.
Total Space	The total amount of space on the database table.
Used Space	The total amount of space used within the database table, as bytes.
Used Space Percent	The total amount of space used within the database table, as a percentage.

Supported events and incidents:

Databases have one of the following statuses:

- ‘OK’, indicates that the database returned to an OK state and the polling status is OK.
- 'Warning' threshold indicates the database is in a warning state.
- 'Critical' threshold indicates the database is in a critical/down state.
- Polling is disabled or a collector was not selected to actively monitor the database.
- Polling failed.
- First poll has not yet run.

Incidents and Events:

Database Polling Failure Incident
- DB Polling Error
- DB Polling Warning
- DB Polling OK
Database High Connection Errors Rate Incident
- Database High Connection Errors Rate Alarm (relative to threshold).
- Database High Connection Errors Rate Warning (relative to threshold).
- Database High Connection Errors Rate Cleared
Database Connection Usage High (%) Incident
- Database High Connection Usage Rate Alarm (relative to threshold).
- Database High Connection Usage Rate Cleared
Database High Processor Utilization Incident
- Database High Processor Utilization Alarm (relative to threshold).
- Database High Processor Utilization Warning (relative to threshold).
- Database High Processor Utilization Cleared
Database High Memory Utilization Incident Cleared
- Database High Memory Usage Alarm (relative to threshold).
- Database High Memory Usage Warning (relative to threshold).
- Database High Memory Usage Cleared
Database High Lock Contention Rate Incident
- Database High Lock Contention Rate Alarm (relative to threshold).
- Database High Lock Contention Rate Warning (relative to threshold).
- Database High Lock Contention Rate Cleared
Database Low Remaining Log Space Incident
- Database Low Remaining Log Space Alarm (relative to threshold).
- Database Low Remaining Log Space Warning (relative to threshold).
- Database Low Remaining Log Space Cleared
Database Low Buffer Cache Hit Ratio Incident
- Database Low Buffer Cache Hit Ratio Alarm (relative to threshold).
- Database Low Buffer Cache Hit Ratio Warning (relative to threshold).
- Database Low Buffer Cache Hit Ratio Cleared
Database Replication Problem Incident
- Database Replication Error
- Database Replication Warning
- Database Replication OK
Job Status Incident
- Job Status Error
- Job Status Warning
- Job Status OK

Permission requirements:

To access the Database Management page, you must have either 'Administrator' rights or the 'Inventory Administration' user permission. See this article for more information on user permissions in Entuity.

If you do not have these requisite user permissions, you will still be able to view the dashboards relating to database management.

You can specify which Views the databases are in, by which you can restrict which databases can be seen, based on which users have access to those Views.

Licensing:

Each individual database consumes one Full Device license credit. See this article for more information on licensing in Entuity.

A database does not need to be taken under asset management by Entuity as would a device. Instead, it is added as a Database type object from the Database Management page. A database is also not linked to any device or server.

How do I manage databases and view their information?

Database Management page:

The Database Management page lets you view, add, edit, and remove databases for monitoring.

Dashboards and dashlets:

You can view database status information from the following dashboards:

Database Monitoring dashboard (in the context of a View)
Summary dashboard (in the context of a database object)
Attributes dashboard (in the context of a database object)

Introduction to Database Monitoring

Introduction:

Support for Cloud-Based and Clustered Databases