Chat now with support
Chat with Support

Foglight for Sybase 7.1.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

Setting Data Retrieval Properties

Use the Data Retrieval set of agent properties to set the limit for the amount of data collected and written to the Foglight database.

The Top Procedures set of agent properties affect the information that appears on the Top Procedures dashboard. For more information, see Top Procedures Tab .

The Top Users set of agent properties affect the information that appears on the Top Users dashboard. For more information, see Top Users Tab .

The Cached Objects set of agent properties affect the information that appears on the Data Cache Activity dashboard. For more information, see Data Cache Activity Tab .

1
Click the list from the Limit Incoming Rows List that you want to update.
The default name is LIR_List_Dflt. This list can be renamed to better describe the changes made.
2
Click Edit.
4
Click Save Changes.
5
Enter the maximum number of top applications to monitor in the Top Applications - Max Rows Returned box.
7
Select a sorting criteria from the Top Applications - Sort Criteria list. For more information, see Minimum Threshold Value Sorting Criteria .
There is room on the list based on the Top Applications - Max Rows Returned value specified in Step 5.
10
Select a sorting criteria from the Top SQL - Sort Criteria list. For more information, see Minimum Threshold Value Sorting Criteria .
There is room on the list based on Top SQL - Max Rows Returned value specified in Step 8.
11
Select Top SQL - Include Stored Procedure Lines - YES to display the list of stored procedures. Select NO if the stored procedures list is not to be displayed. Enabling this property allows you to collect the SQL statements inside stored procedures. The number of collected SQL statements depends on the values set by the Top SQL - Max Rows Returned property (see Step 8). It also requires a certain configuration of ASE parameters: the parameter statement pipe max messages should be greater than sql text pipe max messages. For more information about these parameters, refer to your SAP ASE documentation.
12
14
Select a sorting criteria from the Top Users - Sort Criteria list. For more information, see Minimum Threshold Value Sorting Criteria .
There is room on the list based on the Top Users - Max Rows Returned value specified in step 10.
15
17
Select a sorting criteria from the Cached Objects - Sort Criteria list. For more information, see Minimum Threshold Value Sorting Criteria .
18
Select the Cached Objects - Object Type from the list. The types are:
All tables
19
Click Save.
20
Go to Setting Benchmark Properties to set sample frequency agent properties.

The Limit Incoming Rows List table displays a set of criteria which limits the amount of data written to the Foglight database.

Blocked Users

Max rows returned

20

Blocked Users

Minimum time blocked (seconds)

30

Databases

Max rows returned

20

Databases

Minimum Database space percentage threshold

80%

Databases

Minimum Transaction Log space percentage threshold

80%

Databases

Minimum Segment space percentage threshold

80%

Disk I/O

Max rows returned

20

Disk I/O

Minimum percentage of waits over requests

1%

Error Log

Max rows returned

10

Named Caches

Max rows returned

10

Named Caches

Maximum Cache Hit Rate threshold

80

Engines

Max rows returned

10

Engines

Minimum CPU busy percentage threshold

80%

Long Running Transaction

Max rows returned

10

Long Running Transaction

Length of a long running transaction

-1

OS Processes

Max rows returned

10

OS Processes

Minimum OS Process CPU Busy threshold

80

System Waits

Minimum wait event threshold

80

The Minimum Threshold Value list displays a set of criteria used to specify a quantity which orders the list of:

CPU Time (seconds)

The CPU time (in seconds) used by the application. This maps to the cpu_time field in the TopApplications Table.

Logical Reads

The number of buffers read from cache. This maps to the logical_reads field in the TopSQL Table and TopUsers Table.

Memory Usage (kB)

The amount of memory (in kilobytes) allocated to the application. This maps to the mem_usage_kb field in the TopApplication Table.

Physical Reads

The number of buffers read from disk. This maps to the physical_reads field in the TopApplication Table.

Physical Writes

The number of buffers written to disk. This maps to the physical_writes field in the TopUsers Table.

CPU Time (seconds)

The number of seconds (ms) of CPU time used by the SQL statement. This maps to the cpu_time field in the TopSQL Table.

Duration

The amount of time the SQL statement took to run in seconds. This maps to the duration field in the TopSQL Table.

Logical Reads

The number of buffers read from cache. This maps to the logical_reads field in the TopSQL Table and TopUsers Table.

Memory Usage (kB)

The amount of memory (in kilobytes) used for SQL statement execution. This maps to the mem_usage_kb field in the TopSQL Table.

Packets Received

The number of packets received by Adaptive Server. This maps to the packets_received field in the TopSQL Table.

Packets Sent

The number of network packets sent by Adaptive Server. This maps to the packets_sent field in the TopSQL table.

Physical Reads

The number of buffers read from disk. This maps to the physical_reads field in the TopSQL and TopUsers table.

Physical Writes

The number of buffers written to disk. This maps to the physical_writes field in the TopSQL table.

CPU Time (seconds)

The CPU time (in seconds) used by the process. This maps to the cpu_time field in the TopUsers table.

Locks

The number of locks the process currently holds. This maps to the locks_held field in the TopUsers table.

Logical Reads

