I am running a DTS package via dtspkg.DLL objects in VB6. The package
executes all 19 Steps (38 Tasks) correctly but the SQL Server retains >200MB
of RAM after executing and consumes >500MB Swap Disk space. This brings the
system to a near stand still. Is there any way to tell SQL Server to 'write
and release' this memory?

TIA

--
Semper Fi,
Red

Please post to newsgroup only

Try

DBCC FREEPROCCACHE

That releases all Stored Procs cache.


"Stephen J Bement" <spam (AT) null (DOT) net> wrote

This reclaimed a small amount of the Physical RAM but I still have the
atrocious swap disk size. One time the operation evem made me expad my
virtual memory.

Any other ideas?


"Mark Jones" <mjones (AT) messagelabs (DOT) com> wrote