How can additional CPU resource tracking be activated?
Tutorials
- SAP HANA Definition & Full Form
- SAP HANA Scope and Opportunity
- SAP HANA Certification Cost in India
- SAP HANA Salary & Job Profile
- SAP HANA Interview Questions
- SAP HANA vs S/4HANA
- SAP Hana Database Architecture
- SAP HANA In-Memory Database
- SAP HANA Studio Guide
- SAP HANA Studio & Client Download
- SAP HANA Alerts Monitoring
- SAP HANA Modeling Guide
- SAP HANA Modeling Scenarios
- SAP HANA Analytic View
- SAP HANA Calculation View
- SAP HANA Analytic Privilege
- SAP HANA Reporting
- SAP HANA Excel Integration
- SAP HANA Security Overview
- SAP HANA Security FAQs
- SAP HANA Authentication Mechanisms
- SAP HANA License Types
- SAP HANA Audit
- SAP HANA Replication Modes
- SAP HANA Data Provisioning
- SAP HANA DXC
- SAP HANA Persistence layer
- SAP HANA Backup and Recovery
- SAP HANA Backup and Recovery FAQs
- SAP HANA High Availability
- SAP HANA Data Types
- SAP HANA SQL Script
- SAP HANA SQL Operators
- SAP HANA Stored Procedure
- SAP HANA SQL Error Codes
- SAP HANA Azure Architecture
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.