Server monitoring

Apache

User Rating: / 3  |  Rate this article: PoorBest 

{ArticleIndex}

Set Up Apache Monitoring

To monitor Apache using LoadUI mod_status module must be enabled. This module is available as part of a standard installation of either the Apache 1.x or Apache 2.x packages and configuration is very straightforward.

To enable status reports only for somedomain.com domain, the following code must be added to the configuration file httpd.conf:

apacheConf

To enable extended counters, the following line must be added to httpd.conf:

ExtendedStatus On

Extended status is available from Apache 1.3.2 and higher.

LoadUI setup

When defining new Apache monitor in LoadUI, user must specify server host (in server definition screen), port (80 is default) and optionally check ‘Use https?’ if server stats are accessed over HTTPS. User must click Test connection to verify connection and retrieve the list of all available counters. Make sure that no firewall is blocking the port used in between the server and LoadUI.

Available statistics

Once connected to Apache server, following counters are available:

1. Basic.

  • % Busy Workers - Percentage of worker serving requests relative to total number of workers (Busy + Idle)
  • Busy Workers - Worker serving requests counter.
  • Idle Workers - Idle worker counter.

2. Extended. (Available only when extended status is enabled)

  • Bytes Per Req - Average number of bytes per request.
  • Bytes Per Seq- Average number of bytes per second.
  • CPU Load - The current percentage CPU used in total by Apache.
  • Req Per Seq - Average number of requests per second.
  • Total Accesses - A total number of accesses served.
  • Total Kbytes - A total number of byte count served.
  • Uptime - The time the server has been running for.

 

Oracle Database

User Rating: / 3  |  Rate this article: PoorBest 

{ArticleIndex}

Set Up Oracle Monitoring

Create a user account in Oracle (or use an existing one) that LoadUI can use to connect. The user need to have read access to the tables V$LATCH, V$LIBRARYCACHE, V$SYSSTAT, V$SESSION, V$SESSTAT, V$SGASTAT, V$STATNAME, V$SYSTEM_EVENT and V$WAITSTAT.

LoadUI Setup

You need to have an Oracle JDBC Driver in your [LoadUI installation directory]/ext directory. The file is called ojdbc6.jar and can be downloaded for free here.

Oracle RAC

In LoadUI 2.5.5 we are adding support for RAC. If you are going to use counters that are used globally for your RAC cluster you need to give the user access to the global view, and check the RAC checkbox when creating the Monitor in LoadUI. You need to give the user access to the following tables instead of the regular view: GV$LATCH, GV$LIBRARYCACHE, GV$SYSSTAT, GV$SESSION, GV$SESSTAT, GV$SGASTAT, GV$STATNAME, GV$SYSTEM_EVENT and GV$WAITSTAT.

Troubleshooting

Make sure that no firewall is blocking the port used in between the server and LoadUI.

Available Statistics

  • Call rates (per sec)
    • Execute Count
    • Parse Count (hard)
    • Parse Count (total)
    • User Commits
    • User Rollbacks
  • Event Waits (per sec)
    • Buffer Busy Waits
    • Control File IO
    • Db File IO
    • Direct Path Read
    • Log File Write
    • SQL*net
  • Logical IO (per sec)
    • Consitent Gets
    • DB Block Changes
    • DB Block Gets
    • User Rollbacks
  • Misc.
    • Chained Fetch Ratio (%)
    • CPU Parse Overhead (%)
    • Cursor Authentications
    • Free List Contention (%)
    • Libcache, Get Hit Rate (%)
    • Libcache, Pin Hit Rate (%)
    • Open cursors
    • Recursive Calls Rate (%)
  • Miss rates
    • Buffer Cache
    • Latch - Immediate
    • Latch - Willing To Wait
    • SQL Area (shared pool reloads)
  • Physical IO (per sec)
    • Physical Reads
    • Physical Writes
    • Redo Writes
  • SGA Memory
    • Fixed SGA
    • Java Pool
    • Large Pool
    • Log Buffer
    • Shared Pool
  • Sessions
    • Active
    • Active (%)
    • Inactive
    • System

You can also extend this monitor to include any counters that you can get using a SQL query.

 

UNIX / Linux / OS X

User Rating: / 4  |  Rate this article: PoorBest 

{ArticleIndex}

What is UN*X?

UN*X is a generic term, meaning Unix-like Operating Systems. This includes Linux, OS X, FreeBSD, OpenBSD and OpenSolaris.

Server setup

Installing Net-SNMP

You need to have Net-SNMP installed on your system. To know if you have Net-SNMP installed, type snmpd --version in a terminal. If you have Net-SNMP installed, you should see a text similar to this:

NET-SNMP version:  5.4.2.1
Web: http://www.net-snmp.org/
Email: 
  This e-mail address is being protected from spambots. You need JavaScript enabled to view it
 

Net-SNMP is installed like this in Ubuntu and Debian:

sudo apt-get install snmpd
or
sudo apt-get install snmp

This depends on the age of your distribution.

Configuring Net-SNMP

Setting the community string

Edit the file /etc/snmp/snmpd.conf (this requires sudo privileges). You should uncomment line under agent behaviour that says.

agentAdress udp:161,udp6:[::1]:161 

in order to listen for connections on all interfaces available. you should also make sure that you give access to basic system information

rocommunity public

If you are not sure how to configure Net-SNMP to suit your needs, you can just replace the whole file content with the above line.

Enable access to all hosts

Now edit the file /etc/default/snmpd, making sure that the row that begins with SNMPDOPTS does not contain any trailing addresses. For example, if the row in question is:

SNMPDOPTS='-Lsd -Lf /dev/null -u snmp -I -smux -p /var/run/snmpd.pid 127.0.0.1'

It becomes:

SNMPDOPTS='-Lsd -Lf /dev/null -u snmp -I -smux -p /var/run/snmpd.pid'

Now that you have changed the configuration of snmpd, you need to restart it. Do that by typing the following:

/etc/init.d/snmpd restart

LoadUI Setup

In LoadUI, it is pretty straight-foward to setup the monitor. Just open the Monitors tab in the bottom pane of your project view, select UN*X in the toolbar operating systems category, and you should see the Monitor Wizard (both pages shown below).

UnixMonitor

Option Description
1_snag_evi The name you want to use to describe the Unix/Linux machine
2_snag_evi The hostname or IP address of the machine
3_snag_evi The port used to communicate with the machine. This is usually 161, but it may be specified in the SNMP config file (in the remote machine)
4_snag_evi The SNMP version to use
5_snag_evi SNMP Community String. It must match the one specified in the SNMP config file (in the remote machine)

Troubleshooting

Make sure that no firewall is blocking the port used in between the server and loadUI.

Available statistics

The available statistics is a subset of the SNMP MIB’s called ucdavis (including the diskio module) and mib-2. Exactly which statistics that are available may differ depending on your server configuration, but the following list is what you get on a standard Ubuntu server:

  • CPU
    • Usage (%)
  • Disk (one set of statistics per device)
    • Total Size
    • Used
  • Misc
    • Number Of Processes
  • RAM
    • Total Size
    • Used
  • Swap
    • Total Size
      • Swap space
      • Virtual memory
    • Used
      • Swap space
      • Virtual memory

Disk I/O

If you compile Net-SNMP yourself, you need explicitly include the diskio module for it to be available. This is done like this:

./configure –with-mib-modules=ucd-snmp/diskio

 

MSSQL

User Rating: / 2  |  Rate this article: PoorBest 

{ArticleIndex}

Set Up MSSQL Monitoring

The setup for the Microsoft SQL Server Monitor is the same as for setting up the Windows Monitor. Please see the Monitoring Windows document for instructions on enabling the Remote Registry Service and setting up the user account.

Troubleshooting

Make sure that no firewall is blocking the port used in between the server and LoadUI.

Available statistics

The available statistics are a selection the SQLServer… objects, with their respective counters.

 

IIS

User Rating: / 2  |  Rate this article: PoorBest 

{ArticleIndex}

Server setup

The setup for the IIS Monitor is the same as for setting up the Windows Monitor. Please see Windows - Server Setup for instructions on enabling the Remote Registry Service and setting up the user account.

Troubleshooting

Make sure that no firewall is blocking the port used in between the server and loadUI.

Available statistics

The available statistics are the Web Service and Web Service Cache PerfMon objects, with their respective counters. This is the Statistics that are typically available:

  • Web Service (one set of statistics per service, as well as a total)
    • Anonymous Users/sec
    • Bytes Received/sec
    • Bytes Sent/sec
    • Bytes Total/sec
    • CGI Requests/sec
    • Connection Attempts/sec
    • Copy Requests/sec
    • Current Anonymous Users
    • Current Blocked Asyn I/O Requests
    • Current Blocked Bandwidth Bytes
    • Current CAL Count for Authenticated Users
    • Current CAL Count for SSL Connections
    • Current CGI Requests
    • Current Connections
    • Current ISAPI Extension Requests
    • Current Non-anonymous Users
    • Delete Requests/sec
    • Files Received/sec
    • Files Sent/sec
    • Files/sec
    • Get Requests/sec
    • Head Requests/sec
    • ISAPI Extension Requests/sec
    • Lock Requests/sec
    • Locked Errors/sec
    • Logon Attempts/sec
    • Maximum Anonymous Users
    • Maximum CAL Count for Authenticated Users
    • Maximum CAL Count for SSL Connections
    • Maximum CGI Requests
    • Maximum Connections
    • Maximum ISAPI Extension Requests
    • Maximum Non-anonymous Users
    • Measured Async I/O Bandwidth Usage
    • Mkcol Requests/sec
    • Move Requests/sec
    • Non-anonymous Users/sec
    • Not Found Errors/sec
    • Options Requests/sec
    • Other Request Methods/sec
    • POST Requests/sec
    • Propfind Requests/sec
    • Proppatch Requests/sec
    • PUT Requests/sec
    • Search Requests/sec
    • Service Uptime
    • Total Allowed Async I/O Requests
    • Total Anonymous Users
    • Total Blocked Async I/O Requests
    • Total Blocked Bandwidth Bytes
    • Total Bytes Received/sec
    • Total Bytes Sent/sec
    • Total Bytes Total/sec
    • Total CGI Requests/sec
    • Total Connection Attempts/sec
    • Total Copy Requests/sec
    • Total Count of Failed CAL Requests For Authenticated Users
    • Total Count of Failed CAL Requests For SSL Connections
    • Total Delete Requests
    • Total Files Received
    • Total Files Sent
    • Total Files Transferred
    • Total GET Requests
    • Total Head Requests
    • Total ISAPI Extension Requests
    • Total Lock Requests
    • Total Locked Errors/sec
    • Total Logon Attempts/sec
    • Total Method Requests
    • Total Method Requests/sec
    • Total Mkcol Requests/sec
    • Total Move Requests
    • Total Nonanonymous users
    • Total Not Found Errors/sec
    • Total Options Requests/sec
    • Total Other Request Methods/sec
    • Total POST Requests/sec
    • Total Propfind Requests/sec
    • Total Proppatch Requests/sec
    • Total PUT Requests/sec
    • Total Seach Requests/sec
    • Total Trace Requests
    • Total Unlock Requests
    • Trace Requests/sec
    • Unlock Requests/sec
  • Web Service Cache
    • Active Flushed Entries
    • Current File Cache Memory Usage
    • Current Files Cached
    • Current Metadata Cached
    • Current URIs Cached
    • File Cache Flushes
    • File Cache Hits
    • File Cache Hits %
    • File Cache Misses
    • Kernel
      • Current URIs Cached
      • Total Flushed URIs
      • Total URIs Cached
      • Total URI Cache Flushes
      • URI Cache Hits
      • URI Cache Hits %
      • URI Cache Hits/sec
      • URI Cache Misses
    • Maximum File Cache Memory Usage
    • Metadata Cache Flushes
    • Metadata Cache Hits
    • Metadata Cache Hits %
    • Metadata Cache Misses
    • OutputCache
      • Current Flushed Items
      • Current Hits %
      • Current Items
      • Current Memory Usage
      • Total Flushed Items
      • Total Flushes
      • Total Hits
      • Total Misses
    • Total Files Cached
    • Total Flushed Files
    • Total Flushed Metadata
    • Total Flushed URIs
    • Total Metadata Cached
    • Total URIs Cached
    • URI Cache Flushes
    • URI Cache Hits
    • URI Cache Hits %
    • URI Cache Misses