Dameng DB monitoring tool

Overview

Dameng is a commercial relational database management system (RDBMS) know for it's high performance and scalability. Applications Manager's Dameng DB monitoring capabilities offer complete visibility into the performance of your Dameng DB servers. It helps you to monitor details of different transactions, sessions etc..and also allows to track various key metrics related to thread and bufferpool.

Creating a new Dameng database monitor

Supported Versions: DamengDB version 7 and above

Prerequisites for monitoring Dameng database metrics:Click here

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

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

Click on the New Monitor link. Choose Dameng DB from the Database Servers category.
Specify the Display Name of the Dameng DB.
Enter the Host Name/IP Address of the server where Dameng DB is running.
Provide the Port in which the Dameng DB is running. Default port number is 5236.
Enter the Username and Password, or select the required credentials from the Credential Manager list after enabling the Select from credential list option.
Specify the Timeout value in seconds. Default value is 40 seconds.
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 Dameng DB monitor (optional). You can choose multiple groups to associate your monitor with.
Click Add Monitor(s). This discovers the Dameng 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 Dameng database monitoring:

Overview

Parameters	Description
Database Details
Database Total Size	Total size of the database.(in KB)
Database Name	Name of the database.
Database Created Time	Time at which the database was created.
Instance Details
Instance Name	Instance name of the Dameng DB.
Host Name	Host name of the Dameng DB.
Version	Dameng DB version.
Start Time	Start time of the Dameng DB
Status	Status of the instance
Mode	Mode of the instance
Connection Time
Connection Time	Time interval for connecting the DB connection.
Transaction Details
Total Number of Active Transactions	Total Number of Active Transactions
Total Number of not started Transactions	Total Number of not started Transactions

Transaction

Parameters	Description
Transaction Details
Transaction ID	The unique transaction identifier.
Transaction Status	Current status of the transaction. Value can be ACTIVE, COMMITTED, ROLLING BACK, etc.
Transaction Performed User	The transaction performed by user.
Session ID	The unique session identifier associated with the transaction.
Isolation	Isolation level of the transaction. Value can be READ, COMMITTED, SERIALIZABLE etc.
Read Only	Indicates whether the transaction is read-only or not (YES or NO).
Rollback Flag	Indicates whether the transaction is rolling back (YES or NO).
Transaction Usage Details
Transaction ID	The unique transaction identifier.
Insert Query Count	Number of insert statements executed by the transaction.
Update Query Count	Number of update statements executed by the transaction.
Delete Query Count	Number of delete statements executed by the transaction.
Insert Update Query Count	Number of update statements that also insert rows executed by the transaction.
Undo Record Sequence Number	Unique identifier assigned to each undo record in undo log of the database.
Transaction Waiting State	Indicates whether the transaction is waiting for a resource (YES or NO).

Tablespace

Parameters	Description
Tablespace Details
TableSpace ID	The unique identifier of the tablespace.
Tablespace Name	The name of the tablespace.
TableSpace Type	The type of the tablespace.
Tablespace Status	The status of the tablespace.
Max Size(MB)	The maximum size of the tablespace (in MB).
Total Size(MB)	The total size of the tablespace (in MB).
File Number	The number of DataFiles in the tablespace.
Used Size(MB)	The amount of space used in the tablespace (in MB).
Data Files Usage Details
Data File Name	Name of the DataFiles.
Data Files Usage Details
Total Size(MB)	Total size of the DataFile (in MB).
Free Size(MB)	Free space available within each DataFile (in MB).
Used Size(MB)	The total amount of space currently used within each DataFile (in MB).
Used Percentage(%)	Percentage of used space within each DataFile (in %).
Data File Details
Data File Name	Name of the DataFiles.
Page Size(MB)	Page size used by the database system (in MB).
AutoExtend	Indicates whether the DataFile is set to automatically extend when more space is required.
Next Size(MB)	Specifies the size to which the DataFile will automatically extend when additional space is needed (in MB).
Max Size(GB)	Specifies the maximum size to which the DataFile can extend (in GB).
Client Path	The path where the client application accesses or expects to find the DataFile.
Mirror Path	The path where a mirrored or replicated copy of the DataFile exists for redundancy or backup purposes.

Session

Parameters	Description
Session Details
Session ID	The unique identifier of the session.
SQL Text	The SQL text of the currently executing SQL statement for the session.
Session State	The current state of the session. Value can be "INACTIVE", "WAITING", "RUNNING", or "KILLED".
Create Time	The timestamp when the session was created.
Auto Commit	The current state of the automatic commit for the session.
DDL Auto	The current state of automatic commit for DDL (Data Definition Language) statements for the session.
Application Name	The name of the application associated with the session.
Session Details Graph
Total Number of Active Sessions	Total number of active sessions.
Total Number of Idle Sessions	Total number of idle sessions.
Total Sessions	Total number of sessions.
Max Sessions	The maximum number of sessions allowed.
Total CPU Count	The total number of CPUs available.
Session Used Percentage	The percentage of available sessions that are currently being used.
Active Session by CPU	The number of active sessions per CPU.
Session Client Details
Session ID	The unique identifier of the session.
Current Schema	The name of the schema currently being used by the session.
Connection Type	The connection type of the session.
Login User	Name of the user associated with the session.
Client Type	The client type of the session.
Client Host	The host name of the client machine from which the session is connected.
OS Name	The name of the operating system of the client machine from which the session is connected.
Client IP	The IP address of the client machine from which the session is connected.

Thread

Parameters	Description
Thread Details
Thread ID	The unique identifier for each thread in the database instance.
Thread Name	The name of each thread in the database instance.
Start Time	The time when the thread was started.
Thread Description	Description about the thread including information about the type of thread, its purpose etc..

BufferPool

Parameters	Description
BufferPool Details
BufferPool ID	The unique identifier for each buffer pool in the database instance.
BufferPool Name	The name of each buffer pool in the database instance.
Total Number of Logical Reads	The number of logical reads that have been performed on the buffer pool.
Total Number of Physical Reads	The number of physical reads that have been performed on the buffer pool.
Total Number of Physical MultiBlock Reads	The number of physical reads that have been performed on the buffer pool for multiblock reads.
Hit Ration(%)	The percentage of requests for buffer pool pages that were satisfied from the buffer pool without performing an I/O operation.
BufferPool Page Details
BufferPool ID	The unique identifier for each buffer pool in the database instance.
BufferPool Name	The name of each buffer pool in the database instance.
Page Size	The size of each page in the buffer pool.
Total Number of Pages	The total number of pages in the buffer pool.
Total Number of Fixed Pages	The number of pages in the buffer pool that are currently fixed in memory.
Total Number of Free Pages	The number of free pages in the buffer pool.
Total Number of Dirty Pages	The number of dirty pages in the buffer pool.
Total Number of Clear Pages	The number of clear pages in the buffer pool.
Max Pages	The maximum number of pages that can be in the buffer pool.
Total Number of Discarded Pages	The number of pages that have been discarded from the buffer pool.

Log

Parameters	Description
Log Details
Sequence Number	The sequence number of each log entry.
Process ID	The process ID of the log entry.
Log Time	The timestamp of when the log entry was recorded.
Thread Name	The name of the thread that logged the event.
Level	The log level of the message. Value can be ERROR, WARNING, INFO, etc.
Count	The number of times each distinct log message has occurred.
Text	The log message carried by the entry.

Replication

Parameters	Description
Link Status
Source Name	The name of the source database configured for archive log management.
Source Mode	The mode of the source database.
Source Hostname	The hostname of the source database server.
Source IP	The public IP address of the source database server.
Source Port	The port number used by the source database for communication.
Target Hostname	The name of the target database for the archive log configuration.
Archive Status	The status of the archive log shipping process.
Control Link Status	The status of the control file link.
Data Link Status	The status of the data link.
Permanent Magic Number	The Magic number or identifier associated with the Dameng database.
Database Magic Number	The Magic number or identifier associated with the database instance.
Lag Details
Sequence Number	The sequence number associated with the application of redo or archive logs during the apply process.
Apply Lag	The lag time (in minutes) between the time the last commit was made on the source database and the time it was applied on the target (standby) database.
Last Commit Time	The timestamp of the last commit on the source (primary) database.
Apply Commit Time	The timestamp indicating when the last commit was applied to the target (standby) database.
Total Apply Time	The total time spent applying redo/archived logs.
Total Wait Time	TThe total time spent waiting in the apply process.
Max Apply Time	The maximum time spent on applying a single transaction or redo log.
Max Wait Time	The maximum wait time experienced during the apply process.

Dameng DB monitoring tool

Overview

Creating a new Dameng database monitor

Monitored Parameters

Overview

Transaction

Tablespace

Session

Thread

BufferPool

Log

Replication

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