Chat now with support
Chat with Support

Foglight for Sybase 7.1.0 - User and Reference Guide

Using Foglight for SAP ASE
Exploring the SAP ASE Dashboards About the Sybase_MDA Agent About the Sybase_RS Agent Generating SybaseMDA Reports
Reference

MDA Instance Metrics

MDA Instance Metrics
 
Table 3. MDA Instance Metrics
Name
Description

DB Type

Type of database.

Version

The Sybase version being monitored.

You can expand the version detail by clicking on or hovering on any version number.

Up Since

The date and time that the Sybase agent was last restarted.

Eng. Summary

Last Sample Time

The last date (month/day/year) and time (hour:minute, AM/PM) that data was sampled.

Sample Period

The frequency (in seconds) of data sampling.

Sybase Error Log

The number of Sybase errors.

This field displays color-coded real-time behavior for severity.

You can drill down by clicking on the device symbol. A popup appears showing a detailed list of the errors.

MDA Alarms

MDA Alarms
 
Table 4. MDA Alarms
Name
Description

Agent Status

When the agent instance is running, the following status message appears:

•
Collecting Data

When the agent instance is running but not collecting data, one of the following status messages appear:

•
Starting
•
Stopped
•
Stopping
•
Running but not collecting data (initiated by clicking
•
Unknown

Host

The number of fatal, critical, and warning alarms for this host.

You can drill down to the detailed alarm list.

Agent

The number of fatal, critical, and warning alarms for this database agent.

You can drill down to the detailed alarm list.

MDA Processes Metrics

MDA Processes Metrics
 
Table 5. MDA Processes Metrics
Name
Description

Connections in Use

The number of client application connections currently in use.

You can drill down by clicking on the device symbol. A popup appears showing the number of current connections in use plotted over time. It provides further drill downs to:

•
Top Activity Drilldown—a Top Activity Dashboard appears.
•
Edit Threshold—a Manage Thresholds Dashboard appears.

Connection Usage

The percentage of total available connections currently in use.

You can drill down by clicking on the number. A popup appears showing the percentage of connections that are available, plotted over time. It provides further drill downs to:

•
Top Activity Drilldown—a Top Activity Dashboard appears.
•
Edit Threshold—a Manage Thresholds Dashboard appears.

Active Processes

The number of active client application connections.

You can drill down by clicking on the device symbol. A popup appears showing the active connections plotted over time. It provides further drill downs to:

•
Top Activity Drilldown—a Top Activity Dashboard appears.
•
Edit Threshold—a Manage Thresholds Dashboard appears.

Active Processes Percent

The percentage of total available processes currently in use.

This field displays color-coded real-time behavior for severity.

You can drill down by clicking on the number. A popup appears showing the percentage of processes that are active, plotted over time. It provides further drill downs to:

•
Top Activity Drilldown—a Top Activity Dashboard appears.
•
Edit Threshold—a Manage Thresholds Dashboard appears.

Locks

Last Probe Requested

The number of the last probe requested.

This field displays color-coded real-time behavior for severity.

Average Locks Wait (sec)

The average amount of time spent waiting for a lock to release.

This field displays color-coded real-time behavior for severity.

Blocked

The number of blocked processes detected.

This field displays color-coded real-time behavior for severity.

Deadlocks

The number of deadlocks detected.

This field displays color-coded real-time behavior for severity.

MDA Engines Metrics

MDA Engines Metrics
 
Table 6. MDA Engines Metrics
Name
Description

Online

The number of database engines currently online.

This field displays color-coded real-time behavior for severity.

Configured

The number of database engines currently configured.

This field displays color-coded real-time behavior for severity.

Avg. Engines Busy

The average number of database engines that are busy.

This field displays color-coded real-time behavior for severity.

You can drill down by clicking on the icon. A popup appears showing the percentage of engine total busy and engine I/O busy, plotted over time. It provides further drill downs to:

•
Engines Drilldown—a Engines Dashboard appears.
•
Edit Threshold—a Manage Thresholds Dashboard appears.

CPU

The percentage of CPU time all engines spent not idle.

This field displays color-coded real-time behavior for severity.

You can drill down by clicking on the number. A popup appears showing the percentage of engine total busy and engine I/O busy, plotted over time. It provides further drill downs to:

•
Engines Drilldown—a Engines Dashboard appears.
•
Edit Threshold—a Manage Thresholds Dashboard appears.

I/O

The percentage of input/output resources currently being used by the database engines.

This field displays color-coded real-time behavior for severity.

You can drill down by clicking on the number. A popup appears showing the percentage of engine total busy and engine I/O busy, plotted over time. It provides further drill downs to:

•
Engines Drilldown—a Engines Dashboard appears.
•
Edit Threshold—a Manage Thresholds Dashboard appears.

Context Switches /s

The number of context switches for the engines in this database, per second.

This field displays color-coded real-time behavior for severity.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating