Chatta subito con l'assistenza
Chat con il supporto

Foglight for Sybase 5.7.5.40 - User and Reference Guide

Using Foglight for Sybase
Exploring the Sybase Dashboards About the Sybase_MDA Agent About the Sybase_RS Agent Generating SybaseMDA Reports
Reference About us

Investigating Sybase Performance

Previous Next



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:

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:
To Inspect Adaptive Server Device I/O:
To Inspect Adaptive Server Cache effectiveness:
To Inspect Adaptive Server Procedure Cache effectiveness:
To Inspect locking:
To Inspect User connection activity:

Investigating the User Log Cache

Previous Next



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

Previous Next


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

Previous Next



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:

To modify agent properties:

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

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.

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione