sql server dts: sql server 2000
we have a .net process that creates and executes a DTS package
programatically.
we are having an issue with memory consumption.
both our application's & sql server's memory usage rise with each package
creation and neither fall with the package release.
by using GC.Collect() and GC.GetTotalMemory() i am certain that the problem
is not within our application as memory usage remains constant - it goes up
when the package is created and drops when it is released.
however sql server memory consumption continues to rise.
I assume that this is due to caching within sql server.
Since our packages are gynamic and never reused, they are overwritten on
each use ( deleted & recreated ) caching serves no purpose in this case -
is it possible to turn caching off for these particular packages or even for
all DTS packages ?

we create the DTS package using :
DTS.Package2Class package=new DTS.Package2Class();

to release the package we use :
package.Uninitialize();
package=null;

is there anything else we need to do to release the package ?

gerry

[quoted text, click to view]

Hi Gerry,

From your descriptions, I understood that you would like to keep SQL Server
memory memory consumption. Have I understood you? Correct me if I was wrong.

I am afraid you could not disable this kind of cache inside SQL Server. As
the server runs, the memory manager checks to make sure that a given amount
of physical memory remains available on the server so that Windows and
other applications on the server continue to run smoothly. This amount can
vary between 4MB and 10MB (it trends closer to 10MB on Windows Server 2003)
and is based on the system load and the page life expectancy for the BPool.

So, throughout the time that it runs, SQL Server's memory manager process
monitors the memory status of the system to be sure that a reasonable
amount of free physical memory remains available to the rest of the system
and that a healthy number of free pages remains available for use by new
memory allocation requests.

See more detailed descriptioins of SQL Server 2000 memory management in the
following documents, especially chapter "Recap" and "The Memory Manager"
Inside SQL Server 2000's Memory Management Facilities
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqldev/ht
ml/sqldev_01262004.asp


Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Hi Gerry,

I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!

Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Hi ,

thanks for the replies , this issue is on hold at the moment - more pressing
things to attend to

gerry


[quoted text, click to view]

Hi Gerry,

Thanks for letting me know the status of this.

Please feel free when you are free and you would like to make a follow up.
I am willing to discuss this issue with you. Whenever you have any
questions or concerns, don't hesitate to let me know. We are here to be of
assistance!


Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Thanks - much appreciated :-)


[quoted text, click to view]