Kingbase DB monitoring tool

Overview

Kingbase is a comprehensive database management system designed to meet the needs of enterprise-level applications. Monitoring your Kingbase database is crucial for maintaining database performance, ensuring security, and preventing downtime. By implementing Applications Manager's Kingbase DB monitoring tool, you can ensure the reliability, performance, and security of your Kingbase DB environment.

Creating a new Kingbase database monitor

Prerequisites for monitoring Kingbase database metrics:Click here

Using the REST API to add a new Kingbase database monitor:Click here

To create a Kingbase database monitor, follow the steps given below:

Click on the New Monitor link. Choose Kingbase DB from the Database Servers category.
Specify the Display Name of the Kingbase DB.
Enter the Host Name/IP Address of the server where Kingbase DB is running.
Provide the Port in which the Kingbase DB is running. Default port number is 54321.
Enter the Username and Password, or select the required credentials from the Credential Manager list after enabling the Select from credential list option.
Check the SSL is enabled checkbox if SSL authentication is enabled for Kingbase database.
Enter the Polling Interval time in minutes. Default value is 5 minutes.
Choose the Monitor Group from the combo box with which you want to associate Kingbase DB monitor (optional). You can choose multiple groups to associate your monitor with.
Click Add Monitor(s). This discovers the Kingbase DB from the network and starts monitoring them.

Monitored Parameters

Availability tab gives the Availability history for the past 24 hours or 30 days.
Performance tab gives the Health Status and events for the past 24 hours or 30 days.
List view enables you to perform bulk admin configurations.

Click on the individual monitors listed to view the following information. Following are the list of metrics that are monitored in Kingbase database monitoring:

Overview

Parameters	Description
CONNECTION TIME
Connection Time	Time interval for connecting the DB connection.
CONNECTION STATISTICS
Active Connections	Number of currently active connections to the database.
Total Users	The total number of users active at the time of data collection.
CONNECTIONS USED
Connections Used	The total number of connections used at the time of data collection.
LOCK STATISTICS
Locks Held	Number of locks held by the indicated session.
Locks Wait	Number of locks waiting in the database.
BUFFER STATISTICS
Buffer Hits/min	Total buffer hits (i.e., block read requests avoided by finding the block already in buffer cache) per minute.
Block Reads/Min	Total disk blocks read per minute.
Cache Hit Ratio	The current ratio of buffer cache hits to total requests.
DISK USAGE DETAILS
Disk Usage	Size of the on-disk representation of all tables in the database in MB.
Index usage	Size of the on-disk representation of all indexes in the database in MB.
INDEX SCAN DETAILS
Index scans/min	Total number of index scans initiated per minute.
Index Reads/min	Total number of index entries returned by index scans per minute.
Index Fetches/min	Total number of live table rows fetched by simple index scans per minute.
QUERY STATISTICS
Row Inserts/min	Total number of rows inserted per minute.
Row Updates/min	Total number of rows updated per minute.
Row Deletes/min	Total number of rows deleted per minute.
TRANSACTION DETAILS
Total Commits	Total number of transactions committed.
Total Rollbacks	Total number of transactions rolled back.
Commits/Min	Total number of transactions committed per minute.
Rollbacks/Min	Total number of transactions rolled back per minute.
TABLE LEVEL SCAN DETAILS
Sequential Scans/min	Total number of sequential scans per minute.
Table Index Scans/min	Total number of index scans per minute.
Sequential Scan Rows Read/min	Total number of rows returned by sequential scans per minute.
Table Index Scan Rows Read/min	Total numbers of rows returned by index scans per minute.

Performance

Parameter	Description
Top 10 Queries by CPU
Database Name	The database name under which the query has been executed.
Total CPU Time(ms)	The cumulative total amount of CPU time that has been spent in running the query (in millisecond).
Max CPU Time(ms)	The maximum amount of time that was taken by the CPU to run the query (in millisecond).
Average CPU Time(ms)	The average CPU time taken to execute the query (in millisecond).
Query	The SQL query which consumed the maximum CPU time.
Long Running Query Details
Process ID	The identifier for the process caused by the query.
Runtime	Amount of time for which the query has been running (in minutes).
User Name	Name of the user executing the query.
Query	The SQL query that was running.
Database Name	The database name under which the query has been running.
Top 50 Table Row Details
Table Name	Name of the table.
No. of Rows	Number of rows available in the table.
Table Size	Size of the table (in MB).
Used Size(MB)	Size of the used space(in MB).
Free Size(MB)	Size of the free space (in MB).
Used Size(%)	Size of the used space in percentage.
Free Size(%)	Size of the free space in percentage.
Top 10 Table By Dead Tuples Percentage
Schema Name	The name of the schema where the table resides.
Table Name	The name of the table.
Data Length(MB)	The total size of the table's data (in MB).
Index Length(MB)	The size of the table's indexes (in MB).
Live Tuples	Number of live tuples (rows) in the table.
Dead Tuples	Number of dead tuples (rows that have been marked for deletion but not yet vacuumed).
Dead Tuple Percentage(%)	Percentage of Dead Tuples.
Days Since Last Vacuum	Days passed since the last VACUUM operation performed on the table.
Last Vacuum	Timestamp of the last VACUUM operation performed on the table.
Days Since Last Auto Vacuum	Days passed since the last automatic VACUUM operation performed on the table.
Last Auto Vacuum	Timestamp of the last automatic VACUUM operation performed on the table.

