Dear All,
I have a scenario as,
One terminal is placing txt files in one folder, in each file I have data
for all tables, and I am following the following steps
Bulk Insert to that text file into a table with one column only
BCP Out for One Table Data (by where clause with expr column like)
Bulk Insert from that specific text into actual table
the infrastructure is , Windows 2003 Server with Service pack 1 and SQL
Server 2005 September CTP (Hardware with 3GB of RAM)
The problem i am facing is my package fails after inserting 2.* GB of Data,
and never able to run again until i restart server. And I have observed
server in task manager the memory usage is increasing by the time.
Please now guide me whether there may be some memory leakage problem in
Windows server 2k3 sp1 or sql server 2005 september ctp.
Thanks,
Imran.

That does not mean it is a memory leak. Sql server will use almost all
available memory (keeping some for the OS) if it thinks it can use it. It
only gives the memory back to the OS when it specifically asks for it. If
you are running multiple apps on the same box you might want to set a
maximum memory setting so that there is always memory available for the OS
and other apps. The other question is why are you using a CTP when the
released version is out? If you have any problems at all you will need to
use the released version to get official support.

--
Andrew J. Kelly SQL MVP


"Imran" <Imran (AT) discussions (DOT) microsoft.com> wrote

You are saying sql server will use almost all available memory, and i agree
that should be. But my question was i dont know why but either bcp our or
bulk insert, any one of the command has some design flaws. Internal process
implementation is getting memory but not releasing it.
The reason I am saying this is because after load of certain data my server
is not able to do any function, and i have to restart it. And also all is
fine if i am doing same from SSIS package for loading data.
Also my company has started process and hopefully i will get it in next week.

"Andrew J. Kelly" wrote: