Control/Limit Memory usage

Hello,

I was wondering if there was a setting or a way to limit or restrict the amount of Memory an SSIS package can use? I know that by default the windows OS limits a process (a package in this case) to 2GB and up to 3GB with AWE enable but what if I wanted to say Limit it to 1GB of memory is there anyway to do that? Is there an SSIS Engine setting or Package property somewhere?

Thanks!

See if this helps you. Check out the Buffer size section in this paper:
http://www.microsoft.com/technet/prodtechnol/sql/2005/ssisperf.mspx

Consuming all Memory

This is a multi-part message in MIME format.
--=_NextPart_000_003B_01C6948D.B1B75700
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
We have an application running in MSSQL 2000 with SP 4 and C#.NET 2003.
This server has 8 GB of memory and enough hard drive.
The MSSQL server keep consuming more and more memory and never release = it. It gets to the point that we have to reboot or the server crash.
The MSSQL memory start with 278432 kb of ram until it take all the = memory available in the server.
My question is..
What happend If I specify a minimum and maximun amount of memory. Will = MSSQL stop running when it get to the maximun or what will happned?
I will appreciate your help,
Rafael
--=_NextPart_000_003B_01C6948D.B1B75700
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
We have an application running in MSSQL = 2000 with SP 4 and C#.NET 2003.

This server has 8 GB of memory and = enough hard drive.

The MSSQL server keep consuming more = and more memory and never release it. It gets to the point that we have to = reboot or the server crash.

The MSSQL memory start with 278432 kb = of ram until it take all the memory available in the server.

My question is..

What happend If I specify a minimum and = maximun amount of memory. Will MSSQL stop running when it get to the maximun or = what will happned?


I will appreciate your = help,

Rafael
--=_NextPart_000_003B_01C6948D.B1B75700--This is a multi-part message in MIME format.
--=_NextPart_000_005B_01C694C0.9BB01E00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi
How to adjust memory usage by using configuration options in SQL Server:
http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;Q321363=20
-- Mike
This posting is provided "AS IS" with no warranties, and confers no =rights.
"Rafael Tejera" <rafaeltejera@.hotmail.com> wrote in message =news:OnAVm8KlGHA.836@.TK2MSFTNGP02.phx.gbl...
We have an application running in MSSQL 2000 with SP 4 and C#.NET =2003.
This server has 8 GB of memory and enough hard drive.
The MSSQL server keep consuming more and more memory and never release =it. It gets to the point that we have to reboot or the server crash.
The MSSQL memory start with 278432 kb of ram until it take all the =memory available in the server.
My question is..
What happend If I specify a minimum and maximun amount of memory. Will =MSSQL stop running when it get to the maximun or what will happned?
I will appreciate your help,
Rafael
--=_NextPart_000_005B_01C694C0.9BB01E00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Hi
How to adjust memory usage by using configuration options in SQL Server:
http://support.microsoft.com/default.aspx?scid=3Dkb;en-us=;Q321363 -- Mike
This posting is provided "AS IS" with no warranties, and confers no =rights.
"Rafael Tejera" = wrote in message news:OnAVm8KlGHA.836@.T=K2MSFTNGP02.phx.gbl...
We have an application running in =MSSQL 2000 with SP 4 and C#.NET 2003.

This server has 8 GB of memory and =enough hard drive.

The MSSQL server keep consuming more =and more memory and never release it. It gets to the point that we have =to reboot or the server crash.

The MSSQL memory start with 278432 kb =of ram until it take all the memory available in the server.

My question is..

What happend If I specify a minimum =and maximun amount of memory. Will MSSQL stop running when it get to the maximun =or what will happned?


I will appreciate your =help,

Rafael

---

--=_NextPart_000_005B_01C694C0.9BB01E00--

Consuming all Memory

Hi
How to adjust memory usage by using configuration options in SQL Server:
http://support.microsoft.com/defaul...b;en-us;Q321363
--
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rafael Tejera" <rafaeltejera@.hotmail.com> wrote in message news:OnAVm8KlGHA
.836@.TK2MSFTNGP02.phx.gbl...
We have an application running in MSSQL 2000 with SP 4 and C#.NET 2003.
This server has 8 GB of memory and enough hard drive.
The MSSQL server keep consuming more and more memory and never release it.
It gets to the point that we have to reboot or the server crash.
The MSSQL memory start with 278432 kb of ram until it take all the memory av
ailable in the server.
My question is..
What happend If I specify a minimum and maximun amount of memory. Will MSSQL
stop running when it get to the maximun or what will happned?
I will appreciate your help,
RafaelWe have an application running in MSSQL 2000 with SP 4 and C#.NET 2003.
This server has 8 GB of memory and enough hard drive.
The MSSQL server keep consuming more and more memory and never release it.
It gets to the point that we have to reboot or the server crash.
The MSSQL memory start with 278432 kb of ram until it take all the memory av
ailable in the server.
My question is..
What happend If I specify a minimum and maximun amount of memory. Will MSSQL
stop running when it get to the maximun or what will happned?
I will appreciate your help,
Rafael|||Hi
How to adjust memory usage by using configuration options in SQL Server:
http://support.microsoft.com/defaul...b;en-us;Q321363
--
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rafael Tejera" <rafaeltejera@.hotmail.com> wrote in message news:OnAVm8KlGHA
.836@.TK2MSFTNGP02.phx.gbl...
We have an application running in MSSQL 2000 with SP 4 and C#.NET 2003.
This server has 8 GB of memory and enough hard drive.
The MSSQL server keep consuming more and more memory and never release it.
It gets to the point that we have to reboot or the server crash.
The MSSQL memory start with 278432 kb of ram until it take all the memory av
ailable in the server.
My question is..
What happend If I specify a minimum and maximun amount of memory. Will MSSQL
stop running when it get to the maximun or what will happned?
I will appreciate your help,
Rafael