-
Title
SAP HANA agent properties -
Description
System Database Connection
The agent requires a connection to the SYSTEMDB database to gather many system properties and metrics.
- IP or Hostname – Host on which the SAP HANA system node is running.
- Port – The SQL port for the system database.
- Username – The system database username.
- Password – The system database user’s password.
- Use Compression? – Whether the database connection should be compressed.
Landscape
A name for the landscape containing the SAP HANA System may be arbitrarily chosen for the Landscape property. It is used exclusively to differentiate two or more SAP HANA Systems with the same SID.
Tenant Database Connections
The same connection properties required for the system database are mandatory for every monitored tenant (though monitoring any individual tenant is optional). See above for definitions of IP or Hostname, Port, Username, Password, and Use Compression.
Collection Periods
The collection period fields in the agent properties set the sample frequencies and are in seconds. Any collection can be turned off by setting its period to zero. The default collection periods vary based on the type and volatility of data collected.
- Availability – Controls the query interval for the SAP HANA system and database availability collections.
- Databases and Tables – Controls the query interval for collection of data pertaining to databases present on the system and table memory and persistence metrics.
- Services, Volumes, and Load – Controls the query interval for collection of the service, volume, and host load metrics.
- Query Plans – Controls the query interval for collection of the SQL query plans and expensive statements. Note that resource tracking must be enabled in the SAP HANA system for expensive statement data to be available.
- Transactions – Controls the query interval for blocked transaction monitoring.
- Alerts – Controls the query interval for native alert collection.
- Configuration – Controls the query interval for system configuration tracking.
SQL Options
Max SQL Plans Per Period – The maximum number of SQL plans to retrieve per collection period.
Select Top SQL By – The metric used to determine which SQL plans are collected in the usual case when the SQL plan cache contains more plans than can be collected based on “Max SQL Plans Per Period”.
Max Expensive Statements Per Period – The maximum number of expensive statements to retrieve per collection period. Expensive Statement tracking is only possible if Resource Tracking has been configured in SAP HANA.
Expensive Statement Threshold Duration – The minimum duration of an expensive statement to qualify for retrieval. Note that only “Max Expensive Statements Per Period” expensive statements will be retrieved per period, regardless. Hence it is possible that additional expensive statements above this duration exist but are not collected by Foglight.
-
Resolution
System Database Connection
The agent requires a connection to the SYSTEMDB database to gather many system properties and metrics.
- IP or Hostname – Host on which the SAP HANA system node is running.
- Port – The SQL port for the system database.
- Username – The system database username.
- Password – The system database user’s password.
- Use Compression? – Whether the database connection should be compressed.
Tenant Database Connections
The same connection properties required for the system database are mandatory for every monitored tenant (though monitoring any individual tenant is optional). See above for definitions of IP or Hostname, Port, Username, Password, and Use Compression.
Collection Periods
The collection period fields in the agent properties set the sample frequencies and are in seconds. Any collection can be turned off by setting its period to zero. The default collection periods vary based on the type and volatility of data collected.
- Availability – Controls the query interval for the SAP HANA system and database availability collections.
- Databases and Tables – Controls the query interval for collection of data pertaining to databases present on the system and table memory and persistence metrics.
- Services, Volumes, and Load – Controls the query interval for collection of the service, volume, and host load metrics.
- Query Plans – Controls the query interval for collection of the SQL query plans and expensive statements. Note that resource tracking must be enabled in the SAP HANA system for expensive statement data to be available.
- Transactions – Controls the query interval for blocked transaction monitoring.
- Alerts – Controls the query interval for native alert collection.
- Configuration – Controls the query interval for system configuration tracking.
SQL Options
Max SQL Plans Per Period – The maximum number of SQL plans to retrieve per collection period.
Select Top SQL By – The metric used to determine which SQL plans are collected in the usual case when the SQL plan cache contains more plans than can be collected based on “Max SQL Plans Per Period”.
Max Expensive Statements Per Period – The maximum number of expensive statements to retrieve per collection period. Expensive Statement tracking is only possible if Resource Tracking has been configured in SAP HANA.
Expensive Statement Threshold Duration – The minimum duration of an expensive statement to qualify for retrieval. Note that only “Max Expensive Statements Per Period” expensive statements will be retrieved per period, regardless. Hence it is possible that additional expensive statements above this duration exist but are not collected by Foglight.