Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Memory drying on NT

4 posts in Windows NT Last posting was on 2000-10-16 17:20:24.0Z
tom medved Posted on 2000-10-11 14:18:49.0Z
From: tom medved <tomas.medved.at@usa.net>
Subject: Memory drying on NT
Date: Wed, 11 Oct 2000 10:18:49 -0400
Organization: --
Lines: 11
Message-ID: <39E476C9.4AD0EBB9@usa.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.73 [en] (WinNT; U)
X-Accept-Language: en
Newsgroups: comp.databases.sybase,sybase.public.sqlserver.nt
NNTP-Posting-Host: 198.138.69.45
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1584
Article PK: 1089060

I restart the server every Saturday night. It usually allocates about
400MB of 524MB RAM in accordance to NT Task manager. After this memory
dries out day-by-day and after it reaches the margin of 220MB, CPU
utilization jumps up to 80-100% and all processes on the server get
stuck. I still keep v11.0.3.3 on the server for legacy purposes. I
wonder what might be the case. The server isn't that heavily used (about
70 concurrent connections), and the only other thing running on it is an
ARCserve client for disk backups.
P.S. Cache size, however, stays intact at about 140MB. So it's the NT
process that loses memory mysteriously.


Flywheel Posted on 2000-10-16 09:56:27.0Z
From: Flywheel <flywheel107720@my-deja.com>
Subject: Re: Memory drying on NT
Date: Mon, 16 Oct 2000 09:56:27 GMT
Organization: Deja.com - Before you buy.
Lines: 28
Message-ID: <8sejca$2kg$1@nnrp1.deja.com>
References: <39E476C9.4AD0EBB9@usa.net>
X-Article-Creation-Date: Mon Oct 16 09:56:27 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows 95; ACIE4SP1)
X-Http-Proxy: 1.0 WKCAP1002, 1.0 x57.deja.com:80 (Squid/1.1.22) for client 212.134.161.2
X-MyDeja-Info: XMYDJUIDflywheel107720
Newsgroups: comp.databases.sybase,sybase.public.sqlserver.nt
NNTP-Posting-Host: 198.138.69.45
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1569
Article PK: 1089048

By any chance are you running Sybase Historical Server as part of your
Sybase installation ?

I found this to have a memory leak running on 11.0.3.3 on NT 4

It's just a thought.


In article <39E476C9.4AD0EBB9@usa.net>,

tom medved <tomas.medved.at@usa.net> wrote:
> I restart the server every Saturday night. It usually allocates about
> 400MB of 524MB RAM in accordance to NT Task manager. After this memory
> dries out day-by-day and after it reaches the margin of 220MB, CPU
> utilization jumps up to 80-100% and all processes on the server get
> stuck. I still keep v11.0.3.3 on the server for legacy purposes. I
> wonder what might be the case. The server isn't that heavily used
(about
> 70 concurrent connections), and the only other thing running on it is
an
> ARCserve client for disk backups.
> P.S. Cache size, however, stays intact at about 140MB. So it's the NT
> process that loses memory mysteriously.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy.


tom medved Posted on 2000-10-16 14:26:15.0Z
From: tom medved <tomas.medved.at@usa.net>
Subject: Re: Memory drying on NT
Date: Mon, 16 Oct 2000 10:26:15 -0400
Organization: --
Lines: 37
Message-ID: <39EB1007.E3F8F324@usa.net>
References: <39E476C9.4AD0EBB9@usa.net> <8sejca$2kg$1@nnrp1.deja.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.73 [en] (WinNT; U)
X-Accept-Language: en
Newsgroups: comp.databases.sybase,sybase.public.sqlserver.nt
NNTP-Posting-Host: 198.138.69.45
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1568
Article PK: 1089044

No I'm not. Someone pointed out that it might be the NT system cache that's
competing with Sybase for resources, so I'm going to set LargeSystemCache to
0 in the registry. But I still don't understand why with all this system
cache competition the sqlsrv process is just losing memory. I could see it
getting pushed to the swap, but not to go 50% down in allocated virtual
space in a week.

