Symptom
Critical performance issue detected using Smart Data Access (SDA) connection to MSSQL server causing delay in fetching data.
SDA traces show the below symptoms:
[3678]\{303674\}[137/-1] 2024-12-30 17:14:14.551655 w FedTrace odbcaccess.cpp(02676) : Using fetch size of 1 (array Fetch not supported). Data transfer may be slow
[19845]\{315857\}[158/1376642744] 2024-12-30 18:01:06.105012 w FedTrace odbcresult.cpp(01200) : Using fetch size of 1 (LOBs). Data transfer may be slow
Read more...
Environment
SAP HANA, platform edition
Product
Keywords
Smart Data Access, SDA, Performance, MSSQL server, Using fetch size of 1, data transfer, slow , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , 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.