How can additional CPU resource tracking be activated?

Per default SAP HANA doesn't actually measure the individual CPU consumption of threads and SQL statements. You can activate this measurement with the following parameters:

Parameter | Default | Recommendation | Description

## global.ini -> [resource_tracking] -> enable_tracking | off | on | General activation of resource tracking functionality

## global.ini -> [resource_tracking] -> cpu_time_measurement_mode | off | fast (SPS 08 and below)

on (SPS 09 and above) | Activation of CPU specific data collection

Activated CPU tracking will populate the following columns:

• M_SERVICE_THREADS.CPU_TIME_SELF
• M_SERVICE_THREADS.CPU_TIME_CUMULATIVE
• M_EXPENSIVE_STATEMENTS.CPU_TIME

Be aware that the activation of the CPU time measurement can be expensive in terms of system CPU consumption and performance, so you should pay attention for these side-effects and deactivate the time measurement if required.