The number of buffers read from cache. This maps to the logical_reads field in the TopSQL and TopUsers table.

Memory Usage (kB)

The amount of memory used by the top users in kilobytes.

Physical Reads

The number of buffers read from disk. This maps to the physical_reads field in the TopSQL and TopUsers table.

Physical Writes

The number of buffers written to disk. This maps to the physical_writes field in the TopUsers table.

Transactions

The number of transactions being processed by the top users.

Cached (kB)

The amount of memory used by the cached objects in kilobytes.

Processes Accessing

The number of processes accessing the cached objects.

Setting Benchmark Properties

Use the Benchmark set of agent properties to configure BenchMarkTimes table collection parameters.

1
Click the Read Benchmark SQL from a File radio button, True or False, to enable or disable this function.
2
Specify the SQL Benchmark in the Benchmark SQL or Path box. Either:
NOTE: Do NOT select true for the Read Benchmark SQL from a File property if you enter the SQL statement directly.
4
Click Save.
5
Go to Setting Configuration Properties to set sample frequency agent properties.

Setting Configuration Properties

Use the Configuration set of agent properties to set the log collection configuration properties.

The configuration properties allow you to define the logs that the Sybase_MDA Agent monitors. Additionally, it allows you to define the messages within the logs that the Sybase_MDA agent traps.

3
Click the list from the Message Trap List that you want to update.
4
Click Edit.
a
Search PatternIndicates the regular expression pattern used to match the log message.
b
ActionWhen set to Include, any error messages that match the search pattern are printed to the log. When set to Exclude, the matched messages are excluded from the log.
c
SeverityThe severity of the alarm that is triggered by any error messages that match the search pattern.
6
Click Save Changes.
7
Select whether or not databases are to be included or excluded from the Use (Include DBs or Exclude DBs or None) list. Click one of the following:
None to indicate that neither of the Exclude DBs or Include DBs lists is to be used. Every database is treated according to standard behavior for the Limit Incoming Rows agent property. For more information, see Setting Data Retrieval Properties .
The default is none.
Select Exclude DBs to monitor most databases and exclude a few databases.
Select Include DBs to exclude most databases and monitor a few databases.
In the Include DBs field, change the name of the of the agent property list from DB_Include_List_Dflt to SYBM_DBInclusion_<Modified Agent Instance Name>.
For inclusion, <Modified Agent Instance Name> is a placeholder for the agent instance name as Foglight understands it. The Modified Agent Instance Name usually looks like Sybase_MDA@dbhost1.
The '@' in the instance name is converted to a '_', so the modified name looks like Sybase_MDA_dbhost1 and the full list name looks like SYBM_DBInclusion_Sybase_MDA_dbhost1 for the inclusion list.
CAUTION: The agent pre-populates the inclusion list. The Add and Delete buttons should not be used.
8
Click the exclusion database list from the Exclude DBs list that you want to update.
9
Click Edit.
a
For the Status Alerting, Database Space Alerting, Transaction Log Alerting, or Space Trend lists, the options are:
StandardFoglight returns a row for this database only when it crosses the threshold. A row for the respective database may not be returned when it crosses a threshold if the number of databases crossing the threshold exceeds the “max rows returned” value during that poll cycle.
Always IncludeFoglight always returns a row for this database when it crosses the threshold. The row for the respective database is always returned, even when the number of databases crossing the threshold exceeds the “max rows returned” value of that poll cycle.
ExcludeFoglight does not return a row for this database even if the threshold is crossed.
b
In the Space Trend list, the options are:
ExcludeFoglight does not return a row for this database even if the threshold is crossed.
IncludeFoglight returns a row for this database.
c
Click True or False on the Disable All radio button to enable or disable this function. Set this value to true to exclude this database from Status Alerting, Database Alerting, Transaction Log, Alerting and Space Trend Alerting.
11
Click Save Changes.
12
Click the inclusion database list from the Include DBs list that you want to update.
This criteria is only applied if Include DBs is selected in the Use (Include DBs or Exclude DBs or None) property.
IMPORTANT: The agent pre-populates the inclusion and exclusion lists. The Add and Delete buttons should not be used.
13
Click Edit.
a
For the Status Alerting, Database Space Alerting, or Transaction Log Alerting lists, the options are:
StandardFoglight returns a row for this database only when it crosses the threshold. A row for the respective database may not be returned when it crosses a threshold if the number of databases crossing the threshold exceeds the “max rows returned” value during that poll cycle.
Always IncludeFoglight always returns a row for this database when it crosses the threshold. The row for the respective database is always returned, even when the number of databases crossing the threshold exceeds the “max rows returned” value of that poll cycle.
ExcludeFoglight does not return a row for this database even if the threshold is crossed.
b
In the Space Trend list, the options are:
ExcludeFoglight does not return a row for this database even if the threshold is crossed.
IncludeFoglight returns a row for this database.
c
Click True or False on the Disable All radio button to enable or disable this function. Set this value to true to exclude the database from Status Alerting, Database Alerting, Transaction Log, Alerting and Space Trend Alerting.
15
Click Save Changes.
16
Click Save.

Sybase_MDA Investigations

This section describes the following investigations:

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating