SQL Memory Usage

[Former Member]

Hello

I am updating some items with the DTW. i am updating 9000 items. I have made 9 files of 1000 records, i am just updating the picturname field. When i start to upload the files the SQL Memory usage starts to grow more and more. When i try to upload the third file the memory has grown too much, and the DTW says the file update ok but it doesnt update the database. So i need to restart the SQL service (mssqlserver) and do it again. Some times it doesnt work so i need to restart the server.

Any ideas??

Jacobo

[former_member187989]

hi,

Check this information abt DI API Memory Consumption in WIKI SDK FAQ's.

https://www.sdn.sap.com/irj/scn/wiki?path=/display/b1/faq_sdk

DI API
Memory consumption
New connection mechanism in 2007 vs. classical
1. In the old method the DI API was loaded into the same process with the Add-On and was an "actual part" of it, so calls to the DI-API were very quick and direct
2. In the new method there is one common DI-API which is part of the Core B1. All the Add-Ons will use the same DI-API IF (!!!) they work in the new method. The calls to the DI-API have now to "go between" two processes. This means that they go through more processing and although it's all in the same machine and no actual communication (i.e., network traffic) is actually happening, the system's CPU and memory are "working harder".
The impact is extremely small on an individual call level, but for an Add-On that makes a large amount of calls this difference accumulates...
There is no huge additional CPU or Memory consumption. Most of the impact is on the Response Time level. Some of it is CPU consumption and some of it is Context Switch waiting.
3. This trade-off between Memory consumption and Response Time is actually another reason why R&D thought it's a good idea to leave the new method to be optional based on a decision from the developer.

Jeyakanthan

[jacobo_agami]

Hello

I am using the Data Transfer, how i can choose wich component i want to use?

Thanks

[michael_boucher2]

Does the memory usage go down between each upload?

How much memory do you have and how much is it using at its peak?

[Former Member]

Hello

The memory doesnt go down between each upload, i think thats the problem.

The memory keeps growing and growing i have 8 gb memory in the server, and the sqlserver gets 2.5 gb but still growing. So i need to restart the sqlserver so i can upload succesfully again.

Thanks

Jacobo

[michael_boucher2]

SQL server has a memory buffer that can grow and shrink in size on demand. So if it suddenly finds it needs 2.5GB, it will take that and not give it back until another process needs some of that memory, or of course when the service is restarted.

You can try adjusting the memory usage limits:

http://support.microsoft.com/default.aspx?scid=kb;en-us;321363

Noting you should also run DTW when there are no other users connected.

Edited by: Michael Boucher on Apr 30, 2009 1:00 AM