"Imran" <Imran@discussions.microsoft.com> wrote in message
news:D9788AC9-EA1E-499C-B12D-4131DB963B7F@microsoft.com...
> 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.

"Andrew J. Kelly" wrote:

> 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@discussions.microsoft.com> wrote in message
> news:D9788AC9-EA1E-499C-B12D-4131DB963B7F@microsoft.com...
> > 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.
>
>