Memory

Hi, Experts
I have a sql server 7 on NT4.0 box.
2GB memory for the server.
Recently we can not do tape back up during the night.
we check CPU load is normal, but memory sql sever process
uses up to 1.5 GB of the 2GB. Is this normal?
It used to not take that much.
And the biggest database on that box is only 400MB.
Any advice.
Thanks
Laopangthis could be because of memory leaks, what service pack
you are running ? Is it possible for you to upgrade to sql
2000 or atleast upto sp4 for sql 7?
restart the server to resolve this temporarily.
hth
>--Original Message--
>Hi, Experts
>I have a sql server 7 on NT4.0 box.
>2GB memory for the server.
>Recently we can not do tape back up during the night.
>we check CPU load is normal, but memory sql sever process
>uses up to 1.5 GB of the 2GB. Is this normal?
>It used to not take that much.
>And the biggest database on that box is only 400MB.
>Any advice.
>Thanks
>Laopang
>.
>|||SQL Server will not release memory once it has grabbed it unless the OS
specifically asks for it. Just because the db is of a certain size does not
limit the amount of ram sql server can use. Sounds like it can easily get
away with using less so I suggest you set the MAX memory for sql server to
say 1GB and see how that works.
--
Andrew J. Kelly
SQL Server MVP
"laopang" <laopang@.hotmail.com> wrote in message
news:0cfd01c3b383$5b42d4a0$a001280a@.phx.gbl...
> Hi, Experts
> I have a sql server 7 on NT4.0 box.
> 2GB memory for the server.
> Recently we can not do tape back up during the night.
> we check CPU load is normal, but memory sql sever process
> uses up to 1.5 GB of the 2GB. Is this normal?
> It used to not take that much.
> And the biggest database on that box is only 400MB.
> Any advice.
> Thanks
> Laopang