Chatta subito con l'assistenza
Chat con il supporto

Foglight for Sybase 5.7.5.40 - User and Reference Guide

Using Foglight for Sybase
Exploring the Sybase Dashboards About the Sybase_MDA Agent About the Sybase_RS Agent Generating SybaseMDA Reports
Reference About us

Setting Connection Details

Previous Next



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.

To set up the Connection properties:
3
Enter the full path to the Sybase 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.

To retrieve a list of available servers, run the stored procedure sp_helpserver.

The default is SYB_BACKUP.

This is the maximum number of retries the Sybase_MDA Agent attempts when it encounters an error with the Adaptive Server before the agent stops.

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

Previous Next



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.

To set up the callback connection properties:
3
Go to Setting Data Management Properties to set sample frequency agent properties.

Setting Data Management Properties

Previous Next



Setting Data Management Properties

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

To set the data management properties:
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.

The default value is true.

3
Enter the collection rate in the Availability Poll Cycle (seconds) box if you want to change the collection rate for the group.

The collection rate, or sample frequency, is the number of seconds between the end of a collection period and the start of the next.

The default is 60 seconds.

4
Click the list from the Availability Monitoring list that you want to update.

This agent property list allows the activation or deactivation of individual tables for collection.

The default secondary list name is AvailMon_Dflt.

5
Click Edit.

A secondary property list appears.

Fill in the dialog box fields.

7
Click Save Changes.
8
Click the list from the Performance Monitoring list that you want to update.

This agent property list includes performance monitoring properties that enable or disable both the collection of performance data and the length of the polling interval per-table.

The default secondary list name is PerfMon_Dflt.

9
Click Edit.

A secondary property list appears, listing all performance tables.

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.

The default value is false; collection deactivated.

12
Enter the collection rate in the Configuration Poll Cycle (hours) box if you want to change the collection rate for the group.

The collection rate, or sample frequency, is the number of hours between the end of a collection period and the start of the next.

The default is 24 hours.

13
Click the list from the Configuration Monitoring list that you want to update.

This agent property list allows the activation or deactivation of individual tables for collection.

The default secondary list name is ConfMon_Dflt.

14
Click Edit.

A secondary property list appears.

Fill in the dialog box fields.

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.

The collection rate, or sample frequency, is the number of hours between the end of a collection period and the start of the next.

The default is 24 hours.

19
Click the list from the Space Trending List that you want to update.

This agent property list allows the activation or deactivation of individual tables for collection.

The default secondary list name is SPTR_Dflt.

20
Click Edit.

A secondary property list appears.

Fill in the dialog box fields.

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.

The collection rate, or sample frequency, is the number of hours between the end of a collection period and the start of the next.

The default is 300 seconds.

25
Select the list from the Top SQL Monitoring list that you want to update.

This agent property list allows the activation or deactivation of individual tables for collection.

The default secondary list name is TopSQL_Dflt.

26
Click Edit.

A secondary property list appears.

Fill in the dialog box fields.

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

Previous Next



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.

To set the table space management properties:
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.

The collection rate, or sample frequency, is the number of minutes between the end of a collection period and the start of the next. The default is five minutes.

3
Click the list from the Table Space Monitoring list that you want to update.

This list property enables the data collection for a database. When you add a database to this list, the database metrics appear on the Table Spaces Tab and Table Performance Tab of the Database Spaces and Trends Dashboard.

The default list is TableSpace_Dflt.

4
Click Edit.

A dialog box appears, showing a list of secondary properties.

Specify the following values in the row that appears:

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.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione