Chat now with support
Chat with Support

Foglight for Sybase - 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

Replicated Servers Metrics

The Replicated Servers pane shows the available replicated servers. For each server, it displays the following information:

DB: The replicated server database name.
Latency (sec): The difference between the time the transaction was committed at the destination (Replicate) database, and the time at the origin (Primary Site) when the transaction was committed, in seconds.

Databases Dashboard

The Databases dashboard displays summary information about all databases that may exist in your monitored environment. This includes your SAP ASE databases along with SQL Server, Oracle, and DB2 databases.

At the top of this dashboard you see the total counts of all alarms generated by all monitored database types, including SAP ASE. The alarm counts are grouped by the severity level: Fatal, Critical, Warning, Normal, and Unknown. Use this as a starting point to quickly estimate potential bottlenecks within your infrastructure.

NOTE: The flows associated with the Discover more databases and Administer Agents buttons, appearing in the top-right are only available when you are monitoring SQL Server and Oracle databases and have Foglight for SQL Server and Foglight for Oracle installed. For more information, see the Managing Oracle Database Systems User Guide and Managing SQL Server Database Systems User Guide.

Just below the alarm counts, a collection of tiles displays a high-level overview of your environment. Each tile represents a database type (All, SQL Server, Oracle, SAP ASE, DB2) and shows how many database instances exist in your monitored environment, along with the count of objects of that type in each of the alarm states (Normal, Warning, Critical, Fatal).

Figure 40. Database Tiles

The table of database instances appearing just below the tile collection reflects the tile selection. For example, clicking the SAP ASE tile shows only the SAP ASE databases in the list.

For details about the information appearing in this list, see Viewing the list of database instances .

You can use other types of attributes to filter this list. For example, clicking a severity icon in a tile shows only the database instances of that database type that are in that alarm severity state. For more information about filtering this list, see Filtering the list of database instances .

In many cases it may be useful to create one or more groups of databases that you want to monitor. You can use database groups to further filter your selection using the Databases view appearing on the navigation panel.

Figure 42. Database Groups

For additional information about database groups, see Managing database groups .

Clicking the All tile shows a list of all monitored database instances. Clicking any value in the database list, except the Home icon in the Name column, displays a Sybase cue card at the bottom of the display area, showing additional information about the selected database instance. For details about the information appearing in this view, see Exploring the state of selected database instances .

Clicking the Home icon in the Name column links to the MDA Home Page Dashboard.

Viewing the list of database instances

The table of database instances can display all available database instances, or a filtered list. For more information about possible filters, see Filtering the list of database instances .

The alarm with the highest severity raised against the database instance.

The name of the Sybase_MDA Agent that monitors this database instance.

The type and version number of the monitored database instance.

The date and time when the database instance was last restarted.

The workload graph for the database instance.

The number of Warning, Critical, and Fatal alarms for the database instance. The alarms are displayed by their severity levels, with the aggregated number for each severity.

Clicking this column shows the Outstanding Alarms popup.

The popup shows the most recent alarms generated for the specific database instance. To view additional information about an alarm, click its entry in the Sev column. The Alarm Created dialog box appears, showing details about the selected alarm.

For complete information about alarms in Foglight, see the Foglight User Help.

The name of the computer on which the database instance is running.

The overall OS CPU usage.

The amount of memory consumed by all OS processes (including the database instance process). This includes both RAM resident memory and swapped memory.

The percentage of time the busiest device spent serving system-wide
I/O requests. This metric serves as a measure for the system I/O load.

The operational status of the monitoring agent.

When the agent instance is running, hovering over the icon in the State column displays the status message Collecting Data.

When the agent instance is running but not collecting data, hovering over the State icon displays one of the following status messages:

Indicates whether StealthCollect is installed and configured for this agent.

Filtering the list of database instances

By default, the list of database instances displays all of the currently monitored database instances. If your monitored environment includes a larger number of different database instances, it might be useful to filter this list and focus on individual groups of database instances that share some common attributes.

To list only the database instances that belong to a specific database group, on the navigation panel, in the Databases view, expand the Database Groups node and select a group. For more information about database groups, see Managing database groups .
Related Documents