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

Investigating Stable Queues

The Foglight Cartridge for SAP ASE assists your investigation into replication server stable queues with the RS_SQM_Trend table view, RS_SQM_Activity graph view, RS_SQM_QueueSize graph view, and the RS_SQM_TrailSize graph view.

Stable Queues are Store-and-forward queues where Replication Server stores messages destined for a route or database connection. Messages written into a stable queue remain there until they can be delivered to the destination Replication Server or database. Replication Server builds and allocates space for the stable queues from the disk partitions created for the Replication Server. The most referenced types of queues are inbound (transactions from a Primary Server) and outbound (transaction messages for another Replication Server via a route or to a direct Data Server connection - DSI).

Foglight allows a Replication Server administrator to monitor the overall performance of the stable queues over time by gathering the respective metrics and allowing these metrics to be viewed in pertinent graphs.

Monitoring the stable queues can be a measure of how much activity or volume is passing through the Replication Server. The Replication Server administrator can use this information to understand the performance profile of the monitored Replication Server. This information also serves as a tool for capacity planning.

The trending of SQM performance can be turned on or off via the Sybase_RS agent properties. Refer to the Sybase_MDA Agent Properties for this agent.

Investigating Partition Status

The Foglight Cartridge for SAP ASE assists your investigation into partition status with the RS_PartitionStatusSummary graph view and the RS_PartitionStatusDetail table view.

Partitions in Replication Server are a raw disk partition or operating system file that Replication Server uses for stable queue storage.

Foglight monitors the Replication Server for any partition that is not in an online state. The RS_PartitionStatusSummary graph view provides a quick overview of partition status on the monitored Replication Server. Foglight returns more detailed information on any partition that is not online.

Foglight raises an alert if any partition is found in any state other than online.

Review the Replication Server error log for any additional information about an off-line partition. Check the location of the physical device and see if there are any reported errors on the physical volume.

Open this graph directly, or from the RS_Internal_Overview graph view after clicking Partitions Offline.

Investigating Partition Space

The Foglight Cartridge for SAP ASE assists your investigation into partition space with the RS_PartitionSpaceUsedSummary table view and the RS_PartitionSpace_Trend table view. Partitions in Replication Server are a raw disk partition or operating system file that Replication Server uses for stable queue storage.

Foglight monitors the replication Server for overall Partition Space that is allocated to the stable queues. The RS_PartitionSpaceUsedSummary table view gives a quick overview of partition space on the monitored Replication Server.

The RS_PartitionSpace_Trend table view provides information to track individual partition space allocation over time. Trending must be turned on in order for this information to be available. Review the agent properties for the Sybase_RS Agent for more information on how to configure this.

Investigating Error Log Messages

The Foglight Cartridge for SAP ASE assists your investigation into the status of the monitored Replication Server by returning pertinent messages Foglight finds in the Replication Server error log.

Replication Server errors are recorded in the Replication Server error log. A Replication Server error log contains informational, warning, thread-terminated, fatal, and internal error messages.

Open the RS_ErrorlogSummary table view to display summary information from the Replication Server error log. This view provides summary totals for each type of message in the error log found in the last poll cycle for the Sybase_RS Agent.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating