Follow Us:

Database Monitoring

MYSQL Monitoring for Linux Environment

MySQL database is a widely used database in the open source community. AppDiagnos MySQL collects the performance counters through an agent. The MySQL monitor provides insights under different heads like queries, threads, Innodb along with key summary findings like bytes sent, bytes received, key reads and key writes to name a few.
The MySQL monitor works by gathering information from the status variables. The monitor requires installation of MySQL 5.0 or above, with proper connection string, user name and password. The monitor requires JRE 1.7 or above in addition to MySQL.

MySQL monitor Pre-Requisites:

JDK 1.6+
MySQL 5.0+
Java Class Path is set.

 

To set the java class path:

Open bash profile using vi ~/.bash_profile command.

Set JAVA_HOME as follows

export JAVA_HOME=.
E.x. If your path is set to /usr/java/jdk1.5.0_07/bin/java,
Set it as follows: export JAVA_HOME=/usr/java/jdk1.5.0_07/bin/java
Set PATH as follows: export PATH=$PATH:/usr/java/jdk1.5.0_07/bin
Replace /usr/java/jdk1.5.0_07 as per your location of java folder
Save and close the file.

Steps to add MySQL Monitoring Agent in Linux Environment:

Open AppDiagnos APM Portal URL in a browser.
Start Up with valid credentials.
Click on OPS View tab.

Database Monitoring Document

Click on Database.

Click on the ( + ) Add button

Create Application Monitor

In Add Window, Click on Database button.

Choose Module

In Add Database Window ,Enter Database Name, Description, Select Database Type and Version.

Click on SAVE button.

Download Database Document

The Monitor Download Window will appear.

Mysql Document

Click on the Monitor button to Download the Database Monitor Agent.

Go to linux terminal, where you want to install the agent. Untar the downloaded setup to a location. tar -xzmvf appdiagnos_mysql_agent_2.0.42.tar.gz

Open MYSQL.properties file, and enter the relevant password if needed.

Open terminal window.

Enter the following commands and hit enter.

cp $JAVA_HOME/jre/lib/security/cacerts cacerts_appdiagnos_agent

keytool -import -alias apm.appdiagnos.com -keystore cacerts_appdiagnos_agent   -storepass changeit -file apm.appdiagnos.com.crt –noprompt

java-Djavax.net.ssl.trustStore=cacerts_appdiagnos_agent-Djavax.net.ssl.trustStorePassword=changeit-jarappdiagnos_mysql_agent_2.0.42.jar>logs/appdiagnos_mysql_agent_2.0.42_$(date +%Y-%m-%d_%H%M).log &

Mysql OPS view

NOTE:- Ensure on successful Installation of MYSQL Agent , The Monitor Icon appears in green color in the APM portal.

Configure Metrics – MYSQL Monitor Agent

Locate the card that has the database name you want to configure, click  the  settings icon (configure metrics)  on the left hand side.

In the Configure Metrics page, Select the Category.

Configure Metrics

Upon Category selection, Select/Edit the required Metrics to monitor as per need.

Configure Metrics-2

Click SAVE button.

On the respective Database Monitor Graph Page, the newly added metrics graph will appear.

Database Mysql Monitor

By clicking Slow Query Radio Button, Slow query information will appear.

Database Mysql SlowQuery

MYSQL Monitoring for Windows Environment

MySQL database is a widely used database in the open source community. AppDiagnos MySQL collects the performance counters through an agent. The MySQL monitor provides insights under different heads like queries, threads, Innodb along with key summary findings like bytes sent, bytes received, key reads and key writes to name a few.
The MySQL monitor works by gathering information from the status variables. The monitor requires installation of MySQL 5.0 or above, with proper connection string, user name and password. The monitor requires JRE 1.7 or above in addition to MySQL.

MySQL monitor Pre-Requisites:

JDK 1.6+
MySQL 5.0+
Java Class Path is set.

 

To set the java class path:

Open bash profile using vi ~/.bash_profile command.

Set JAVA_HOME as follows

export JAVA_HOME=.
E.x. If your path is set to /usr/java/jdk1.5.0_07/bin/java,
Set it as follows: export JAVA_HOME=/usr/java/jdk1.5.0_07/bin/java
Set PATH as follows: export PATH=$PATH:/usr/java/jdk1.5.0_07/bin
Replace /usr/java/jdk1.5.0_07 as per your location of java folder
Save and close the file.

Steps to add MySQL Monitoring Agent in Windows Environment:

Open AppDiagnos APM Portal URL in a browser.
Start Up with valid credentials.
Click on OPS View tab.

