SAP Knowledge Base Article - Preview

3561523 - Performance issue when fetching data from MSSQL server through smart data access (SDA) in Hana Database

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

SAP HANA, platform edition 2.0

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.