Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Foglight for Sybase 7.1.0 - User and Reference Guide

Table of Contents

Using Foglight for SAP ASE

Exploring the SAP ASE Dashboards

Accessing the SAP ASE Dashboards Sybase MDA Global View Dashboard

SAP ASE Alarms Selection Sybase Agent Table Sybase Agents Home Pages

MDA Home Page Dashboard

MDA Instance Metrics MDA Alarms MDA Processes Metrics MDA Engines Metrics MDA Shared Memory Metrics MDA Host Metrics MDA Devices Metrics MDA Input/Output Metrics

Top Activity Dashboard

Top Hash Tab Top SQL Tab Top Procedures Tab Top Users Tab Current Top Sessions Tab SQL Details Tab Blocked Tree Tab System Wait Events Tab Spinlocks Tab Execution Time Tab

Engines Dashboard

Engine Details Tab Engines Processes Tab Engines Host Tab Engines Compare Tab

Disk I/O Dashboard

Device Spaces Tab Device Activity Tab Physical I/O for Devices Tab

Buffer Pools Dashboard

Data Cache Activity Tab Buffer Pools Activity Tab Procedure Cache Activity Tab Data Caches Spinlocks Tab

Database Spaces and Trends Dashboard

DB Spaces Tab Table Spaces Tab Table Performance Tab Top I/O Active Tables Top Lock Activity Tables

RS Home Page Dashboard

RS Instance Metrics RS Alarms RSSD Metrics RS Host Metrics Replication Server Metrics

Replication Server Activity Dashboard

Primary Servers Metrics Replication Server Metrics Replicated Servers Metrics

Databases Dashboard

Viewing the list of database instances Filtering the list of database instances Managing database groups Exploring the state of selected database instances

Manage Thresholds Dashboard

About the Sybase_MDA Agent

Configuring SAP ASE Login Privileges

Using a secondary database to store collected data

Configuring the Sybase_MDA Agent for Remote Monitoring Sybase_MDA Agent Properties

Setting Connection Details Setting Callback Connection Properties Setting Data Management Properties Setting Table Space Management Properties Setting Data Retrieval Properties Setting Benchmark Properties Setting Configuration Properties

Sybase_MDA Investigations

Investigating Application Usage Investigating CPU Capacity Investigating Data Cache Performance Investigating Database Space Investigating Disk Performance Investigating Index Performance Investigating Locking Investigating Meta Data Cache Contention Investigating Network Activity Investigating Parallel Queries Investigating Procedure Cache Investigating Resource Utilization Investigating SAP ASE Performance Investigating the User Log Cache

About the Sybase_RS Agent

Sybase_RS Agent Properties

Setting Connection Details Setting Data Management Properties Setting Configuration Properties Setting Data Retrieval Properties

Sybase_RS Agent 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

Generating SybaseMDA Reports

Cache Activity Report Change Tracking Summary Report Engine Activity Report I/O and Network Activity Report Locks Activity Report Top SQL Top Procedure Report Workload Summary Extended Report

Views

MDA Instance Metrics

MDA Instance Metrics

Table 3. MDA Instance Metrics
Name	Description
DB Type	Type of database.
Version	The Sybase version being monitored. You can expand the version detail by clicking on or hovering on any version number.
Up Since	The date and time that the Sybase agent was last restarted.
Eng. Summary
Last Sample Time	The last date (month/day/year) and time (hour:minute, AM/PM) that data was sampled.
Sample Period	The frequency (in seconds) of data sampling.
Sybase Error Log
The number of Sybase errors. This field displays color-coded real-time behavior for severity. You can drill down by clicking on the device symbol. A popup appears showing a detailed list of the errors.

MDA Alarms

Table 4. MDA Alarms

When the agent instance is running, the following status message appears:

•

Collecting Data

When the agent instance is running but not collecting data, one of the following status messages appear:

•

•

•

•

Running but not collecting data (initiated by clicking

•

The number of fatal, critical, and warning alarms for this host.

You can drill down to the detailed alarm list.

The number of fatal, critical, and warning alarms for this database agent.

You can drill down to the detailed alarm list.

MDA Processes Metrics

MDA Processes Metrics

Table 5. MDA Processes Metrics

Connections in Use

The number of client application connections currently in use.

You can drill down by clicking on the device symbol. A popup appears showing the number of current connections in use plotted over time. It provides further drill downs to:

•

Top Activity Drilldown—a Top Activity Dashboard appears.

•

Edit Threshold—a Manage Thresholds Dashboard appears.

Connection Usage

The percentage of total available connections currently in use.

You can drill down by clicking on the number. A popup appears showing the percentage of connections that are available, plotted over time. It provides further drill downs to:

•

Top Activity Drilldown—a Top Activity Dashboard appears.

•

Edit Threshold—a Manage Thresholds Dashboard appears.

Active Processes

The number of active client application connections.

You can drill down by clicking on the device symbol. A popup appears showing the active connections plotted over time. It provides further drill downs to:

•

Top Activity Drilldown—a Top Activity Dashboard appears.

•

Edit Threshold—a Manage Thresholds Dashboard appears.

Active Processes Percent

The percentage of total available processes currently in use.

This field displays color-coded real-time behavior for severity.

You can drill down by clicking on the number. A popup appears showing the percentage of processes that are active, plotted over time. It provides further drill downs to:

•

Top Activity Drilldown—a Top Activity Dashboard appears.

•

Edit Threshold—a Manage Thresholds Dashboard appears.

Last Probe Requested

The number of the last probe requested.

This field displays color-coded real-time behavior for severity.

Average Locks Wait (sec)

The average amount of time spent waiting for a lock to release.

This field displays color-coded real-time behavior for severity.

The number of blocked processes detected.

This field displays color-coded real-time behavior for severity.

The number of deadlocks detected.

This field displays color-coded real-time behavior for severity.

MDA Engines Metrics

MDA Engines Metrics

Table 6. MDA Engines Metrics

The number of database engines currently online.

This field displays color-coded real-time behavior for severity.

The number of database engines currently configured.

This field displays color-coded real-time behavior for severity.

Avg. Engines Busy

The average number of database engines that are busy.

This field displays color-coded real-time behavior for severity.

You can drill down by clicking on the icon. A popup appears showing the percentage of engine total busy and engine I/O busy, plotted over time. It provides further drill downs to:

•

Engines Drilldown—a Engines Dashboard appears.

•

Edit Threshold—a Manage Thresholds Dashboard appears.

The percentage of CPU time all engines spent not idle.

This field displays color-coded real-time behavior for severity.

You can drill down by clicking on the number. A popup appears showing the percentage of engine total busy and engine I/O busy, plotted over time. It provides further drill downs to:

•

Engines Drilldown—a Engines Dashboard appears.

•

Edit Threshold—a Manage Thresholds Dashboard appears.

The percentage of input/output resources currently being used by the database engines.

This field displays color-coded real-time behavior for severity.

You can drill down by clicking on the number. A popup appears showing the percentage of engine total busy and engine I/O busy, plotted over time. It provides further drill downs to:

•

Engines Drilldown—a Engines Dashboard appears.

•

Edit Threshold—a Manage Thresholds Dashboard appears.

Context Switches /s

The number of context switches for the engines in this database, per second.

This field displays color-coded real-time behavior for severity.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center