Chat now with support
Chat with Support

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

Setting Connection Details

Use the Connection Details agent set of properties in the Sybase_MDA Agent to designate the type of connection properties to use.

1
3
Enter the full path to the SAP ASE directory in the Sybase Home ($SYBASE) box. Ensure that this path contains the Sybase ‘interfaces’ file.
NOTE: The directory path should look similar to /apps/Sybase. Notice that the path does not contain a trailing slash.
8
Click Save.
9
Go to Setting Callback Connection Properties to enable the appearance of stored procedure details on the Top Procedures Tab.

Setting Callback Connection Properties

Use the callback connection properties in the Sybase_MDA Agent to enable the appearance of stored procedure details, such as the stored procedure text and its execution statistics, on the Top Procedures Tab.

3
Go to Setting Data Management Properties to set sample frequency agent properties.

Setting Data Management Properties

Use the Data Management set of agent properties to set the sample frequency.

1
Ignore the Purge Data After box. This field is not functional.
2
Select the Availability Data option, True or False, to turn the data filtering on or off. When this field is set to true, the agent monitors the Availability group.
3
Enter the collection rate in the Availability Poll Cycle (seconds) box if you want to change the collection rate for the group.
4
Click the list from the Availability Monitoring list that you want to update.
5
Click Edit.
7
Click Save Changes.
8
Click the list from the Performance Monitoring list that you want to update.
9
Click Edit.
10
Click Add Row to add an entry to the list.
a
In the Table Name column, type the table name.
b
Select or clear the check box in the Collect column to enable or disable the data collection for this table. By default, this check box is selected.
c
In the Poll Cycle (sec) column, type the length of the poll interval for the table in seconds. This interval represents the number of seconds between the end of one collection period and the start of the next.
IMPORTANT: The StatementCache-Future-Use and TableActivity-Future-Use tables are for future use only. Do not make any changes to these values.
d
Click Save Changes.
11
Select the Configuration option, True or False, to activate the table collection for the Configuration group.
12
Enter the collection rate in the Configuration Poll Cycle (hours) box if you want to change the collection rate for the group.
13
Click the list from the Configuration Monitoring list that you want to update.
14
Click Edit.
16
Click Save Changes.
17
Select the Space Trending option, True or False, to activate the table collection for the Space Trending group.
18
Enter the collection rate in the Trending Poll Cycle (hours) box if you want to change the collection rate for the group.
19
Click the list from the Space Trending List that you want to update.
20
Click Edit.
22
Click Save Changes.
23
Select the Top SQL option, True or False, to activate the table collection for the Top SQL group.
24
Enter the collection rate in the Top SQL Poll Cycle (seconds) box if you want to change the collection rate for the group.
25
Select the list from the Top SQL Monitoring list that you want to update.
26
Click Edit.
28
Click Save Changes.
29
Click Save.
30
Go to Setting Table Space Management Properties to set the table space properties.

Setting Table Space Management Properties

Use the Table Space Management set of agent properties to set the sample frequency for table spaces, enable the data collection for a database, the minimum table size to retrieve, the number of tables to retrieve, and the total number of tables, indices, and partitions for per agent instance.

1
Select the Table Space option, True or False, to turn the collection of table space data on or off. When this field is set to True, the agent collects the table space metrics. The default value is True.
3
Click the list from the Table Space Monitoring list that you want to update.
The default list is TableSpace_Dflt.
4
Click Edit.
Database Name: The name of the database.
Threshold MB: The minimum table size to retrieve. The default is 1 MB.
Number Of Top Tables: The number of tables to monitor. The default is 10.
6
Click Save Changes and close the dialog box.
7
Edit the total number of tables, indices, and partitions in the Total Number Of Tables, Indexes and Partitions box.
8
Click Save.
9
Go to Setting Data Retrieval Properties to set sample frequency agent properties.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating