|
Home > Archive > microsoft.public.sqlserver.server > August 2002 > SQL2000 continuesly increases Memory usage
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL2000 continuesly increases Memory usage
|
|
| Lothar 2002-08-14, 3:23 am |
| Hi,
We've got an application using a Sql2000 DB. This runs fine on Windows
2000. But at some clients, we have an old NT4 server with SQL2000 on top of
that. What happens here is that as soon as we start SQL, it starts
increasing it's momory a bit at a time and after a week or two, the machine
craches due to too much memory.
Restarting the SQL service is sufficient to continue normally, but isn't teh
general idea.
Can anybody help me on this issue. How do I troubleshoot, or wat is the
solution?
thanks,
Lothar
| |
| Andrew Grillage 2002-08-14, 4:23 am |
| You can manage the memory that the server uses. In the Enterprise manager,
go to the properties for the server and find the memory tab. You can set an
upper limit from there.
--
Andrew Grillage
Synchrologic - Comprehensive Mobile Infrastructure
www.synchrologic.com
"Lothar" <lothar@nospam.regio.be> wrote in message
news:#ZCvnB3QCHA.1880@tkmsftngp13...
> Hi,
>
> We've got an application using a Sql2000 DB. This runs fine on Windows
> 2000. But at some clients, we have an old NT4 server with SQL2000 on top
of
> that. What happens here is that as soon as we start SQL, it starts
> increasing it's momory a bit at a time and after a week or two, the
machine
> craches due to too much memory.
>
> Restarting the SQL service is sufficient to continue normally, but isn't
teh
> general idea.
>
> Can anybody help me on this issue. How do I troubleshoot, or wat is the
> solution?
>
> thanks,
>
> Lothar
>
>
| |
| Egbert Nierop \(MVP for IIS\) 2002-08-14, 7:23 am |
| SQL 2000 is not known to have memory leaks but some older versions have some
on very specific actions. Did you apply all service packs?
Andrews hint is important too.
--
ASP Session replacement for webfarms
http://www.nieropwebconsult.nl/asp_session_manager.htm
"Lothar" <lothar@nospam.regio.be> wrote in message
news:#ZCvnB3QCHA.1880@tkmsftngp13...
> Hi,
>
> We've got an application using a Sql2000 DB. This runs fine on Windows
> 2000. But at some clients, we have an old NT4 server with SQL2000 on top
of
> that. What happens here is that as soon as we start SQL, it starts
> increasing it's momory a bit at a time and after a week or two, the
machine
> craches due to too much memory.
>
> Restarting the SQL service is sufficient to continue normally, but isn't
teh
> general idea.
>
> Can anybody help me on this issue. How do I troubleshoot, or wat is the
> solution?
>
> thanks,
>
> Lothar
>
>
| |
| Andrew J. Kelly 2002-08-14, 8:23 am |
| In addition to the others this may help explain some:
http://support.microsoft.com/defaul...b;en-us;q321363 SQL
Server 7 & 2000 memory usage
--
Andrew J. Kelly SQL MVP
Targitinteractive, Inc.
"Lothar" <lothar@nospam.regio.be> wrote in message
news:#ZCvnB3QCHA.1880@tkmsftngp13...
> Hi,
>
> We've got an application using a Sql2000 DB. This runs fine on Windows
> 2000. But at some clients, we have an old NT4 server with SQL2000 on top
of
> that. What happens here is that as soon as we start SQL, it starts
> increasing it's momory a bit at a time and after a week or two, the
machine
> craches due to too much memory.
>
> Restarting the SQL service is sufficient to continue normally, but isn't
teh
> general idea.
>
> Can anybody help me on this issue. How do I troubleshoot, or wat is the
> solution?
>
> thanks,
>
> Lothar
>
>
| |
| Lothar 2002-08-14, 9:23 am |
| Egbert,
Yes, I applied all SP's for both NT4 as SQL2000
I know I can set an upper limit for memory usage, but then the SQl server
only crashes earlier. It's either when system memory is full ,of limit is
reached
"Egbert Nierop (MVP for IIS)" <egbert_nierop@nospam.com> wrote in message
news:u1QzL84QCHA.3360@tkmsftngp11...
> SQL 2000 is not known to have memory leaks but some older versions have
some
> on very specific actions. Did you apply all service packs?
>
> Andrews hint is important too.
>
> --
> ASP Session replacement for webfarms
> http://www.nieropwebconsult.nl/asp_session_manager.htm
>
> "Lothar" <lothar@nospam.regio.be> wrote in message
> news:#ZCvnB3QCHA.1880@tkmsftngp13...
> > Hi,
> >
> > We've got an application using a Sql2000 DB. This runs fine on Windows
> > 2000. But at some clients, we have an old NT4 server with SQL2000 on top
> of
> > that. What happens here is that as soon as we start SQL, it starts
> > increasing it's momory a bit at a time and after a week or two, the
> machine
> > craches due to too much memory.
> >
> > Restarting the SQL service is sufficient to continue normally, but isn't
> teh
> > general idea.
> >
> > Can anybody help me on this issue. How do I troubleshoot, or wat is the
> > solution?
> >
> > thanks,
> >
> > Lothar
> >
> >
>
|
|
|
|
|