Skip to main content

Introduction to Database Monitoring

Isabella Russo
Updated

Applicable to Entuity v22.0 P07 upwards

 

Introduction

Monitored Objects within Databases

Database Instance Attributes & Metrics

Schemas/Tablespaces Attributes & Metrics

Engines Attributes

Jobs Attributes & Metrics

Supported events and incidents

Permission Requirements

Licensing

How do I manage databases and view their information?

 

 

Introduction:

From Entuity v22.0 P07 upwards, 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 specific to the new Database type.

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

 

 

Monitored Objects within Databases:

Entuity monitors the following objects within a database:

  • Database Instances
  • Schemas/Tablespaces
  • Engines
  • Jobs

 

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, i.e. MySQL, MariaDB, Oracle, MS SQL.
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 over 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.
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.
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, etc.)
State Detail This is a message string of the current state of the database instance.

 

Schemas/Tablespace Attributes & Metrics:

Attribute Description
Name The name of the schema/tablespace.
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.

 

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, etc.
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.

 

 

Supported events and incidents:

Databases have one of the following statuses:

  • Object state OK ENA.jpg - ‘OK’, indicates that the database returned to an OK state and the polling status is OK.
  • Object state warning ENA.jpg - 'Warning' threshold indicates the database is in a warning state.
  • Object state critical ENA.jpg - 'Critical' threshold indicates the database is in a critical/down state.
  • Object state admin down.jpg - Polling is disabled or a collector was not selected to actively monitor the database.
  • Object state unknown ENA.jpg - Polling failed.
  • Object state uninitialized ENA.jpg - 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
  • Job Status Incident
    • Job Status Error
    • Job Status Warning
    • Job Status OK

 

 

Permission requirements:

To access the Database Management page, you will require either Administrator rights or the Inventory Administration user permission. Please see this article for help and 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. Please see this article for further help and 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 via 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 enables you to view, add, edit, and remove databases for monitoring.

 

Dashboards and dashlets:

You can view database status information via the following dashboards:

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

Was this article helpful?

0 out of 0 found this helpful
Return to top

Related articles

Comments

0 comments

Please sign in to leave a comment.