ManageEngine OpManager Monitoring

Overview

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.

ManageEngine OpManager - Creating a new monitor

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:

Specify the Display Name of the ManageEngine OpManager monitor.
Enter the HostName or IP Address of the host where OpManager is running.
Enter the JMX Port where OpManager is running. By default, it will be 8080.
Enter the credential details like user name, password and JNDIPath or select credentials from a Credential Manager list.
Click Monitor PGSQL Database for PGSQL stats. (Enter DataBase Name, DataBasePort, UserName and Password).
Enter the polling interval time in minutes.
Choose the Monitor Group from the combo box with which you want to associate ME OpManager Monitor (optional). You can choose multiple groups to associate your monitor.
Click Add Monitor(s). This discovers OpManager from the network and starts monitoring.

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]

Monitored Parameters

Go to the Monitors Category View by clicking the Monitors tab. Click on ME OpManagerunder the Web Server/ ServicesTable. Displayed is the OpManager bulk configuration view distributed into three tabs:

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.

List of metrics captured during data collection:

Performance Overview

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.

MSSQL DataBase Statistics

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.

PGSQL STATISTICS

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

Configuration

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.

ManageEngine OpManager Monitoring

Overview

ManageEngine OpManager - Creating a new monitor

Monitored Parameters

List of metrics captured during data collection:

Performance Overview

MSSQL DataBase Statistics

PGSQL STATISTICS

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