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

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

Foglight for Sybase 5.9.7.10 - 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 25 - 28 of 115

×

System Wait Events Tab

System Wait Events Tab

The System Wait Events tab information is provided in a chart and two tables:

•	System Wait Events Chart

•	System Wait Classes Table

•	Wait Events Details Table

Figure 21. System Wait Events Tab

System Wait Events Chart

 

Table 26. System Wait Events Chart Description

Name	Description
System Wait Classes	The following wait classes, plotted over time: • Process is running • waiting to be scheduled • disk read • disk write • log semaphore • lock • memory or a buffer • network (input) • network (output) • system event • another thread

System Wait Classes Table

You can choose to display the system wait classes for either:

•	Last Sample

•

Period

The columns are common for both the Show Last Sample and Show Time Range tables.

You can view detailed information for a wait class by clicking a row in the System Wait Classes table. The detailed information appears in the Wait Events Details Table, located at the bottom-right of the screen at the next data refresh.

 

Table 27. System Wait Events Table Description

Name	Description
Class ID	A sequential number for the class identifier.
Class Description	The description of the class: • Process is running • waiting to be scheduled • waiting for a disk read to complete • waiting for a disk write to complete • waiting to acquire the log semaphore
% of Total Wait Time	The percentage total wait time for this class.
Number of Waits	The number of waits for this class.
Wait Time (sec)	The wait time for this class in seconds.

Wait Events Details Table

The content of this table is determined by the selection made in the System Wait Classes Table.

 

Table 28. Wait Events Details Table Description

Name	Description
Class ID	A sequential number for the class identifier.
Event ID	The event identifier number.
Description	The description of the wait event; for example: • waiting to run queue after sleep • waiting to run queue after yield
Number of Waits	The number of waits for this event.
Wait Time (sec)	The wait time for this event in seconds.

Spinlocks Tab

ASE uses spinlocks as synchronization mechanisms in SMP environment in order to protect shared resources. Use this dashboard to find areas where spinlock are a contention and tune their configuration. Data is available for Sybase version ASE 15.7 ESD#2 and above.

To monitor spinlocks, enable the ‘Enable spinlock monitoring’ SAP ASE configuration parameters using the following command:

sp_configure "enable spinlock monitoring", 1

The dashboard shows the following type of objects in which ASE applies the spinlock mechanism:

•	Object Manager

•

Object

•

Index

•	Index Hash

•	Partition Hash

•	Lock Address Manager

•	Lock Manager

•	Procedure Cache

•	Procedure Cache Manager

For information about Data Caches Spinlock Contention, refer to the Buffer Pools Dashboard .

Description

Table 29. Spinlocks Tab Description

Name	Description
Name	Name of spinlock
Contention	Spinlock contention as percentage of waits in grabs.
Grabs	Number of grabs of this spinlock
Spins	Number of spins of this spinlock
Waits	Number of waits of this spinlock
Spins per wait	Number of spins per wait.

Execution Time Tab

This dashboard shows the execution time of each of the following operations performed in an instance:

•	Compilation

•

DeviceIO

•

NetworkIO

•

Execution

•

Sorting.

Use this dashboard to understand where does the instance spends most of its time and to analyze trends in its behavior. Data is available for Sybase version ASE 15.7 SP100 and above.

Table 30. Execution Time Tab Description

Name	Description
Module	Name of operation category.
Execution Time	Execution time, in microseconds, of each operation performed.
Execution Count	Total number of this operation type that took place.

Engines Dashboard

Engines Dashboard

The Engines dashboard provides performance details for Engine operations. This dashboard contains the following:

•	Engine Details Tab

•	Engines Processes Tab

•	Engines Host Tab

•	Engines Compare Tab

•  Previous
• Viewing Topics 25 - 28 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

© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center