Foglight for Sybase 5.7.5.40 - User and Reference Guide

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 Sybase 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 Sybase 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.