Chat now with support
Chat with Support

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

Table Performance Tab

The Table Performance information is provided in a table.

To enable the data collection for a database and to display this data on the Table Performance tab, the database must be added to the Table Space Monitoring list in the Table Space Management group of the Sybase_MDA Agent properties. For more information, see Setting Table Space Management Properties .

The filters appearing just above the table allow you to look for specific entry based on some known criteria. You can filter on table and/or database name, choose between showing the table and/or indices, show delta values or rates, and indicate if you want to display the data collected in the last collection period, most recent sample, or in the last ten minutes.

The Table Performance drilldown displays a dialog box with detailed information about the selected table.

Table

The table name, its locking schema, and the number of partitions.

Data row count

The number of data rows.

Table Size (MB)

The total table size in MB.

Data Size (MB)

The amount of table space occupied by the data.

Data row size

The data row size.

Forwarded row count

The number of rows forwarded to other pages.

Deleted row count

The number of deleted rows.

Derived statistics

NOTE: This is the same information that can be obtained with the Sybase optdiag utility. For more information about this command, see your SAP ASE documentation.

Logical Reads for Today (value)

The amount of data read from cache, shown over the course of the current day.

Physical I/O for Today (value)

The numbers of physical reads, writes, and APF reads, shown over the course of the current day.

Data Modification for Today (value)

Data modification, including the amounts of inserted, updated, and deleted data, shown over the course of the current day.

Logical Reads for Week Days (value)

The amount of data read from cache, shown over the course of the current week.

Physical I/O for Week Days (value)

The numbers of physical reads, writes, and APF reads, shown over the course of the current week.

Data Modification for Week Days (value)

Data modification, including the amounts of inserted, updated, and deleted data, shown over the course of the current week.

Table Rows Total for Today

The count of table rows, shown over the course of the current day.

Table Size for Today

The table size in MB, shown over the course of the current day.

Data Modification Each 1.5 Hours for Today

Data modification, including the amounts of inserted, updated, and deleted data, shown over the course of the current day.

Table Rows Total for Week Days

The number of table rows, shown over the course of the current week.

Table Size for Week Days

The table size in MB, shown over the course of the current week.

Data Modification Each 1.5 Hours for Week Days

Data modification, including the amounts of inserted, updated, and deleted data, shown over the course of the current week.

This table displays the same layout and data as the Index Usage Drilldown.

This table displays the same layout and data as the Partition-Table Usage Drilldown.

Top I/O Active Tables

Use this dashboard to examine activity of top tables. Tables are displayed based on the sort criteria defined in agent ASP data retrieval. The default order is "Logical Reads". Other criteria possible are:

Top Lock Activity Tables

Use this tab to examine lock activity of top tables. Tables are displayed based on the sort criteria defined in agent ASP data retrieval. The default order is Logical Reads. Other criteria possible are

RS Home Page Dashboard

The Replication Server Home Page provides performance details and indicates problems occurring on a specific Replication Server. The following sub-sections describe the dashboard element metrics:

Drilldown dashboards may be accessed through some of the dashboard element metrics. Clicking Rep Server Activity opens the Replication Server Activity Dashboard.

If no data is being collected by the Sybase_RS agent, the “Not Collecting data” error message appears beside the Sybase agent name. In this case, the dashboard shows the data collected from the last sample time.

Related Documents
Foglight for Sybase - 7.3.0
Release Notes
User and Reference Guide
Showing 1 to 2 of 2 rows

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating