ManageEngine OpManager is a comprehensive network management software for heterogeneous, multi-vendor enterprise IT networks. It offers advanced fault and performance management functionality across critical IT resources viz. network devices, WAN or VoIP links, servers, virtual servers, Domain controllers, MS Exchange, MS SQL and other IT infrastructure components.
Applications Manager provides you with critical information (like CPU and memory usage, thread count and PGSQL database details) essential to track the performance of OpManager. Get instant notifications when there are performance issues. Become aware of performance bottlenecks and take quick remedial actions before your end users experience issues.
Mode of Monitoring: Remote JMX
For PGSQL DB, statistics will be collected by connecting to the database.
Prerequisites for monitoring ManageEngine OpManager: Click here
Using the REST API to add a new OpManager monitor: Click here
To create an ManageEngine OpManager Monitor, follow the steps given below:
Note:
In case you are unable to add the monitor even after enabling JMX, try providing the below argument:
-Djava.rmi.server.hostname=[YOUR_IP]
Go to the Monitors Category View by clicking the Monitors tab. Click on ME OpManager under the Web Server/ ServicesTable. Displayed is the OpManager bulk configuration view distributed into three tabs:
Parameter | Description |
---|---|
Thread Details | |
Thread Count | The total number of threads created and also started since the Java virtual machine started. |
Threads in Running State | The total number of threads executing in the Java virtual machine in running state. |
Threads in Waiting State | The total number of threads in the Java virtual machine in waiting state. |
Blocked Threads | A thread that is blocked waiting for a monitor lock is in this state. |
Timed Waiting Threads | A thread that is waiting for another thread to perform an action, for up to a specified waiting time is in this state. |
Deadlock Threads | The number of threads that are in deadlock waiting to acquire object monitors. |
Memory Details | |
Name | The Heap Memory/ Non- Heap Memory usage in MB. |
Commited Memory | The current allocated memory in MB. |
Total Memory | The total allocated memory in MB. |
Used Memory | The current used memory in MB. |
Free Memory | The current free memory in MB. |
CPU Details | |
CPU Usage | This indicates the CPU usage of the JVM on the server. |
ATTRIBUTE NAME | DESCRIPTION |
---|---|
MEMORY USAGE | |
Total Memory | The total amount of dynamic memory the server is currently consuming. |
SQL Cache Memory | The total amount of dynamic memory the server is using for the dynamic SQL cache. |
Lock Memory | The total amount of dynamic memory the server is using for locks. |
Optimizer Memory | The total amount of dynamic memory the server is using for query optimization. |
Connection Memory | The total amount of dynamic memory the server is using for maintaining connections. |
Granted WorkSpace Memory | The total amount of memory granted to executing processes. This memory is used for hash, sort and create index operations. |
Memory Grants Pending | The current number of processes waiting for a workspace memory grant. |
Memory Grants Success | The current number of processes that have successfully acquired a workspace memory grant. |
BUFFER MANAGER STATISTICS | |
Buffer Hit Ratio | The percentage of pages that were found in the buffer pool without having to incur a read from disk. |
Page LookUps/Min | The number of requests to find a page in the buffer pool. |
Page Reads/Min | The number of physical database page reads issued. |
Page Writes/Min | The number of physical database page writes issued. |
Total Pages | The number of pages in the buffer pool (includes database, free, and stolen). |
Database Pages | The number of pages in the buffer pool with database content. |
Free Pages | The total number of pages on all free lists. |
Page Life Expectancy | The number of seconds a page will stay in the buffer pool without references. |
CONNECTION STATISTICS | |
Connection Time | The time taken to get connected to the MS SQL database server. |
Active Connections | The number of users connected to the system. |
Logins/Min | The total number of logins started per minute. |
Logouts/Min | The total number of logouts started per minute. |
CACHE DETAILS | |
Cache Hit Ratio | The ratio between cache hits and lookups |
Cache Used/Min | The times each type of cache object has been used |
Cache Count | The number of cache objects in the cache |
Cache Pages | The number of 8k pages used by cache objects |
LOCK DETAILS | |
Lock Requests/Min | The number of new locks and lock conversions requested from the lock manager. |
Lock Waits/Min | The total wait time for locks in the last minute. |
Lock Timeouts/Min | The number of lock requests that timed out. This includes internal requests for NOWAIT locks. |
Deadlocks/Min | The number of lock requests that resulted in a deadlock. |
Average Lock Wait Time | The average amount of wait time for each lock request that resulted in a wait. |
SQL STATISTICS | |
Batch Requests/Min | The number of SQL batch requests received by server. |
SQL Compilations/Min | The number of SQL compilations. |
SQL Recompilations/Min | The number of SQL re-compiles. |
AutoParams/Min | The number of auto-parameterization attempts. |
Failed AutoParams/Min | The number of failed auto-parameterizations. |
LATCH DETAILS | |
Latch Waits/Min | The number of latch requests that could not be granted immediately and had to wait before being granted. |
Average Latch Wait Time | The average latch wait time for latch requests that had to wait. |
TOP SLOW RUNNING QUERIES | |
Avg. Execution Time | The average time taken for complete execution of this query. |
Maximum Execution Time | The maximum elapsed time for any complete execution of this query. |
Minimum Execution Time | The minimum elapsed time for any complete execution of this query. |
No of Executions | The number of times that the query has been executed since the plan was last compiled. |
Query | The SQL query text. |
Last Execution Time | The last time at which the query started executing. |
TOP QUERIES BY MOST FREQUENTLY EXECUTED | |
Execution Count | The number of times that the query has been executed since the plan was last compiled. |
Query | The SQL query text. |
DB Name | The Database against which this query has been executed (will be empty for ad hoc and prepared batches). |
Last Execution Time | The last time at which the query started executing. |
Average Execution Time | The average time taken to execute an individual query. |
TOP QUERIES BY MOST FREQUENTLY BLOCKED | |
Average Time Blocked | The average amount of time the query was blocked. |
Total Time Blocked | The cumulative total amount of time for which the query was blocked. |
Query | The SQL query text. |
DB Name | The Database against which this query has been executed. |
Last Execution Time | The last time at which the query started executing. |
Average Execution Time | The average time taken to execute an individual query. |
ATTRIBUTE NAME | DESCRIPTION |
---|---|
CONNECTION STATISTICS | |
Active Connections | The number of currently active connections to the database. |
LOCK STATISTICS | |
Locks Held | The number of locks held by the indicated session |
Locks Wait | The number of locks waiting in the database |
BUFFER STATISTICS | |
Buffer Hits/min | The total buffer hits (i.e., block read requests avoided by finding the block already in buffer cache) per minute |
Block Reads/Min | The total disk blocks read per minute |
Cache Hit Ratio | The current ratio of buffer cache hits to total requests |
DISK USAGE DETAILS | |
Disk Usage | The size of the on-disk representation of all tables in the database in MB |
Index Scan Ratio | The current ratio of index scans to total scans(index scan+sque scan) |
TRANSACTION DETAILS | |
Total Commits | The total transactions commited. |
Total Rollbacks | The total transactions rolled back |
Commits/Min | The total transactions committed per minute |
Rollbacks/Min | The total transactions rolled back per minute |
PRIMARY DATATBASE OBJECTS STATISTICS | |
Size of the Largest Table | The size of the largest table in the database server |
Largest Table(s) | The largest table in the database server |
DATABASE DETAILS | |
Database Name | The name of the database |
DB Size | The size of the database |
LONG RUNNING QUERY DETAILS | |
Database Name | The name of the database where the Query is running for longer time. |
Username | The username of the database. |
Runtime | The amount of time the query ran. |
Query | The query that is running for longer time in the database.(more than 2 mins) |
TOP 50 TABLE ROW DETAILS | |
Tablename | The name of the table |
No.of Rows | The total no.of rows in the table |
Table size | The size of the Table |
Parameter | Description |
---|---|
Configuration Details | |
Available Processors | The number of processors available to the JVM. |
Uptime | The uptime of the Java virtual machine. |
Start Time | The start time of the Java virtual machine in milliseconds. |
Free Physical Memory | The amount of free physical memory in Megabytes. |
Total Physical Memory | Total amount of physical memory in Megabytes. |
Total Swap Space | Total amount of swap space in Megabytes. |
Free Swap Space | The amount of free swap space in Megabytes. |
Committed Virtual Memory | The amount of virtual memory that is guaranteed to be available to the running process in Megabytes. |