Foglight for Sybase 5.7.5.40 - User and Reference Guide

Sybase_RS Agent Investigations

Sybase_RS Agent Investigations

This section describes the following investigations:

•	Investigating Connections

•	Investigating Health and Availability of the Replication Server

•	Investigating Threads Down

•	Investigating Stable Queues

•	Investigating Partition Status

•	Investigating Partition Space

•	Investigating Error Log Messages

•	Investigating Latency

Investigating Connections

Investigating Connections

The Foglight Cartridge for Sybase assists your investigation into replication server connections with the RS_ConnectionSummary graph view and RS_ConnectionDetail table view.

Connections can be either a route to another Replication Server, or a data server connection to an Adaptive Server managed by the monitored Replication Server. The RS_ConnectionSummary graph view gives a summary of each connection state to provide an overall view of all the connections managed by the monitored Replication Server.

The RS_ConnectionDetail table view provides more in-depth information on each of the connections that are returned to Foglight. Review the Sybase replication Server Administration guide for a description of each state and the procedures on how to address them.

Foglight also raises an alert to notify the Replication Server administrator when a connection is returned to Foglight.

To start with the RS_ConnectionSummary graph view:

•	Open this graph directly or from the RS_Internal_Overview graph view after clicking on closed connections.

•	The RS_ConnectionSummary graph view shows each connection status type and the number of connections associated with each state.

To view more detailed information:

•	Drill down on the Connecting line to view detailed information on Sybase Replication Server connections with the RS_ConnectionDetail table view. This view shows more specific information on each connection returned to Foglight.

Investigating Health and Availability of the Replication Server

Investigating Health and Availability of the Replication Server

The Sybase_RS Agent determines the health and availability of the monitored Replication Server several ways. It first attempts to open a new connection to the Replication Server each poll cycle. Once a connection has been established, it requests a confirmation that it is responding. Lastly, the agent requests the health status of the Replication Server.

Each of the steps is recorded by the Foglight agent and returned to the Foglight Management Server. Use the views below to investigate the status and health of the monitored Replication Server.

Foglight raises an alert if the health or availability of the Replication Server changes to an undesirable state.

To start with the RS_State_Overview graph view:

•	Open the RS_State_Overview graph view to display a graphical representation of the Replication Servers health and availability.

To view more detailed information related to the RS_State_Overview graph view:

•	Drill down on the Health Status line to view each discrete Health state with the RS_Health graph view.

•	Drill down on the Health Status line to view a textual description of each state in a tabular format.

•	Drill down on the Connect column to get to the RS_Availability graph view and inspect a graphical chart of the availability states of the monitored Replication Server.

To view more detailed information related to the RS_Availability graph view:

•	Drill down on the Connect line to view a textual description of each state in a tabular format.

Investigating Threads Down

Investigating Threads Down

The Foglight Cartridge for Sybase assists your investigation into Sybase Replication Server internal status. Use the RS_ThreadsDownSummary table view to get an overview of the overall state of the critical internal components of the Replication Server. The RS_ThreadsDown_Detail table view provides more detailed information on each thread that is in a down state as indicated by the monitored Replication Server.

Use the thread name and the related information to identify the component. Check the Replication Server error log (use the RS_ErrorlogDetail table view to see if there is additional debug information available. If the component in a down state is a route or connection then connect to the respective Adaptive or Replication Server to further diagnose the issue.

Foglight also raises an alert to notify the Replication Server administrator when any down thread is detected.

To start with the RS_ThreadsDownSummary table:

•	Open the RS_ThreadsDownSummary table view to display thread state summary totals of the Replication Server.

To view more detailed information:

•	Drill down on the Name column to view information on Replication Server threads that are down with the RS_ThreadsDown_Detail table view.