Using Foglight for Sybase

Using Foglight for Sybase

The Sybase cartridge monitors the Sybase database activity. It contains three major components:

•	Sybase cartridge dashboards provide a visual representation of the status of the major components of the Sybase database. They allow you to determine any potential bottlenecks in database performance. For more information, see Exploring the Sybase Dashboards.

•	Sybase_MDA Agents monitor the collection of data by the Sybase Web-enabled relational database management system.

The Sybase_MDA Agent identifies potential resource bottlenecks, investigates current server problems, and tunes the server.The Sybase_MDA Agent also allows you to select a “monitoring level” (called Availability, Performance, Configuration and Trend). Each level is associated with a group of tables and their associated collection. By default, Availability is activated and all others are turned off. A user can optionally select Performance, Configuration or Trend to tune the agent to collect the metrics important to their environment.

Some of the functions that are available with the Sybase_MDA Agent are:

▪	Ability to collect performance data using the MDA tables.

▪

The Limit Incoming Rows agent property feature allows all tables that can return multiple rows to have a corresponding entry in this agent property. This table list displays a set of criteria developed to limit the amount of data written to the Foglight database. These values are used strictly to manage the amount of data written to the Foglight database and NOT to configure the rules. Rules are still configured by registry variables.

▪	Improved command and connection time-out handling.

▪

Cluster-tolerant support allows you to monitor Sybase cluster nodes. Each cluster node is monitored separately. To enable this behavior, you need to create a separate Foglight Sybase user. The Sybase dashboards show shared resources as well as node-specific private resources for these cluster nodes. Each monitored cluster node requires a separate instance of the Sybase_MDA Agent.

For more information, see About the Sybase_MDA Agent.

•	Sybase_RS Agents provide a consolidated view of all database instances within a Sybase server.

The Sybase_RS Agent monitors the Replication Server on the host it is deployed on. The agent collects internal performance and availability metrics by connecting to the Replication Server directly and from its related RSSD database via a connection to the respective Adaptive Server. The agent monitors Replication Server health, internal threads, partitions (space and status), connections, and exceptions. It also scans the external error log of the Replication Server looking for any default or user defined errors.

In addition, the Sybase_RS Agent also gathers availability information of the Replication Agent (RepAgent) from the primary sites (Adaptive Servers / databases) connected directly to this Replication Server as well as latency information from the Replicate Sites (Adaptive Servers / databases) controlled directly from this Replication Server.

For more information, see About the Sybase_RS Agent.

Exploring the Sybase Dashboards

Exploring the Sybase Dashboards

The Foglight for Sybase includes dashboards which aid in the monitoring, analysis, and investigation of Sybase performance.

These dashboards provide the status of the major components of the Sybase agents. They allow you to determine any potential bottlenecks in database performance.

Accessing the Sybase Dashboards

Accessing the Sybase Dashboards

To access the Sybase dashboards:

NOTE: The user must be a member of a Foglight group which has been assigned the Sybase DBA role in order to view the dashboards.

1	On the navigation panel, under Dashboards, click one of the following:

▪	SYBA: Sybase_MDA to display the list of Sybase_MDA Agent views. See Views for details.

▪	SYBA: Sybase_RS to display the list of Sybase_RS Agent views. See Views for details.

▪	SybaseMDA > Sybase MDA Global View to display the Sybase MDA Global View Dashboard.

▪	SybaseMDA > Sybase MDA Global View, from there, click a Sybase_MDA agent instance to display the MDA Home Page Dashboard.

▪	SybaseMDA > Sybase MDA Global View, from there, click a Sybase_RS agent instance to display the RS Home Page Dashboard.

2	On the navigation panel, under Homes, click Databases to display the Databases Dashboard.

Sybase MDA Global View Dashboard

Sybase MDA Global View Dashboard

This Sybase Global View dashboard provides many drilldowns for Sybase agents. An overview of the dashboard navigation is shown below.

The Sybase Global View dashboard is comprised of two parts:

•	Sybase Alarms Selection

•	Sybase Agent Table

From the Sybase Agent Table, you can drill down to Sybase Agents Home Pages.

Figure 1. Sybase Agents Home Pages