Converse agora com nosso suporte
Chat com o suporte

Foglight for Sybase 5.7.5.40 - 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 About us

System Wait Events Tab

Previous Next



System Wait Events Tab

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

Figure 21. System Wait Events Tab

System Wait Events Chart
System Wait Classes Table

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

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.

Wait Events Details Table

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

Spinlocks Tab

Previous Next



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’ Sybase 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:

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

Description

Table 29. Spinlocks Tab Description

Execution Time Tab

Previous Next



Execution Time Tab

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

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

Engine Activity Dashboard

Previous Next



Engine Activity Dashboard

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

Documentos relacionados
Foglight for Sybase - 5.7.5.40
Release Notes
User and Reference Guide
Showing 1 to 2 of 2 rows

The document was helpful.

Selecione a classificação

I easily found the information I needed.

Selecione a classificação