How can additional CPU resource tracking be activated?
How can additional CPU resource tracking be activated?
Answered
Next Story
HANA Alert 5 'Host CPU Usage'
How to handle "Host CPU Usage"?How to determine that the HANA system has become unresponsive?When in the Alerts tab, the alert “suse-hanajl01 runs out of CPU resources! CPU...- Oracle Service Consuming Lot of CPU Resource
System Config : OS : Win 2000 A.S Oracle 11.5.8 Rdbms : 8.1.7 Usaully my Oracle use to work very good but some times once in a blue moon , when I restarted my Database after performing a... - SAP HANA Resource Container
What is the SAP HANA Resource Container?The SAP HANA resource container is composed of the row store and heap allocators along with the information which can be re-used such as:tSAP HANA page cache... - Processes that Used Too Much CPU Resources
- Use 'top' command to find which processes (PID) eat much CPUs. - Join v$process & v$session & v$sqlarea to know what happens in. Check alert log for any error messages/trace file generated...
Get solutions from our experts!
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:
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.