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