Database

Parameter	Description
DATABASE DETAILS
Database Name	Name of the database instance.
DB Size	Size of the database instance (in MB).
Connections	Number of connections for the database instance.
TableSpace	Name of the tablespace.
TABLESPACE DETAILS
Name	Name of the tablespace.
Owner	Owner who created the tablespace.
Location	Location where the tablespace is created.
Size	Current size of the tablespace (in MB).

Session

Parameter	Description
SESSION DETAILS
Process ID	Displays the process ID of the session running in the Kingbase server.
Client Address	IP address of the client connected to the server.
Application Name	The name of the application that has established the session.
Database Name	Displays the name of the database currently being used by the process.
User	The login name of the user executing the process.
State	The state of the process in the Kingbase server.
Blocked	Indicates whether the process is blocked or is currently waiting on lock.
Wait Event	Displays the Wait Event Name and Wait Event Type that is currently waiting.
Query	The SQL query that was last executed in the process.
CPU Time(ms)	The cumulative CPU time taken for the process running in the Kingbase server (in millisecond).
USER PROFILE DETAILS
User ID	Unique OID of the user.
User Name	Username of the user.
Role Name	Privilege assigned to the user.
Super User	User has Super user privilege or not. Possible values: True/ False.
CreateDB Allowed	User has the privilege to create the DB. Possible values: True/ False.
Replication User	User has is Replication User previlege or not. Possible values: True/ False.
Expired Days	Number of days until the password expiry.
Expired Time	Expire time of the Password

Lock

Parameter	Description
Locked Table Details
Process ID	The unique ID of the process.
Table Name	Name of the table.
Lock Type	The type of lock held. Possible Values: relation/ tuple/ page/ extend/ access share/ row share/ row exclusive etc..
Page	Page number within the table's data file.
Virtual Transaction	Represents the identifier for the virtual transaction holding the lock.
Mode	Lock mode indicates the specific type and level of lock held.
Granted Access	Boolean value (true or false) indicating whether the lock has been granted (true) or is waiting (false).
Blocked Session Details
Process ID	Process ID (PID) of the session that is currently blocked.
User Name	Username of the session that is blocked (blocked_pid).
Blocked Session by Process ID	Array of PIDs of sessions that are blocking the session identified by PID.
Blocked Query	Current query being executed by the session that is blocked.

Replication

Parameter	Available Versions	Description
SLAVE DETAILS
Client Address	>=9.2	Address of client/standby server address.
PID	>=9.2	Process ID of a WAL sender process.
application name	>=9.2	Name of the application that is connected to this WAL sender.
Client Port	>=9.2	TCP port number that the client is using for communication with this WAL sender.
Sender State	>=9.2	Current WAL sender state. Possible values are: startup: This WAL sender is starting up. catchup: This WAL sender's connected standby is catching up with the primary. streaming: This WAL sender is streaming changes after its connected standby server has caught up with the primary. backup: This WAL sender is sending a backup. stopping: This WAL sender is stopping.
Sync State	>=9.2	Synchronous state of this standby server. Possible values are: async: This standby server is asynchronous. potential: This standby server is now asynchronous, but can potentially become synchronous if one of the current synchronous ones fails. sync: This standby server is synchronous. quorum: This standby server is considered as a candidate for quorum standbys.
Sending lag(KB)	>=9.2	Lag in sending the transactions to standby
Receiving lag(KB)	>=9.2	Lag in receiving the transactions on standby
Replaying lag	>=9.2	Lag in replaying the transactions on standby
Total delay	>=9.2	Total delay sending from master to replaying transaction on standby.
Replication delay	>=9.2	Total delay in replicating the transactions on standby.
REPLICATION SLOTS
slot_name	>=9.6	A unique, cluster-wide identifier for the replication slot.
slot_type	>=9.6	The slot type - physical or logical.
active	>=9.6	True if this slot is currently actively being used.
restart_lsn	>=9.6	The address (LSN) of oldest WAL which still might be required by the consumer of this slot and thus won't be automatically removed during checkpoints.
confirmed_flush_lsn	>=9.6	The address (LSN) up to which the logical slot's consumer has confirmed receiving data. Data older than this is not available anymore. NULL for physical slots.

Configuration

Parameter	Description
Version	Version of the Kingbase Server.
Config File	Location of Kingbase server configuration file.
Data Directory	Location of data directory used by the Kingbase server.
External PID File	Location of external PID file.
hba File	Location of hba file.
ident File	Location of ident file.
Maximum Connections	The maximum number of connections in the Kingbase Server.

Kingbase DB monitoring tool

Overview

Creating a new Kingbase database monitor

Monitored Parameters

Overview

Performance

Database

Session

Lock

Replication

Configuration

Loved by customers all over the world

"Standout Tool With Extensive Monitoring Capabilities"

"I like Applications Manager because it helps us to detect issues present in our servers and SQL databases."

Carlos Rivero

Trusted by over 6000+ businesses globally