지금 지원 담당자와 채팅
지원 담당자와 채팅

Foglight for Sybase 6.3.0 - User and Reference Guide

Using Foglight for SAP ASE
Exploring the SAP ASE Dashboards About the Sybase_MDA Agent About the Sybase_RS Agent Generating SybaseMDA Reports
Reference

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
관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택