• Become a portal pro
• Download
• Print
• My Downloads ()

• Support
• Technical Documentation
• Foglight for Sybase 6.3.0
• Foglight for Sybase 6.3.0 - User and Reference Guide

Foglight for Sybase 6.3.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

Reference

Views

• Viewing Topics 29 - 32 of 115

×

Engine Details Tab

Engine Details Tab

Engine details information is provided in a table and a chart:

•	Engine Details Table

•	Engine Summary Charts

Figure 22. Engine Details Tab

Engine Details Table

You can filter the Engine Details table to include:

•

Engines

•	Engine Groups / Thread Pools

•	Engines and Groups / Thread Pools

IMPORTANT: Thread pool information is only available from Sybase ASE 15.7 ESD2 and later.

 

Table 31. Engine Details Table Description

Name	Description
Engine
No.	The engine number.
Current Status	The current status of the engine: online or offline. Hovering over this value provides more information.
Last Sample
Eng. Busy %	The percentage busy for this engine.
CPU Busy %	The percentage CPU time all engines spent not idle.
I/O Busy %	The percentage of input/output resources currently being used by the database engine.
Cont. Switches %	The percentage of the total number of context switches for the engine divided by those completed for all engines.
Context Switches rate (c/s)	The count of context switches for the engine occurring per second.
Disk IO Checks rate	The number of times the engine checked for asynchronous disk I/O.
Checks Returning I/O %	The percentage of disk I/O checks with I/O pending.
Async IO Completed	The number of times the engine completed I/O.
Processes Affinitied	The number of processes affined with the engine.
Time Range Period
Total Busy	The percentage busy for all of the database engines.
Avg Busy %	The average percentage busy for all of the database engines.
Max Busy %	The maximum percentage busy for all of the database engines.
Avg I/O Busy %	The average percentage of input/output resources currently being used by all of the database engines.
Avg CPU Busy %	The average percentage CPU time all database engines spent not idle.
Cont. Switches %	The percentage of the total number of context switches for one engine divided by those completed for all engines.

Engine Summary Charts

 

Name	Description
Engine Summary	The following three values, plotted over time: • Average Engine Total Busy • Average Engine I/O Busy • Average Engine CPU Busy
Engines Busy	Plots how busy an engine was over time. Select from the list of available engines.
Engine Groups / Thread Pools Busy 1	Plots an average of how busy an engine group or thread pool was over time. Select from the list of available engine groups or thread pools.

---

1

For thread pools, this information is only available from Sybase ASE 15.7 ESD2 and later.

To view a plot of the maximum value over the course of the time period, select Show Maximum.

Engines Processes Tab

Engines Processes Tab

The engine processes information is provided in three charts.

Figure 23. Engines Processes Tab

Engine Processes Charts

 

Table 32. Engine Processes Chart Description

Name	Description
Engine Summary	The following values, plotted over time: • Average Engine Total Busy • Average Engine I/O Busy • Average Engine CPU Busy
Active Processes	The number of engine processes running, plotted over time.
Context Switches	The number of engine context switches, plotted over time.

Engines Host Tab

Engines Host Tab

The engines host information is provided in two charts.

Engines Host Charts

 

Table 33. Engine Host Charts Descriptions

Name	Description
Engines Host	The following values, plotted over time, for each engine: • Sybase Engines. The percentage of engine utilization. • Host CPUs. The percentage of utilized host CPU resources being used by the Sybase engines.
All Engines Activity	The percentage of activity for each engine.

Engines Compare Tab

Engines Compare Tab

The engines compare information is provided in three charts.

Engines Compare Charts

 

Table 34. Engines Compare Charts Description

Name	Description
Engines - time range	The following values, plotted over time: • Average Engine Total Busy • Average Engine I/O Busy • Average Engine CPU Busy
Engines - month, day, year	This displays the plotted values for the previous day (that is, yesterday). The following values, plotted over time: • Average Engine Total Busy • Average Engine I/O Busy • Average Engine CPU Busy
Engines - month, day, year	This displays the plotted values from today minus seven days (that is, a week ago) for a 24 hour period. The following values, plotted over time: • Average Engine Total Busy • Average Engine I/O Busy • Average Engine CPU Busy

•  Previous
• Viewing Topics 29 - 32 of 115
• Next 

Search this document Search all documents

×

 Welcome to Quest Support

You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.

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