Foglight for Sybase 5.7.5.40 - User and Reference Guide

Replicated Servers Metrics

Replicated Servers Metrics

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

•	The replicated server name

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

•	Agent status: Shows the database name and the status of the Sybase_MDA Agent. The status of the Sybase_MDA agent:

▪	Available—the Sybase_MDA Agent and the Replication Server are running on the same Foglight Management Server. This also indicates that the Sybase_MDA Agent is in the Collecting Data state.

▪	No Agent—no Sybase_MDA Agent is running.

You can drill down by clicking on this status field. The MDA Home Page Dashboard appears for the appropriate server.

Databases Dashboard

Databases Dashboard

The Databases dashboard displays summary information about all databases that may exist in your monitored environment. This includes your Sybase 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 Sybase. 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.

Figure 39. Database Dashboard

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, Sybase, 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 Sybase tile shows only the Sybase databases in the list.

Figure 41. Database Instances

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 Databases tile or Clear filters in the table heading 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.

Figure 43. Additional Database Instance Information

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

Viewing the list of database instances

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.

 

Table 67. Database Instance Description

Name	Description
Database
Sev	The alarm with the highest severity raised against the database instance.
Name	The name of the Sybase_MDA Agent that monitors this database instance.
Version	The type and version number of the monitored database instance.
Up Since	The date and time when the database instance was last restarted.
Workload	The workload graph for the database instance.
Alarms	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.
System Utilization
Host	The name of the computer on which the database instance is running.
CPU (%)	The overall OS CPU usage.
Memory (%)	The amount of memory consumed by all OS processes (including the database instance process). This includes both RAM resident memory and swapped memory.
Disk (% Busy)	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.
Agent
State	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: • Starting • Stopped • Stopping • Unknown
SC	Indicates whether StealthCollect is installed and configured for this agent. NOTE: StealthCollect connection is available only when you are monitoring SQL Server and Oracle databases, and have Foglight for SQL Server and Foglight for Oracle installed and running.

Filtering the list of database instances

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 filter the list of database instances:

•	Choose one of the following ways to filter the list of database instances.

▪	To list only the database instances of a selected database type, click the tile identifying that type. For example, to list only the Sybase database instances, click the Sybase tile.

▪	To list only the database instances of a selected database type that are in a specific alarm state, click the alarm state icon on the database type tile. For example, to list only the Sybase database instances that are in Warning state, click on the Sybase tile.

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

The list of databases refreshes, showing only the entries that match the specified filter.