Knowledgebase:
Increase SAP Connector PacketSize
Posted by Tier1 Support on 30 October 2016 09:20 AM

Question

How do I to setup/tune the package size for Sap Loads and extracts?

Cause

The package size has a direct impact on memory consumption during data processing.

Maximum size of the data package (max KB)

When you transfer data into BI, the individual data records are sent to BI in packages of variable size. You use this parameter to control the typical size of a data package of this type.

If no entry is maintained, the data is transferred with the default setting of 10,000 kBytes per data package. However, the required memory depends on both the data package size setting and the width of the transfer structure, the required memory of the affected extractor, and, for large data packages, the number of data records in the package.

We recommend setting this value to between 20,000 and 100,000.

 You can find information about how applications affect the size of the data package and examples of calculating the size of the data package according to the control parameters in SAP Notes 417307 and 409641.

CUSTOM CONNECT TO "Provider=QvSAPSqlConnector.exe;servertype=0;ASHOST=SAPBWQA01;CLIENT=300;SYSNR=00;Timeout=3600;SNC_MODE=false;

SNC_QOP=9;advancedProperties=false;ConvRoutine=false;CheckSeparator=false;Nulldate=true;RemoveAllBlanks=false;

ReplaceNullvalue=true;Trace=false;DataTypeLegacyMode=false;PacketSize=100000;FetchBuffers=99999999;BufferPercentage=10;TimeOutBatch=600;

TimeOutFetch=1200;TimeOutStartBatch=2400;BatchJobName=/QTQVC/READ_DATA;SenseVersion=12.0.20400.0;XUserId=;XPassword=;";

 

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).