Chat now with support
Chat mit Support

Foglight for Sybase 5.9.5.10 - 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

Top Users Tab

Top Users Tab

This tab covers the same users listed in the Current Top Sessions Tab.

The difference are:

•
The Current Top Session tab shows data aggregated since user login.
•
The Top Users tab shows data aggregated for each user according to the time range. This allows you to view users that were displayed in the Current Top Session tab, but may not currently be displayed; for example, the user has logged out.

The users shown in this table are determined by the values set for the following Sybase_MDA agent properties:

•
Top Users - Max Rows Returned
•
Top Users - Minimum Threshold Value
•
Top Users - Sort Criteria

For more information, see Setting Data Retrieval Properties .

Top user information is provided in two tables:

•
Top Users Table
•
SQL Text Table
Figure 17. Top User Information

Top Users Table
 
Table 21. Top User Table Description
Name
Description

Login Name

The login name of the top user.

CPU Time (ms)

The CPU time (in milliseconds) used by the process.

Memory Usage (kB)

The amount of memory (in kilobytes) allocated to the process.

Logical Reads

The number of buffers read from cache.

Physical Reads

The number of buffers read from disk.

Physical Writes

The number of buffers written to disk.

SQL Text Table

This table has the same columns as the Top SQL Table. The only difference is that the SQL Text table provides data for selected user-executed SQL statements.

Current Top Sessions Tab

Current Top Sessions Tab

Current top session information is provided in three tables:

•
Top Sessions Table
•
Top SQL of Session with SPID Table
•
Wait Events of SPID xx for Period Table

You can filter the Current Top Sessions according to the Wait Classes, by clicking Choose Resource. Then select a resource from the list of the Wait Classes for events that occurred in the time period. This allows you to view only those processes for which that specific Wait Class occurred. The possible wait classes are:

•
Workload
•
waiting for a disk write to complete
•
waiting for a disk read to complete
•
waiting to be scheduled
•
waiting for memory or a buffer
•
waiting to output to the network
•
waiting for internal system event
Top Sessions Table

The Top Sessions table lists all of the top sessions.

The filters appearing just above the table allows you to look for specific entry based on some known criteria. You can filter on:

•
System or user processes
•
Time range, by selecting Since Logon, Last Sample, or Last 10 min

Click the Login Name for a session to view a popup that provides real-time monitoring details about the associated process.

Figure 18. SPID Details

These details include the time (in milliseconds) that has elapsed since the process was last run. Values for other statistics since the process was last run are provided in brackets.

Select an option button on the Top Sessions table to specify the SPID (session process identifier) number.

 
Table 22. Top Sessions Table Descriptions
Name
Description

Option button

Shows additional information about the selected SPID in the Top SQL of Session with SPID Table and Wait Events of SPID xx for Period Table.

Login Name

The login name used to open the SAP ASE session.

SPID

The Session Process Identifier (SPID) number.

Block by

If there is a block, this column shows the blocking process ID in red.

Database Name

The name of the database for which execution statistics are being monitored.

Application

The name of the application for which execution statistics are being monitored.

CPU Time since Logon (ms)

The CPU time (in milliseconds) used by the session since the user logon.

Wait Time (ms) Since Logon

The wait time (in milliseconds) since the logon.

Logical Reads Since Logon

The number of buffers read from cache since the logon.

Physical Reads Since Logon

The number of buffers read from disk since the logon.

Physical Writes Since Logon

The number of buffers written to disk since the logon.

Current SQL

The SQL statement currently being executed by this session.

Command

The command code for the last SQL statement executed by this session.

Table Pages Accessed Since Logon

The number of table pages accessed since the logon.

Index Pages Accessed Since Logon

The number of index pages accessed since the logon.

Locks Currently Held

The number of locks the process currently holds.

TempDB pages Currently Used

The number of temporary database pages the process is currently using.

Commits Since Logon

The number of database commits since the logon.

Rollbacks Since Logon

The number of database rollbacks since the logon.

Engine

The number of the engine on which the process is running.

Top SQL of Session with SPID Table

The Top SQL of Session with SPID (session process identifier) table has the same columns as the Top SQL tab, Top SQL Table.

This table provides detail for the top SQL session selected in the Top Sessions Table.

Wait Events of SPID xx for Period Table

This table provides detail for SPID xx for the time period. The SPID number is selected in the Top Sessions Table.

 
Table 23. Wait Events of SPID Description
Name
Description

Event ID

The event identifier number.

Event Description

The description of the SAP ASE wait event.

Wait Time (ms)

The wait time for this event in milliseconds.

SQL Details Tab

SQL Details Tab

The SQL statement details are provided in a table.

You can display the SQL details for specified SQL text using the Filter on SQL Text box and clicking Apply. You can view the full list by clicking Show All.

Figure 19. SQL Details Tab

SQL Details Table
 
Table 24. SQL Details Table Description
Name
Description

End Time

The time that the SQL statement finished running, in the format:

•
Month, Day, Year
•
Hour, Minute, am/pm.

Database

The name of the database that this SQL statement used during its execution.

SQL Text

The SQL statement that was run.

SPID

The ID of the session process that executed the SQL statement.

Execution Duration (ms)

The time it took to execute the SQL statement, in milliseconds.

CPU Time (ms)

The time it took the CPU to execute the SQL statement, in milliseconds.

Wait Time (ms)

The number of milliseconds a task has waited during execution of the SQL statement.

Physical Reads

The number of buffers read from disk.

Logical Reads

The number of buffers read from cache.

Pages Modified

The number of pages modified by the SQL statement.

Memory Used (KB)

The amount of memory (in kilobytes) allocated to the SQL script.

Packets Sent

The number of network packets sent by the Adaptive Server.

Packets Received

The number of packets received by the Adaptive Server.

Blocked Tree Tab

Blocked Tree Tab

The Blocked tree tab shows the:

•
Current blocked process situation.
•
Blocked processes that occurred in the Time Range.
•
Currently blocked processes marked by lock.

The blocked tree information is provided in the Blocked Tree Table. You can select the time for the metrics displayed:

•
Show Last Sample; shows only the current blocks.
•
Show All Time Range.
Figure 20. Blocked Tree Tab

Blocked Tree Table

 

Table 25. Blocked Tree Table Description
Name
Description

SPID

The session process identifier.

A lock icon appears when there is an active current block.

kpid

The kernel process identifier.

Login Name

The login name of the blocked user.

Database Name

The name of the database being used by the current process.

Application

The application name of the current process.

Locked Table

The name of the table holding the locked object that causes the block.

SQL Text

The SQL (Structured Query Language) statement.

Time Blocked (hh:mm:ss)

The amount of time (in hours:minutes:seconds) the process has been blocked.

Status

The status of the blocked process.

Last Sample Time

The time at which the last sample block occurred, and was subsequently cleared.

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen