Skip to end of metadata
Go to start of metadata

Content

Provides detailed information about the CPU usage of user kernel threads (UKTs) and an overall summary for the instance and the whole host.


Content - Description of the collected values

For each UKT you find one line describing

  • what the UKT is used for, i.e. which tasks are running within that UKT
  • the percentage of CPU usage in user mode
  • the percentage of CPU usage in system mode
  • the current runqueue length, i.e. how many tasks are waiting in a line for being started

The last line per DB-Analyzer snapshot in DBAN.prt provides an overall view for the whole instance and the host. (A value like 464% means that 4.64 CPUs have been used.) 

Example:

===== #112        at 2016-06-27 22:28:00
*  I  CPU utilization of UKT9 (40*US,IDL) in user mode 11.05%, system mode: 0.22%, current runqueue length: 0
* I CPU utilization of UKT12 (65*US,IDL) in user mode 10.28%, system mode: 0.44%, current runqueue length: 0
*  I  CPU utilization of UKT10 (80*US,IDL) in user mode 9.94%, system mode: 0.33%, current runqueue length: 0
*  I  CPU utilization of UKT13 (68*US,IDL) in user mode 13.7%, system mode: 0.22%, current runqueue length: 0
*  I  CPU utilization of UKT11 (57*US,IDL) in user mode 41.55%, system mode: 0.33%, current runqueue length: 0
*  I  CPU utilization of UKT8 (90*US,IDL) in user mode 12.82%, system mode: 0.44%, current runqueue length: 0
*  I  CPU utilization: instance R21: 104.75% (usr: 100.33%, sys: 4.42%), host: 464.09% (usr: 186.52%, sys: 77.79%, wio: 199.78%, idle: 335.03%)

 

Examples of Analyses

  • <Links to BCP tickets>
  • <Links to new pages or WORD documents describing an analysis>

Wie können Bilder von Charts hier eingefügt werden? (Broken image) 

More Information

SAP Note
Helpful with ...
1676903 - SAP MaxDB: Data backup runtime analysisThe note provides detailed information about how to analyze the performance of backups with the help of some DBAN files.
1837280 - SAP MaxDB: CHECK DATA runtime optimizationThe note describes how to analyse and improve the performance of CHECK DATA.  
Expert Session (Link to Trainings)
Content / Helpful with ... 
Session 26 - SAP MaxDB Multi TaskingDescribes general mechanisms how CPUs are used in MaxDB and which parameters define the usage of CPUs.
  
  • No labels