3402002 - Performance issue between ABAP and HANA caused by Third Party Tool

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

Call stacks including lines like the bold ones and / or "nxl" related methods are found:

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]

libc.so.6[S](__GI___fcntl+0xa9)[0x7f8f95510727,0x107727]
libc.so.6[S](lockf+0x109)[0x7f8f955108c7,0x1078c7]
libtool.so[IPCManager.cpp:235](IPCManager::GetContent(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const
libhdb_new.so[PolicyManager.cpp:649](PolicyManager::QueryPC(NxlDBCUserInfo const*, NxlDBCResInfo const*, std::vector<EMTableInfo*, std::all
libhdb_new.so[PolicyManager.cpp:215](PolicyManager::QueryPC_Enforcer(NxlDBCUserInfo const*, NxlDBCResInfo const*, std::vector<EMTableInfo*,
libhdb_new.so[EMS4HSelectAst.cpp:579](EMS4HSelectAst::RewriteSQLForFilter(void*, NxlDBCUserInfo const*, NxlDBCResInfo const*, EnforcerCtxIm
libhdb_new.so[talk_with_hdb.cpp:527](nxl_execute_itab_new(SQLDBC::SQLDBC_PreparedStatement*, void*, bool, bool)+0xd8c)[0x7f8503f9627c,0x196
dbhdbslib.so[S](CSdbDbslSQL::execute(unsigned int, unsigned int, unsigned char)+0xc1)[0x7f850809fa11,0x9fa11]
dbhdbslib.so[S](stmt_execute(void*, DBSL_SS*, IO_T, DBSL_DA*)+0x510)[0x7f85080966f0,0x966f0]
dbhdbslib.so[S](exec_modify(void*, DBSL_SS*, unsigned char, IO_T, DBSL_DA*)+0x104)[0x7f8508095e34,0x95e34]
dbhdbslib.so[S](DbSlHDBBegRead(short, DBSL_SS*, DBSL_DA*)+0x4b7)[0x7f8508098cd7,0x98cd7]
dw.sapPRD_D00[S](dbsl_beg_read+0x90)[0x55910c662fc0,0x2462fc0]
dw.sapPRD_D00[S](DbDbslCursorMulti::doOpen()+0x2fa)[0x55910c68f2fa,0x248f2fa]
dw.sapPRD_D00[S](DbDbslCursor::open()+0x75)[0x55910c68efb5,0x248efb5]
dw.sapPRD_D00[S](DbDbslStatement::_executeQuery(dbi::base::Allocator&, DbExternalCursorKind, unsigned int, bool, bool)+0x418)[0x55910c6780e
dw.sapPRD_D00[S](DbCursor::_getDbslCursor(DbStmtScopeObject&, DbInputValues const&, DbOutputValues&, bool, DbslLongInputValue, DbslLongInpu
dw.sapPRD_D00[S](DbFaeCursor::createDbslCursor()+0x121)[0x55910c891ec1,0x2691ec1]
dw.sapPRD_D00[S](DbFaeCursor::nextDbslCursor()+0x7f)[0x55910c8913ef,0x26913ef]
dw.sapPRD_D00[S](DbFaeCursor::faeExecute()+0x1f)[0x55910c8910ff,0x26910ff]

libc.so.6[S](__GI___fcntl+0xa9)[0x7f7082310727,0x107727]
libc.so.6[S](lockf+0x109)[0x7f70823108c7,0x1078c7]
libtool.so[IPCManager.cpp:283](IPCManager::SetContent(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, char const*, int)+
libhdb_new.so[NXS4HConfig.cpp:405](NXS4HConfig::CycleUpdate(void*)+0x1e9)[0x7f6363fdcbc9,0x1dcbc9]
libhdb_new.so[talk_with_hdb.cpp:301](nxl_execute_itab_new(SQLDBC::SQLDBC_PreparedStatement*, void*, bool, bool)+0x96)[0x7f6363f95586,0x195586]
dbhdbslib.so[S](CSdbDbslSQL::execute(unsigned int, unsigned int, unsigned char)+0xc1)[0x7f636809fa11,0x9fa11]
dbhdbslib.so[S](stmt_execute(void*, DBSL_SS*, IO_T, DBSL_DA*)+0x510)[0x7f63680966f0,0x966f0]
dbhdbslib.so[S](exec_modify(void*, DBSL_SS*, unsigned char, IO_T, DBSL_DA*)+0x104)[0x7f6368095e34,0x95e34]
dbhdbslib.so[S](DbSlHDBRead(short, DBSL_SS*, DBSL_DA*)+0x200)[0x7f6368095340,0x95340]

• SAP HANA, platform edition 2.0
• SAP HANA, platform edition, ABAP platform

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