Foglight for Sybase 5.7.5.40 - User and Reference Guide

Setting Connection Details

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:

1	Enter the Sybase login in the Login Name box.

NOTE: The above user account must be configured to include the permissions for installing and executing stored procedures, as well as read permissions on system tables (including master and user databases). The required stored procedures must be installed manually by an account with appropriate privileges before the Sybase_MDA Agent can start monitoring the Sybase Adaptive Server. This can either be the Sybase sa account, or another account that has the appropriate permissions, configured using the rapsinstall2.sql script. For complete instructions, see “Configuring Sybase Login Privileges” on page 75.

2	Enter the password associated with the Login Name to access the Sybase database, in the Login Password box.

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.

4	Enter the name of the ASE server to be monitored in the Server Name ($DSQUERY) box.

5	Enter the alternate name of the backup server, if one has been defined, in the Backup Server Alias box.

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

The default is SYB_BACKUP.

6	Enter the number of times you want Foglight to attempt to connect to Sybase in the Maximum Connection Retries box.

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.

7	Enter the number of seconds allowed for an individual connection attempt in the Connection Timeout (seconds) box.

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

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:

1	Enter the name of the Sybase server host machine in the Sybase Server Host box.

2	Enter the port number used by the Sybase server host machine in the Sybase Server Port box.

IMPORTANT: Ensure that the configured port is open between the Foglight Management Server and the Sybase Server.

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

Setting Data Management Properties

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.

6	Add an entry to the list by clicking Add Row.

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.

15	Add an entry to the list by clicking Add Row.

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.

21	Add an entry to the list by clicking Add Row.

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.

27	Add an entry to the list by clicking Add Row.

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

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.

2	To change the sample frequency for the collection of table space data, edit the collection rate in the Table Space Poll Cycle (minutes) box.

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.

5	Add an entry to the list by clicking Add Row.

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.