ManageEngine OpManager Monitoring

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 - Adding 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:

For Windows:

In Service Mode:

1. Add below entries in wrapper.conf
C:\ManageEngine\OpManager\conf\wrapper.conf

# Enable Remote JMX
wrapper.java.additional.16=-Dcom.sun.management.jmxremote 
wrapper.java.additional.17=-Dcom.sun.management.jmxremote.port=1999 
wrapper.java.additional.18=-Dcom.sun.management.jmxremote.ssl=false 
wrapper.java.additional.19=-Dcom.sun.management.jmxremote.authenticate=false

In Non-Service Mode:

Append the following parameters to JAVA_OPTS:

set JAVA_OPTS= %JAVA_OPTS%
-Dcom.sun.management.jmxremote
-Dcom.sun.management.jmxremote.port=1999
-Dcom.sun.management.jmxremote.ssl=false
-Dcom.sun.management.jmxremote.authenticate=false

For Linux:

Add the following entry in run.sh:

JAVA_OPTS="$JAVA_OPTS
-Dcom.sun.management.jmxremote
-Dcom.sun.management.jmxremote.port=1999
-Dcom.sun.management.jmxremote.authenticate=false
-Dcom.sun.management.jmxremote.ssl=false"

2. To monitor PGSQL DB, do the following changes:

  • Open postgresql.conf under <postgres home>/data
  • Check the value of the configuration parameter listen address. It should be "*". Click here for more details on configuring postgresql.conf
  • open pg_hba.conf under <postgres home>/data
  • Add a new line host all all 0.0.0.0/0 md5 to allow all the machines with proper password authentication to acces PostgreSQL database server. Click here for more details on configuring pg_hba.conf.
  • Open C:\ManageEngine\OpManager\conf\database_params.conf
  • Update the hostname/ipadress instead of localhost.

Steps to create a new monitor

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.

Use the AddMonitor API to add a ME OpManager Monitor

Syntax

http://[Host]:[Port]/AppManager/xml/AddMonitor?apikey=[APIKEY]&type=OPMMonitor&hostname=[HOST]&port=[PORT]&authEnabled=[true/false]&username=[USERNAME]&password=[PASSWORD]&displayname=[DISPLAYNAME]&JNDIPath=[JNDIPATH]&MonitorPGSQLDB=[Yes/No]&dbtype=[DBType]&DBHost=[DatabaseHost]&DBName=[DataBaseName]&DBPort=[DataBasePort]&DBUserName=[DataBaseUserName]&DBPassword=[DBPassword]&namedInstance=[IsNameInstance]&instance=[instance]&SSLEnabled=[SSLEnabled]

Request Parameter:

The parameters involved in the API request are described below. Also, refer the list of common Request Parameters.

FieldDescription
Hostname
The name or Ip address of the host where ME OPManager is running.
Port
The running port of ME OPManager.
authEnabled Specifies if authentication is enabled for ME OPManager.
username and password Credential of the user.
JNDIPath JNDIPATH for installation of OpManager
MonitorPGSQLDB Specify if you wish to monitor PGSQL Database with Yes/No. Displaying the respective tab in UI depends on this value. (Case Sensitive)
DBType The Database Type. Values can be pgsql or mssql. (Case Sensitive)
DBName, DBPort, DBUserName and DBPassword PostgresSQL database credentials.
SSLEnabled True if the SSL is enabled.

 

Sample Request

http://prod-server3:9090/AppManager/xml/AddMonitor?apikey=38cb51649cf3ac0614c3aab294a7bebd&type=OPMMonitor&hostname=172.21.151.93&port=1998&authEnabled=false&username=&password=&displayname=testOPM&JNDIPath=/jmxrmi&MonitorPGSQLDB=Yes&dbtype=pgsql&DBHost=172.21.151.93&DBPort=13306&DBName=OpManagerDB&DBUserName=postgres&namedInstance=[IsNameInstance]&instance=[instance]&SSLEnabled=false

Monitored Parameters

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:

  • 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

ParameterDescription
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 NAMEDESCRIPTION
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 NAMEDESCRIPTION
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

ParameterDescription
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.