How can additional CPU resource tracking be activated?
How can additional CPU resource tracking be activated?
Answered
Next Story
Related
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... - 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... - CPU consumption of SAP HANA hosts optimization
Hello Experts,May I know that how can the CPU consumption of SAP HANA hosts be optimized?Kindly share your views, Thanks in advance.
Forums
Books
Jobs
-
SAP TRAINERS | 2-10 yrs | Hyderbad | Nidhi Technology
Exp :2 - 10 years | City : Hyderabad -
HANA Application Developer | 5 - 7 yrs | Bangalore | Shell I
Exp :5 - 7 years | City : Bangalore -
SAP Basis Consultant | 6 - 8 yrs | Bangalore | Sony India
Exp :6 - 8 years | City : Bangalore -
Business Processes Associate | 3 - 6 yrs | Bangalore |SAP In
Exp :3 - 6 years | City : Bangalore -
SAP S4 HANA Implementation Opportunity!!!
Exp :4 - 30 years | City : Chennai
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.