Symptom
You are facing many ABAP work processes waiting for HANA Database.
For example: As per ST12 trace you see long running SQL Statements, however on HANA DB SQL PlanCache the Performance is good.
Creating a C-Stack in transaction SM50 as per SAP Note: 2733232 - PROC memory consumption included in StackTrace information
for one affected Work process is showing following or similar C-Stack:
libc.so.6[T](epoll_wait+0x33)[0x7f25db158753,0xf0753]
libQueryCloudAZSDKCpp.so[epoll_reactor.ipp:471](boost::asio::detail::epoll_reactor::run(long, boost::asio::detail::op_queue<boost::asio::detail::scheduler_operation>&)+0xee)[0x7f12
libQueryCloudAZSDKCpp.so[scheduler.ipp:385](boost::asio::detail::scheduler::do_run_one(boost::asio::detail::conditionally_enabled_mutex::scoped_lock&, boost::asio::detail::schedule
libQueryCloudAZSDKCpp.so[scheduler.ipp:175](boost::asio::detail::scheduler::run_one(boost::system::error_code&)+0xda)[0x7f129a74c5c6,0x2195c6]
libQueryCloudAZSDKCpp.so[io_context.ipp:77](boost::asio::io_context::run_one()+0x2f)[0x7f129a74c775,0x219775]
libQueryCloudAZSDKCpp.so[NXLHttpClientAsync.cpp:178](NXLHttpClientAsync::Run()+0x44f)[0x7f129a74b0f5,0x2180f5]
libQueryCloudAZSDKCpp.so[QueryCloudAZManager.cpp:177](QueryCloudAZMgr::RequestToken()+0x3cb)[0x7f129a78eddb,0x25bddb]
libQueryCloudAZSDKCpp.so[QueryCloudAZManager.cpp:280](QueryCloudAZMgr::ErrCheck(CloudAZConnection*, QueryStatus)+0x71)[0x7f129a78f5b1,0x25c5b1]
libQueryCloudAZSDKCpp.so[QueryCloudAZManager.cpp:82](QueryCloudAZMgr::CheckSingleResource(IPolicyRequest const*, IPolicyResult**)+0x6d)[0x7f129a78e835,0x25b835]
libQueryCloudAZSDKCpp.so[QueryCloudAZExport.cpp:34](CheckSingleResource+0x30)[0x7f129a78ddda,0x25adda]
libhdb_new.so[QueryCAZPolicyOpr.cpp:829](single_query_pc(IPolicyRequest const*, IPolicyResult**)+0x23)[0x7f1299f4952c,0x23052c]
libhdb_new.so[PolicyManager.cpp:384](PolicyManager::QueryPC(NxlDBCUserInfo const*, NxlDBCResInfo const*, std::vector<EMTableInfo*, std::allocator<EMTableInfo*> >, std::string const
libhdb_new.so[PolicyManager.cpp:150](PolicyManager::QueryPC_Enforcer(NxlDBCUserInfo const*, NxlDBCResInfo const*, std::vector<EMTableInfo*, std::allocator<EMTableInfo*> >, std::str
libhdb_new.so[EMS4HSelectAst.cpp:426](EMS4HSelectAst::RewriteSQL(void*, NxlDBCUserInfo const*, NxlDBCResInfo const*, EnforcerCtxImpl*)+0xe5)[0x7f129a0fc013,0x3e3013]
libhdb_new.so[talk_with_hdb.cpp:310](nxl_execute_itab_new(SQLDBC::SQLDBC_PreparedStatement*, void*, bool, bool)+0x753)[0x7f1299e0ab91,0xf1b91]
libhdb_new.so[talk_with_hdb.cpp:462](execute_new+0x27)[0x7f1299e0b6a1,0xf26a1]
dbhdbslib.so[S](CSdbDbslSQL::execute(unsigned int, unsigned int, unsigned char)+0xf8)[0x7f129c896e38,0x117e38]
dbhdbslib.so[S](stmt_execute(void*, DBSL_SS*, IO_T, DBSL_DA*)+0x44e)[0x7f129c8626ae,0xe36ae]
dbhdbslib.so[S](exec_modify(void*, DBSL_SS*, unsigned char, IO_T, DBSL_DA*)+0x292)[0x7f129c86ed82,0xefd82]
dbhdbslib.so[S](DbSlHDBRead(short, DBSL_SS*, DBSL_DA*)+0x72e)[0x7f129c87963e,0xfa63e]
dw.sapXXX_XXX[S](dbsl_read+0x99)[0x55bffc3744e9,0x25aa4e9]
Read more...
Environment
- SAP HANA, platform edition 2.0
- SAP HANA, platform edition, ABAP platform
Product
Keywords
CloudAZ, performance, UPD, Lock, HANA DB, ST12, TransactionLockWaitSmpStat, nextlabs , KBA , HAN-DB-PERF , SAP HANA Database Performance , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , 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.