Chat now with support
Chat with Support

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

Using Foglight for SAP ASE

The SAP (formerly Sybase) ASE cartridge monitors the SAP ASE database activity. It contains three major components:

•
SAP ASE cartridge dashboards provide a visual representation of the status of the major components of the SAP ASE database. They allow you to determine any potential bottlenecks in database performance. For more information, see Exploring the SAP ASE Dashboards .
•
Sybase_MDA Agents monitor the collection of data by the SAP ASE 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 SAP ASE cluster nodes. Each cluster node is monitored separately. To enable this behavior, you need to create a separate Foglight SAP ASE user. The SAP ASE 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 SAP ASE 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 SAP ASE Dashboards

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

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

Accessing the SAP ASE Dashboards

To access the SAP ASE dashboards:
* 
NOTE: The user must be a member of a Foglight group which has been assigned the SAP ASE 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 SAP ASE agents. An overview of the dashboard navigation is shown below.

The Sybase Global View dashboard is comprised of two parts:

•
SAP ASE Alarms Selection
•
Sybase Agent Table

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

Figure 1. SAP ASE Agents Home Pages
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating