The agent requires a connection to the SYSTEMDB database to gather many system properties and metrics.
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.
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.
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.
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.
The agent requires a connection to the SYSTEMDB database to gather many system properties and metrics.
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.
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.
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.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center