Foglight for Sybase 5.7.5.40 - User and Reference Guide

Investigating Sybase Performance

Investigating Sybase Performance

Performance is the measure of efficiency for an application or multiple applications running in the same environment.

The Foglight Cartridge for Sybase measures efficiency by performing the following tasks:

•	Collects data about a Sybase Adaptive Server instance.

•	Analyzes and converts the raw data into useful information.

•	Compares data against a set of Foglight rules that you can customize to look for current or potential problems.

•	Alerts designated individuals when a problem is identified.

To start with the SYBM_Overview graph:

•

Open the SYBM_Overview graph view which displays an overview of the system performance of the Sybase Adaptive Server. Specifically, it shows the percentage of time the server was busy with User Requests, the percentage of time spent performing I/O requests, lock contention and cache hit rates for data and procedure caches along with user connection activity.

To inspect Adaptive Server CPU utilizations:

•	Drill down on the CPU - Busy (%) line to investigate how busy all Adaptive Server engines were during the time that the CPU was available to Adaptive Server. This data is displayed in the SYBM_EngineSummary graph view. See Investigating CPU Capacity for additional related information in Foglight.

To Inspect Adaptive Server Device I/O:

•	Drill down on the CPU - I/O (%) line to obtain a summary of I/O metrics for all Sybase logical devices during the collection period. This data is displayed in the SYBM_DiskIOSummary graph view. See Investigating Disk Performance for additional related information in Foglight.

To Inspect Adaptive Server Cache effectiveness:

•	Drill down on the Data Cache Hit (%) line to investigate the number of hits and misses for all caches during the collection period. This data is displayed in the SYBM_DataCacheSummary graph view. See Investigating Data Cache Performance for additional related information in Foglight.

To Inspect Adaptive Server Procedure Cache effectiveness:

•	Drill down on the Procedure Cache (%) line to investigate the number of Requests and Loads for the Procedure cache during the collection period. This data is displayed in the SYBM_ProcedureCache graph view. See Investigating Procedure Cache for additional related information in Foglight.

To Inspect locking:

•	Drill down on the Lock Contention (%) line to investigate the total number of deadlocks, locks timed out, etc. This data is displayed in the SYBM_LockSummary graph view, see Investigating Locking for additional related information in Foglight.

To Inspect User connection activity:

•	Drill down on the Connections Used (%) line to investigate the number of active, idle and blocked connections. This data is displayed in the SYBM_Processes graph view.

Investigating the User Log Cache

Investigating the User Log Cache

The Foglight Cartridge for Sybase assists your investigation on the proper sizing of the user log cache.

To start with the SYBM_UserLogCache graph:

•	Open the SYBM_UserLogCache graph view which displays the percentage of times the user log cache was flushed because it was full.

A high user log cache value indicates that the Adaptive Server is flushing the User Log Cache (ULC) more than once per transaction, negating some performance benefits of user log caches. If the percentage is greater than 20%, consider increasing the size of the user log cache size parameter.

Increasing the ULC size increases the amount of memory required for each user connection, so you do not want to configure the ULC size to suit a small percentage of large transactions.

About the Sybase_RS Agent

About the Sybase_RS Agent

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 and databases) connected directly to this Replication Server as well as latency information from the Replicate Sites (Adaptive Servers and databases) controlled directly from this Replication Server.

Sybase_RS Agent Properties

Sybase_RS Agent Properties

When an agent connects to the Foglight Management Server, it is provided with sets of properties that it uses to configure its correct running state.

Each agent is provided with a combination of two types of properties: agent properties and shareable properties.

Default versions of these properties are installed with the Foglight for Sybase. However, you can edit the default shareable and agent properties, configure agent properties that apply only to a specific agent instance, and create edited clones of shareable properties that are used by a subset of the agents of a certain type.

For more information about working with agent properties, see the Foglight Administration and Configuration Guide.

The Sybase_RS Agent is shipped with default properties that can be modified to suit your system requirements.

Agent properties described in this section comprise:

▪	Setting Connection Details

▪	Setting Data Management Properties

▪	Setting Configuration Properties

▪	Setting Data Retrieval Properties

To modify agent properties:

1	Ensure that the navigation panel on the left is open.

To open the navigation panel, click the right-facing arrow on the left .

2	Open the dashboard that lets you navigate to the agent properties by completing one of the following steps:

▪	On the navigation panel, under Dashboards, click Administration > Agents > Agent Properties.

In the Agent Properties dashboard, in the Namespace > Type pane, select Legacy > Sybase_RS.

 

▪	On the navigation panel, under Dashboards, click Administration > Agents > Agent Status.

In the Agent Status dashboard, select the instance of the Sybase_RS Agent whose properties you want to modify and click Edit Properties.

A list of agent properties appears in the Sybase_RS pane.

Figure 48. Agent Properties List

The position of the Properties pane depends on the dashboard you used to access agent properties. If you used the Agent Properties dashboard, the Properties pane appears to the right of the Namespace > Type pane in the display area. If you used the Agent Status dashboard, the Properties pane appears across the display area.