• Diventare un professionista del portale
• Scaricare
• Stampa
• I miei download ()

• Supporto
• Documentazione tecnica
• Foglight for Sybase 6.1.0.10
• Foglight for Sybase 6.1.0.10 - User and Reference Guide

Foglight for Sybase 6.1.0.10 - User and Reference Guide

Table of Contents  

Using Foglight for Sybase

Exploring the Sybase Dashboards

Accessing the Sybase Dashboards Sybase MDA Global View Dashboard

Sybase 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 Sybase 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 Sybase 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 21 - 24 of 115

×

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.

•  Precedente
• Viewing Topics 21 - 24 of 115
• Successiva 

Cerca in questo documento Cerca in tutti i documenti

×

 Questo è il portale del supporto

Puoi trovare aiuto e supporto online per Quest *prodotto* sul sito di supporto di un affiliato. Fai clic su Continua per essere reindirizzato ai contenuti e all'assistenza corretti per *prodotto*.

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione

© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center