Chat now with support
Chat with Support

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

Investigating Application Usage

The Sybase_MDA Agent allows you to quickly view and determine which applications are using the most CPU resources.

2
Go to the Data Management set of agent parameters.
3
Ensure that the Performance parameter has the True button selected, so that performance data is collected.
4
Ensure that the Performance Monitoring list item Top Applications is set to True.

Investigating CPU Capacity

The Foglight Cartridge for Sybase assists your investigation into Sybase ASE CPU use and availability.

This cartridge tracks internal allocation of CPU resources by the Adaptive Server as well as the external performance characteristics of the Adaptive Server processes from the perspective of the host Operating System.

If the CPU utilization is high for users, but the connections in use are not increasing, go to the SYBM_TopUsers table view to see if a single user is consuming disproportional amount of resources. This view identifies users who have crossed your predefined threshold.
Open the SYBM_OS_CpuDetail graph view. This graph shows Operating System CPU utilization broken down by each respective ASE engine process.
Open the SYBM_EnginePerfDetail graph view, where the CPU utilization levels are broken down by Adaptive Server engine.
From the SYBM_EnginePerfDetail graph view, you can drill down to the SYBM_EngineInfoDetail table view for general information on each engine, such as engine status or start time.

Investigating Data Cache Performance

Sybase Adaptive Server reserves memory to hold the data, index, log pages currently in use, and pages recently used by the Adaptive Server. This region of the memory is called the data cache. The initial installation of Adaptive Server creates a single default data cache that is used for all data, index, and log activity.

A DBA can create and configure additional regions for data cache which are commonly referred to as named caches.

The named data caches can only be used by databases or database objects that are explicitly bound to them. All objects not explicitly bound to named data caches use the default data cache.

Data caches can be sub-divided into regions called data pools. These data pools can be of varying page sizes. The amount of space allocated to a data pool and the corresponding page size allows a DBA to tune the cache for larger I/Os and, in turn, more efficient I/O utilization than the default settings would provide.

Open the SYBM_DataCacheSummary graph view which summarizes the effectiveness of the cache design on the server as a whole. This view displays the total number of hits and misses for all caches during the collection period.

Investigating Database Space

The Foglight Cartridge for Sybase assists your investigation into database space with the SYBM_DbSpace graph and SYBM_TempDbSpace graph views. Both are identical except that the temporary databases are reported separately.

These views show the data space utilization for the respective database.

Transaction log space is reported separately in SYBM_DbSpaceTransLog graph and the SYBM_TempDbSpaceTransLog graph views.

Both sets of views only report on databases that have crossed a threshold defining how much space is used. This threshold is set by editing the respective agent properties.

1
Go to the agent properties by Dashboards: Administration > Agents > Agent Status.
4
Double-click a Foglight Table Group.
5
Enter a Limit Criteria Value and click the Save button.

See the Foglight online help for more detailed information on editing agent properties.

For each database returned, you can drill down to the SYBM_DbSpaceSegment graph view or the SYBM_TempDbSpaceSegment graph view to see space allocations per segment.

To see database utilization over a period of time, go to the SYBM_DbSpaceTrendChart graph view.

NOTE: You must set Space Trending to True (default is off) in the Data Management agent properties for this agent.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating