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.
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 individual monitors listed to view the following information. Following are the list of metrics that are monitored in Dameng database monitoring:
| 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 |
| Session Details | |
| Total Number of Active Sessions | Total Number of Active Sessions |
| Total Number of Idle Sessions | Total Number of Idle Sessions |
| 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). |
| 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. |
| 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 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. |
| 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.. |
| 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. |
