Foglight for Sybase 6.0.0 - User and Reference Guide

Workload Summary Extended Report

The Workload Summary Extended report provides detailed information about all major aspects of your monitored environment. It contains the following sections:

•

Instance Information shows the information about the selected database server, such as its health, user connections, engine, cache, databases running, and others.

•

Last Alarms lists the alarms generated against the monitored system, and for each alarm, shows the time it was created, its duration, source name, and the alarm message.

•

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.

•

System Wait Classes shows in graph form the amount of time spent on various system processes, such as system events, disk writes, and others, for the system wait classes, during a selected time period.

•

System Wait Events

•

Engine Activity Summary indicates the number of SAP ASE 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.

•

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

•

Engine and Processes Summary contains several graphs, showing the average percentage of busy engine I/O and CPU times, and the counts of active and blocked processes, 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.

•

Cache Activity Summary shows the number of named data caches, their total size, the size of the procedure cache size, the maximum available memory, the available physical memory, and the data and procedure cache hit rates.

•

Cache Graphs Summary contains graphs that indicate the data cache hit rate average, hits, misses and dirty buffers, as well as the procedure cache hit rate average, requests, loads, and writes.

•

Data Cache Details show the metrics for each named cache, such as the size in MB, average hit rate, and others.

•

Data Pools Details show the various metrics for each named cache, such as the I/O size, pool size, and others.

•

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.

•

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

•

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.