Symptom
The nameserver is configured to be the active SLD data supplier. After starting the database, the nameserver process continuously uses one core even though there is nearly no activity in the system.
Tasks: 156 total, 1 running, 155 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.2%us, 0.3%sy, 0.0%ni, 98.2%id, 0.1%wa, 0.0%hi, 0.2%si, 0.0%st
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1495 hanadm 20 0 8463m 1.7g 612m S 100 2.7 1009:34 hdbnameserver
Using the kernel profiler trace shows that most time is spent in the following functions:
Stack traces created with the command hdbcons -p <nameserver pid> 'context l -ise' would always contain the following calls:
17095[thr=46877]: SldRegistrator at 0x00007fb99649a54f in SLDDataSupplier::NamedValues::getValue...
1: SLDDataSupplier::NamedValues::getValue...
2: SLDDataSupplier::SLDDocument::setVariableText...
3: SLDDataSupplier::SLDDocument::replaceVariablesInNode...
4: SLDDataSupplier::SLDDocument::replaceVariablesInSubtree...
5: SLDDataSupplier::SLDDocument::replaceVariablesInSubtree...
6: SLDDataSupplier::SLDDocument::replaceVariablesInSubtree...
7: SLDDataSupplier::SLDDocument::replaceVariablesInSubtree...
8: SLDDataSupplier::SLDDocument::replaceVariablesInSubtree...
9: SLDDataSupplier::LandscapeDescription::load...
10: SLDDataSupplier::CIMModel::loadLandscape()...
11: SLDDataSupplier::CIMModel::CIMModel...
12: NameServer::SldRegistrator::generateSldXml...
13: NameServer::SldRegistrator::doSldRegistry...
14: NameServer::SldRegistrator::callback()...
15: NameServer::TimerThread::run(void*)...
16: TrexThreads::PoolThread::run()...
17: TrexThreads::PoolThread::run(void*&)...
18: Execution::Thread::staticMainImp(void**)...
Read more...
Environment
SAP HANA Database
Product
Keywords
high cpu; nameserver; sld; sldreg.xml; hdbinst; lm_structure package; , KBA , HAN-DB , SAP HANA Database , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.