OPS View

Click on Database.

Click on the ( + ) Add button

Create Database Monitor

In Add Window, Click on Database button.

Choose Module - ASD

In Add Database Window ,Enter Database Name, Description, Select Database Type and Version.

Click on SAVE button.

Database Signup Form

The Monitor Download Window will appear.

Download Database Document

Click on the Monitor button to Download the Database Monitor Agent.

Go to linux terminal, where you want to install the agent. Untar the downloaded setup to a location. tar -xzmvf appdiagnos_mysql_agent_2.0.42.tar.gz

Open MYSQL.properties file, and enter the relevant password if needed.

Open terminal window.

Enter the following commands and hit enter.

cp $JAVA_HOME/jre/lib/security/cacerts cacerts_appdiagnos_agent

keytool -import -alias apm.appdiagnos.com -keystore cacerts_appdiagnos_agent   -storepass changeit -file apm.appdiagnos.com.crt –noprompt

java-Djavax.net.ssl.trustStore=cacerts_appdiagnos_agent-Djavax.net.ssl.trustStorePassword=changeit-jarappdiagnos_mysql_agent_2.0.42.jar>logs/appdiagnos_mysql_agent_2.0.42_$(date +%Y-%m-%d_%H%M).log &

Mysql Database

NOTE:- Ensure on successful Installation of MYSQL Agent , The Monitor Icon appears in green color in the APM portal.

Configure Metrics – MYSQL Monitor Agent

Locate the card that has the database name you want to configure, click  the  settings icon (configure metrics)  on the left hand side.

In the Configure Metrics page, Select the Category.

Configure Metrics

Upon Category selection, Select/Edit the required Metrics to monitor as per need.

Configure Metrics

Click SAVE button.

On the respective Database Monitor Graph Page, the newly added metrics graph will appear.

Database Mysql Monitor View

By clicking Slow Query Radio Button, Slow query information will appear.

Database Mysql slowquery

MSSQL Monitoring

AppDiagnos assists the database administrators to continuously monitor MSSQL database. AppDiagnos MSSQL monitor provides insights of various performance counters like connections, buffer lazy writes, buffer page reads, buffer page writes, buffer page expectancy, buffer checkpoint pages etc. SQL Server Monitors allow monitoring all versions of Microsoft SQL Server. The monitor requires dot net framework 4.0 or above for proper functioning.

Steps for MS-SQL monitor Setup:

Open AppDiagnos APM Portal URL in a browser.
Login with valid credentials.
Click on OPS View tab.
Click Database.

To set the java class path:

Open bash profile using vi ~/.bash_profile command.

Set JAVA_HOME as follows

export JAVA_HOME=.
E.x. If your path is set to /usr/java/jdk1.5.0_07/bin/java,
Set it as follows: export JAVA_HOME=/usr/java/jdk1.5.0_07/bin/java
Set PATH as follows: export PATH=$PATH:/usr/java/jdk1.5.0_07/bin
Replace /usr/java/jdk1.5.0_07 as per your location of java folder
Save and close the file.

Steps to add MySQL Monitoring Agent in Windows Environment:

Open AppDiagnos APM Portal URL in a browser.
Start Up with valid credentials.
Click on OPS View tab.

MSSQL Monitoring Document

Click on Database.

Click on the ( + ) Add button

Create Database monitor

In Add Window, Click on Database button.

Choose Module

In Add Database Window ,Enter Database Name, Description, Select Database Type and Version.

Click on SAVE button.

Database signup form

The Monitor Download Window will appear.

Download Document

Click on the Monitor button to Download the Database Monitor Agent.

Go to linux terminal, where you want to install the agent. Untar the downloaded setup to a location. tar -xzmvf appdiagnos_mysql_agent_2.0.42.tar.gz

Open MYSQL.properties file, and enter the relevant password if needed.

Open terminal window.

Enter the following commands and hit enter.

cp $JAVA_HOME/jre/lib/security/cacerts cacerts_appdiagnos_agent

keytool -import -alias apm.appdiagnos.com -keystore cacerts_appdiagnos_agent   -storepass changeit -file apm.appdiagnos.com.crt –noprompt

java-Djavax.net.ssl.trustStore=cacerts_appdiagnos_agent-Djavax.net.ssl.trustStorePassword=changeit-jarappdiagnos_mysql_agent_2.0.42.jar>logs/appdiagnos_mysql_agent_2.0.42_$(date +%Y-%m-%d_%H%M).log &

Database MSSQL

NOTE:- Ensure on successful Installation of MYSQL Agent , The Monitor Icon appears in green color in the APM portal.

Configure Metrics – MYSQL Monitor Agent

Locate the card that has the database name you want to configure, click  the  settings icon (configure metrics)  on the left hand side.

In the Configure Metrics page, Select the Category.

Configure Metrics

Upon Category selection, Select/Edit the required Metrics to monitor as per need.

Configure Metrics

Click SAVE button.

On the respective Database Monitor Graph Page, the newly added metrics graph will appear.

Database MSSQL monitor

By clicking Slow Query Radio Button, Slow query information will appear.

Database MSSQL slowquery

Oracle Monitoring for Windows

Oracle Monitoring for Windows

Oracle is an open source relational database management system ( DBMS ) developed by a worldwide team of volunteers. Oracle is not controlled by any corporation or other private entity and the source code is available free of charge.
Oracle supports transaction s, sub-selects, triggers, views, foreign key referential integrity, and sophisticated locking. It runs on numerous platforms including Linux , most flavors of UNIX, Mac OS X , Solaris , Tru64, and Windows . It supports text, images, sounds, and video, and includes programming interfaces for C / C++ , Java , Perl , Python , Ruby, Tcland Open Database Connectivity ( ODBC ).
Oracle monitor Pre-Requisites:

  • JDK 1.6+
  • Oracle 11g
  • Java Class Path is set.

To set the java class path:

  • From the desktop, right click the Computer icon.
  • Choose Properties from the context menu.
  • Click the Advanced system settings link.
  • Click Environment Variables.
  • In the section System Variables, find the PATH environment variable and select it.
  • Click Edit.
  • If the PATH environment variable does not exist, click New.
  • In the Edit System Variable (or New System Variable) window, specify the value of the PATH environment variable.
  • Click OK.
  • Close all remaining windows by clicking OK.

Steps to add OracleDB Monitoring Agent in Windows Environment:

  • Open AppDiagnos APM Portal URL in a browser.
  • Start Up with valid credentials.
  • Click on OPS View tab >> Databases Section.
  • Click on the ( + ) Add button.

Oracle DB Monitoring Doc

  • In Add window, Click on Database Section.

Oracle DB choose Module

  • In Add Database Window ,Enter Database Name and Description.
  • Select Database Type and Version.
  • Click on SAVE button.

Oracle DB signup form

  • The Monitor Download Window will appear.

Oracle DB download document

Add Oracle Configurations:

  • open oracle_config.properties then specify the
  • LOCAL_LISTERN_PORT,USER_NAME and USER_PASSWORD as per monitor machine
  • Example: LOCAL_LISTERN_PORT=1251
  • DB_HOST=localhost
  • USER_NAME=SYS as sysdba
  • USER_PASSWORD=welcome

NOTE:- Ensure on successful Installation of Oracle Agent , The Monitor Icon appears green.
Configure Metrics – Oracle Monitor Agent

  • Go to the OPS View >> Database menu. A list of databases will appear. Select the card on which the desired database name appears, click the settings icon (configure metrics) on the left hand side.
  • Click on the “Configure Metrics” Option.

Oracle Configure Metrics

  • In the Configure Metrics page, Select the Category.
  • Upon Category selection, a set of default metrics will appear. Select the required metrics to monitor as per need.
  • Click SAVE button.

Oracle DB configure Metrics

  • On the respective Database Monitor Graph Page, the newly added metrics graph will appear.

oracle DB monitoring graph

oracle DB monitor slowquery

PostgreSQL Monitoring for Linux

Postgres SQL is an open source relational database management system ( DBMS ) developed by a worldwide team of volunteers. PostgreSQL is not controlled by any corporation or other private entity and the source code is available free of charge.
Postgres SQL supports transaction s, sub-selects, triggers, views, foreign key referential integrity, and sophisticated locking. It runs on numerous platforms including Linux , most flavors of UNIX, Mac OS X , Solaris , Tru64, and Windows . It supports text, images, sounds, and video, and includes programming interfaces for C / C++ , Java , Perl , Python , Ruby, Tcland Open Database Connectivity ( ODBC ).
Oracle monitor Pre-Requisites:

  • JDK 1.6+
  • Oracle 11g
  • Java Class Path is set.

To set the java class path:

  • From the desktop, right click the Computer icon.
  • Choose Properties from the context menu.
  • Click the Advanced system settings link.
  • Click Environment Variables.
  • In the section System Variables, find the PATH environment variable and select it.
  • Click Edit.
  • If the PATH environment variable does not exist, click New.
  • In the Edit System Variable (or New System Variable) window, specify the value of the PATH environment variable.
  • Click OK.
  • Close all remaining windows by clicking OK.

Steps to add OracleDB MonitoringAgent in Linux Environment:

  • Open AppDiagnos APM Portal URL in a browser.
  • Start Up with valid credentials.
  • Click on OPS View tab >> Databases Section.

Linux PostgreSQL monitoring doc

  • Click on the ( + ) Add button.

Create Linux DB monitor

  • In Add window, Click on Database Section.

Linux DB choose module

  • In Add Database Window ,Enter Database Name and Description.
  • Select Database Type and Version.
  • Click on SAVE button.

Linux DB download document

  • The Monitor Download Window will appear.

Linux SQL DB download

Add Oracle Configurations:

  • open oracle_config.properties then specify the
  • LOCAL_LISTERN_PORT,USER_NAME and USER_PASSWORD as per monitor machine
  • Example: LOCAL_LISTERN_PORT=1251
  • DB_HOST=localhost
  • USER_NAME=SYS as sysdba
  • USER_PASSWORD=welcome

NOTE:- Ensure on successful Installation of Oracle Agent , The Monitor Icon appears green.
Configure Metrics – Oracle Monitor Agent

  • Go to the OPS View >> Database menu. A list of databases will appear. Select the card on which the desired database name appears, click the settings icon (configure metrics) on the left hand side.
  • Click on the “Configure Metrics” Option.

Linux Db configure metrics

  • In the Configure Metrics page, Select the Category.
  • Upon Category selection, a set of default metrics will appear. Select the required metrics to monitor as per need.
  • Click SAVE button.

Linux DB configure metrics

  • On the respective Database Monitor Graph Page, the newly added metrics graph will appear.

Linux DB monitor View

linux DB slowquery

PostgreSQL Monitoring for Windows

Postgres SQL is an open source relational database management system ( DBMS ) developed by a worldwide team of volunteers. PostgreSQL is not controlled by any corporation or other private entity and the source code is available free of charge.
Postgres SQL supports transaction s, sub-selects, triggers, views, foreign key referential integrity, and sophisticated locking. It runs on numerous platforms including Linux , most flavors of UNIX, Mac OS X , Solaris , Tru64, and Windows . It supports text, images, sounds, and video, and includes programming interfaces for C / C++ , Java , Perl , Python , Ruby, Tcland Open Database Connectivity ( ODBC ).
Oracle monitor Pre-Requisites:

  • JDK 1.6+
  • Oracle 11g
  • Java Class Path is set.

To set the java class path:

  • From the desktop, right click the Computer icon.
  • Choose Properties from the context menu.
  • Click the Advanced system settings link.
  • Click Environment Variables.
  • In the section System Variables, find the PATH environment variable and select it.
  • Click Edit.
  • If the PATH environment variable does not exist, click New.
  • In the Edit System Variable (or New System Variable) window, specify the value of the PATH environment variable.
  • Click OK.
  • Close all remaining windows by clicking OK.

Steps to add OracleDB MonitoringAgent in Linux Environment:

  • Open AppDiagnos APM Portal URL in a browser.
  • Start Up with valid credentials.
  • Click on OPS View tab >> Databases Section.
  • Click on the ( + ) Add button.

Create Windows DB monitor

  • In Add window, Click on Database Section.

Windows DB choose Module

  • In Add Database Window ,Enter Database Name and Description.
  • Select Database Type and Version.
  • Click on SAVE button.

Windows DB monitor signup form

  • The Monitor Download Window will appear.

Windows DB download document

Add Oracle Configurations:

  • open oracle_config.properties then specify the
  • LOCAL_LISTERN_PORT,USER_NAME and USER_PASSWORD as per monitor machine
  • Example: LOCAL_LISTERN_PORT=1251
  • DB_HOST=localhost
  • USER_NAME=SYS as sysdba
  • USER_PASSWORD=welcome

NOTE:- Ensure on successful Installation of Oracle Agent , The Monitor Icon appears green.
Configure Metrics – Oracle Monitor Agent

  • Go to the OPS View >> Database menu. A list of databases will appear. Select the card on which the desired database name appears, click the settings icon (configure metrics) on the left hand side.
  • Click on the “Configure Metrics” Option.

Windows DB configure metrics

  • In the Configure Metrics page, Select the Category.
  • Upon Category selection, a set of default metrics will appear. Select the required metrics to monitor as per need.
  • Click SAVE button.

Windows DB Mysql configure metrics

  • On the respective Database Monitor Graph Page, the newly added metrics graph will appear.

Windows DB monitor View

Windows DB slowquery View