Flywheel wrote:

> By any chance are you running Sybase Historical Server as part of your
> Sybase installation ?
>
> I found this to have a memory leak running on 11.0.3.3 on NT 4
>
> It's just a thought.
>
> In article <39E476C9.4AD0EBB9@usa.net>,
> tom medved <tomas.medved.at@usa.net> wrote:
> > I restart the server every Saturday night. It usually allocates about
> > 400MB of 524MB RAM in accordance to NT Task manager. After this memory
> > dries out day-by-day and after it reaches the margin of 220MB, CPU
> > utilization jumps up to 80-100% and all processes on the server get
> > stuck. I still keep v11.0.3.3 on the server for legacy purposes. I
> > wonder what might be the case. The server isn't that heavily used
> (about
> > 70 concurrent connections), and the only other thing running on it is
> an
> > ARCserve client for disk backups.
> > P.S. Cache size, however, stays intact at about 140MB. So it's the NT
> > process that loses memory mysteriously.
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.


Flywheel Posted on 2000-10-16 17:20:24.0Z
From: Flywheel <flywheel107720@my-deja.com>
Subject: Re: Memory drying on NT
Date: Mon, 16 Oct 2000 17:20:24 GMT
Organization: Deja.com - Before you buy.
Lines: 69
Message-ID: <8sfdcf$ofo$1@nnrp1.deja.com>
References: <39E476C9.4AD0EBB9@usa.net> <8sejca$2kg$1@nnrp1.deja.com> <39EB1007.E3F8F324@usa.net>
X-Article-Creation-Date: Mon Oct 16 17:20:24 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows 95; ACIE4SP1)
X-Http-Proxy: 1.0 WKCAP1002, 1.0 x70.deja.com:80 (Squid/1.1.22) for client 212.134.161.2
X-MyDeja-Info: XMYDJUIDflywheel107720
Newsgroups: comp.databases.sybase,sybase.public.sqlserver.nt
NNTP-Posting-Host: 198.138.69.45
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1567
Article PK: 1089046

An sp_configure total memory of 400mb for Sybase leaving 120 ish for NT
seems very sensible, indeed generous for the NT OS. I assume this is
all physical RAM ? you don't want any disk caching.

You could ask some NT heads if there are tools that give more detail on
mem usage than Task Manager, do you have the excellent NT Resource Kit,
my NT admin colleagues used to swear by that.

I have to say have you considered re-installing NT. I would be tempted
to do this.

good luck



In article <39EB1007.E3F8F324@usa.net>,

tom medved <tomas.medved.at@usa.net> wrote:
> No I'm not. Someone pointed out that it might be the NT system cache
that's
> competing with Sybase for resources, so I'm going to set
LargeSystemCache to
> 0 in the registry. But I still don't understand why with all this
system
> cache competition the sqlsrv process is just losing memory. I could
see it
> getting pushed to the swap, but not to go 50% down in allocated
virtual
> space in a week.
>
> Flywheel wrote:
>
> > By any chance are you running Sybase Historical Server as part of
your
> > Sybase installation ?
> >
> > I found this to have a memory leak running on 11.0.3.3 on NT 4
> >
> > It's just a thought.
> >
> > In article <39E476C9.4AD0EBB9@usa.net>,
> > tom medved <tomas.medved.at@usa.net> wrote:
> > > I restart the server every Saturday night. It usually allocates
about
> > > 400MB of 524MB RAM in accordance to NT Task manager. After this
memory
> > > dries out day-by-day and after it reaches the margin of 220MB, CPU
> > > utilization jumps up to 80-100% and all processes on the server
get
> > > stuck. I still keep v11.0.3.3 on the server for legacy purposes. I
> > > wonder what might be the case. The server isn't that heavily used
> > (about
> > > 70 concurrent connections), and the only other thing running on
it is
> > an
> > > ARCserve client for disk backups.
> > > P.S. Cache size, however, stays intact at about 140MB. So it's
the NT
> > > process that loses memory mysteriously.
> > >
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy.