[HANA] Parameter - expensive statement 관련

Expensive statement로 저장되는 기준

Indicator	Validity	Parameter	Unit	Details
Runtime	general	threshold_duration	us	SQL statements exceeding the configured runtime limit are recorded.
CPU consumption	Rev. >= 94	threshold_cpu_time		SQL statements exceeding the configured CPU consumption are recorded. As a prerequisite CPU time measurement must be activated on SAP HANA <= 1.0 SPS 11 with the following parameter (see SAP Note 2100040): Starting with SAP HANA 1.0 SPS 12 CPU time measurement is activated per default. Attention: Setting threshold_cpu_time doesn't work properly on SAP HANA <= 1.0 SPS 11 and a high number of SQL statements will be traced, regardless of the defined limitation. So it should only be used with SAP HANA >= 1.0 SPS 12.
Memory consumption	Rev. >= 94	threshold_memory	byte	SQL statements exceeding the configured memory consumption are recorded. As a prerequisite memory tracking must be activated with the following parameters (see SAP Note 1999997): global.ini -> [resource_tracking] -> enable_tracking global.ini -> [resource_tracking] -> memory_tracking

• 여러개가 정의된 경우 논리적으로 OR로 수행됨

 

 

Expensive statement trace를 관리하는 parameter

Parameter global.ini -> [expensive_statement] ->	Default	Unit	Details
application			Possibility to restrict trace to specific application name
application_user			Possibility to restrict trace to specific application user name
enable	false		Main switch, 'true' activates the expensive statements trace
in_memory_tracing_records	30000	records	Maximum number of trace records (per service) stored in memory
maxfiles	10	files	Maximum number of trace files Attention: Changes may not be considered with SAP HANA <= 1.00.122.16 and <= 2.00.024 (SAP Note 2608324)
maxfilesize	1000000	bytes	Maximum file size in byte (default: 1 MB) Attention: Changes may not be considered with SAP HANA <= 1.00.122.16 and <= 2.00.024 (SAP Note 2608324)
object			Possibility to restrict trace to specific objects (tables, views, procedures)
passport_tracelevel			Possibility to restrict trace to specific passport tracelevels (medium, high)
threshold_cpu_time		us	Threshold for minimum CPU utilization (Rev. >= 94)
threshold_duration	1000000	us	Threshold for minimum SQL statement duration (default: 1 s)
threshold_memory		byte	Threshold for minimum SQL memory allocation (Rev. >= 94)
trace_flush_interval	10	records	Interval for writing trace data from memory buffer to trace files on disk (Rev. >= 100)
trace_parameter_values	true		Possibility to trace bind values
use_in_memory_tracing	true		Possibility to use memory caching true -> cache information in memory false -> write data into files directly
user			Possibility to restrict trace to specific database user name