1 |
Enter the SAP ASE login in the Login Username 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 “<Link>Configuring SAP ASE Login Privileges” on page 74. |
2 |
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. |
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. |
6 |
Enter the number of times you want Foglight to attempt to connect to SAP ASE in the Maximum Connection Retries box. |
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. |
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.
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. |
3 |
Go to Setting Data Management Properties to set sample frequency agent 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 |
5 |
Click Edit. |
6 |
Add an entry to the list by clicking Add Row. |
7 |
Click Save Changes. |
8 |
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 |
14 |
Click Edit. |
15 |
Add an entry to the list by clicking Add Row. |
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. |
21 |
Add an entry to the list by clicking Add Row. |
22 |
Click Save Changes. |
23 |
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. |
27 |
Add an entry to the list by clicking Add Row. |
28 |
Click Save Changes. |
29 |
Click Save. |
30 |
Go to Setting Table Space Management Properties to set the table space 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. |
3 |
4 |
Click Edit. |
5 |
Add an entry to the list by clicking Add Row. |
• |
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. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center