Foglight for Sybase 5.7.5.40 - User and Reference Guide

Engine Activity Report

Engine Activity Report

The Engine Activity report shows performance details for Sybase engine operations. It contains the following sections:

•

Engine Activity Summary indicates the number of Sybase engines and connections. It also shows in graph form the average percentage of times the engine, engine I/O and engine CPU were busy over a selected time range. The Total Busy Percent and CPU and I/O busy percentages show the hit rate averages for the selected time period, along with the related severity level. Different-colored vertical lines in the graphs indicate threshold levels.

•	Schedule (CPU) Waits Summary shows in graph form the schedule (CPU) waits and a table that lists all the related events that occur during the selected time range.

•	Engines Details lists all Sybase engines and shows the average percentage of times each engine was busy, including I/O and CPU busy times, among other metrics.

•

Metrics Statistics Summary shows the a table listing the metrics related to the engine activity. For each metric, the table shows their previous and current values, the baseline minimum and maximum values, and the deviation of the current value from the baseline. The current values appear in bold text for better visibility. Metric groups appear in alternate text color for the same reason.

NOTE: Shorter data sampling period can cause some values to be zero. This is because the retention policy process can clean the data. With periods longer than 30 minutes this is not the case.

•	Metrics Statistics Summary lists various metrics, grouped into several collections, such as Engines, Processes, SQLs. For each metric, it gives its average values, the expected range, and the deviation (if applicable).

•	Engine and Processes Summary contains several graphs with engine and process summary information along with the metric baseline.

I/O and Network Activity Report

I/O and Network Activity Report

The I/O and Network Activity report shows network activity details as well as various device I/O metrics. It contains the following sections:

•	I/O Activity Summary shows the numbers of I/O devices and database, and various I/O read and write rates. It also lists various metrics, grouped into several collections, such as I/O and Pages. For each metric, it gives its average values, the expected range, and the deviation (if applicable).

•

I/O Waits Summary shows in graph form the amount of time spent on disk write and read waits over a selected time range. It also lists class-related events and shows wait-related metrics for each event. There are two wait classes that appear in this section: Disk Read Wait with the class ID of 2, and Disk Write Wait, with the class ID of 3.

•	Device I/O Summary shows in graph form the rate of device reads, writes, and Asynchronous Prefetch Activity (APF) reads, and then the same information in comparison with the expected baseline.

•	Metrics Statistics Summary lists various metrics, grouped into several collections, such as Caches, Disk I/O, Network. For each metric, it gives its average values, the expected range, and the deviation (if applicable).

•	Device I/O Details lists all I/O devices, and for each device it shows its logical name, physical name, total I/O amount, the counts and averages of the device writes, reads, and APF reads, and other metrics.

•	Temporary Database Spaces Usage shows the space usage for temporary databases, including the total amount of database space, and the available space. The same information appears in graph form, for a given time range.

•	Network Activity Summary shows the average numbers of bytes received and sent per data packet, and their rate. The rates also appear in graph form for a selected time range.

•	Network Waits Summary shows in graph form the amount of time spent on network input and output waits over a selected time range. It also lists class-related events and shows wait-related metrics for each event.

•	Network I/O Details lists various metrics, grouped into several collections, such as Packets Received and Packets Sent. For each metric, it gives its average values, the expected range, and the deviation (if applicable).

Locks Activity Report

Locks Activity Report

The Lock Activity report shows lock activity details as well as various lock metrics. It contains the following sections:

•	Locks Waits Summary shows lock wait statistics. It contains two graph views that display the amount of time spent on lock waits and average lock waits per connection during a given time range. It also lists class-related events and shows wait-related metrics for each event.

•	Locks Summary shows the average counts of blocks and deadlocks, and also the average wait times, all over a selected time range.

•	Locks Details lists various metrics, grouped into several collections, such as Connections, Locks (Max), Locks (Average), Locks (Total), and Deadlocks. For each metric, it gives its average values.

•	Blocked Tree lists information on blocked trees, for each entry, shows the SPID. login name, database name, application, locked table, SQL text, and other metrics.

Top SQL Top Procedure Report

Top SQL Top Procedure Report

The Top SQL Top Activity report provides detailed information about the SQL activities that utilized the highest amount of processing time or the highest amount of wait time over a given time range. It contains the following sections:

•

Important Metrics Statistics Summary lists various metrics, grouped into several collections, such as Engines, Processes, SQLs. For each metric, it gives its value before the change and after the change, along with the baseline value for the period after the change. It can help understand the impact of one metric change on another. For example, a dramatic decrease in cache misses can be caused by an increased use of APF reads.

•	Locks Details lists various metrics, grouped into several collections, such as Connections, Locks (Max), Locks (Average), Locks (Total), and Deadlocks. For each metric, it gives its average values.

•	Top SQL provides detailed information about the SQL statements that experienced the longest duration or highest number of total wait events during the specified time range. The Top SQL information is sorted by the Avg Duration (ms) column.

•	Top Procedure provides detailed information about the specific SQL procedure that experienced the longest duration or highest number of total wait events during the specified time range. The Top Procedure information is sorted by the Avg Duration (ms) column.

This report template provides the Max Rows input parameter, which allows you to specify the number of rows to be shown in each SQL table.