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.

NT Memory Maximum

28 posts in Windows NT Last posting was on 2001-05-16 20:39:38.0Z
Justin Largent Posted on 2001-05-01 21:48:38.0Z
Message-ID: <3AEF2F35.890FD227@bjc.org>
Date: Tue, 01 May 2001 16:48:38 -0500
From: Justin Largent <jlargent@bjc.org>
X-Mailer: Mozilla 4.7 [en] (WinNT; U)
X-Accept-Language: en,pdf
MIME-Version: 1.0
Subject: NT Memory Maximum
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 18
NNTP-Posting-Host: pele1.bjc.org 199.217.143.98
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:842
Article PK: 1087450

I have a Compaq Proliant 6400R, 4 CPU, 4GB RAM machine. I have NT
Enterprise 4.0 with SP4 installed AND have the 4GT option enabled. I
have installed ASE 11.9.2 with EBF8613. I have a paging file size of
267MB.

Can someone please tell me why the maximum amount of memory I can put in
for "total memory" is about 1292000 pages (~2523MB)? I have tried
1390000, 1300000, 1295000. and 1290000 in hopes of maximizing my memory
use. 1290000 worked, and 1292000 worked, but why can I not get any
higher!!!!!!?????

I realize NT is supposed to get 1GB. WHY CANNOT I NOT GET SYBASE HIGHER
THAN 2.5GB ROUGHLY?

Thanks in advance,

Dean Furness
Quilogy
dfurness@quilogy.com


Jay Kwon Posted on 2001-05-02 17:05:08.0Z
From: "Jay Kwon" <jkwon@macgreg.ws>
References: <3AEF2F35.890FD227@bjc.org>
Subject: Re: NT Memory Maximum
Date: Wed, 2 May 2001 13:05:08 -0400
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <UVSkUyy0AHA.262@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: host132.merrin.com 206.0.17.132
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:833
Article PK: 1087441

I had a similar issue on ASE1192 on NT. Problem I had was that my paging
file was spread out across multiple discs (for perf reasons) but ASE only
recognized paging file on my first disc only. I think I had about 1GB on C:
then 3GB's each on 2 other discs but I kept getting shared memory msg until
I increased my paging file on my first drive. Keep increasing paging file
(or first instance of swap file I should say) to about 2:1/Page file to ASE
memory ratio. Hope that helps.

Jay Kwon
MacGregor

"Justin Largent" <jlargent@bjc.org> wrote in message
news:3AEF2F35.890FD227@bjc.org...
> I have a Compaq Proliant 6400R, 4 CPU, 4GB RAM machine. I have NT
> Enterprise 4.0 with SP4 installed AND have the 4GT option enabled. I
> have installed ASE 11.9.2 with EBF8613. I have a paging file size of
> 267MB.
>
> Can someone please tell me why the maximum amount of memory I can put in
> for "total memory" is about 1292000 pages (~2523MB)? I have tried
> 1390000, 1300000, 1295000. and 1290000 in hopes of maximizing my memory
> use. 1290000 worked, and 1292000 worked, but why can I not get any
> higher!!!!!!?????
>
> I realize NT is supposed to get 1GB. WHY CANNOT I NOT GET SYBASE HIGHER
> THAN 2.5GB ROUGHLY?
>
> Thanks in advance,
>
> Dean Furness
> Quilogy
> dfurness@quilogy.com
>


Ray DiMarcello Posted on 2001-05-02 19:50:40.0Z
From: "Ray DiMarcello" <rdimarcello@ingva.com>
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com>
Subject: Re: NT Memory Maximum
Date: Wed, 2 May 2001 15:50:40 -0400
Lines: 49
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <HH6wmQ00AHA.178@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 207.245.124.67
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:830
Article PK: 1087437

Did Sybase TS confirm that the ASE server only recognizes the first instance
of the swap file? That sounds strange.

Dean, did you change the "shared memory starting address" using sp_configure
??

RD

Jay Kwon wrote in message ...
>I had a similar issue on ASE1192 on NT. Problem I had was that my paging
>file was spread out across multiple discs (for perf reasons) but ASE only
>recognized paging file on my first disc only. I think I had about 1GB on
C:
>then 3GB's each on 2 other discs but I kept getting shared memory msg until
>I increased my paging file on my first drive. Keep increasing paging file
>(or first instance of swap file I should say) to about 2:1/Page file to ASE
>memory ratio. Hope that helps.
>
>Jay Kwon
>MacGregor
>
>"Justin Largent" <jlargent@bjc.org> wrote in message
>news:3AEF2F35.890FD227@bjc.org...
>> I have a Compaq Proliant 6400R, 4 CPU, 4GB RAM machine. I have NT
>> Enterprise 4.0 with SP4 installed AND have the 4GT option enabled. I
>> have installed ASE 11.9.2 with EBF8613. I have a paging file size of
>> 267MB.
>>
>> Can someone please tell me why the maximum amount of memory I can put in
>> for "total memory" is about 1292000 pages (~2523MB)? I have tried
>> 1390000, 1300000, 1295000. and 1290000 in hopes of maximizing my memory
>> use. 1290000 worked, and 1292000 worked, but why can I not get any
>> higher!!!!!!?????
>>
>> I realize NT is supposed to get 1GB. WHY CANNOT I NOT GET SYBASE HIGHER
>> THAN 2.5GB ROUGHLY?
>>
>> Thanks in advance,
>>
>> Dean Furness
>> Quilogy
>> dfurness@quilogy.com
>>
>
>


Justin Largent Posted on 2001-05-02 20:35:27.0Z
Message-ID: <3AF06F8F.4B6D3AD6@bjc.org>
Date: Wed, 02 May 2001 15:35:27 -0500
From: Justin Largent <jlargent@bjc.org>
X-Mailer: Mozilla 4.7 [en] (WinNT; U)
X-Accept-Language: en,pdf
MIME-Version: 1.0
Subject: Re: NT Memory Maximum
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 51
NNTP-Posting-Host: pele1.bjc.org 199.217.143.98
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:823
Article PK: 1087430

I have been trying all of your suggestions...thanks for the input. At this
time, I have not gotten any further, other than narrowing the amount to 100
pages... (1294500 works, 1294600 does not).

Ray, I will try your suggestion and see what happens...

Thanks!

Dean

Ray DiMarcello wrote:

> Did Sybase TS confirm that the ASE server only recognizes the first instance
> of the swap file? That sounds strange.
>
> Dean, did you change the "shared memory starting address" using sp_configure
> ??
>
> RD
>
> Jay Kwon wrote in message ...
> >I had a similar issue on ASE1192 on NT. Problem I had was that my paging
> >file was spread out across multiple discs (for perf reasons) but ASE only
> >recognized paging file on my first disc only. I think I had about 1GB on
> C:
> >then 3GB's each on 2 other discs but I kept getting shared memory msg until
> >I increased my paging file on my first drive. Keep increasing paging file
> >(or first instance of swap file I should say) to about 2:1/Page file to ASE
> >memory ratio. Hope that helps.
> >
> >Jay Kwon
> >MacGregor
> >
> >"Justin Largent" <jlargent@bjc.org> wrote in message
> >news:3AEF2F35.890FD227@bjc.org...
> >> I have a Compaq Proliant 6400R, 4 CPU, 4GB RAM machine. I have NT
> >> Enterprise 4.0 with SP4 installed AND have the 4GT option enabled. I
> >> have installed ASE 11.9.2 with EBF8613. I have a paging file size of
> >> 267MB.
> >>
> >> Can someone please tell me why the maximum amount of memory I can put in
> >> for "total memory" is about 1292000 pages (~2523MB)? I have tried
> >> 1390000, 1300000, 1295000. and 1290000 in hopes of maximizing my memory
> >> use. 1290000 worked, and 1292000 worked, but why can I not get any
> >> higher!!!!!!?????
> >>
> >> I realize NT is supposed to get 1GB. WHY CANNOT I NOT GET SYBASE HIGHER
> >> THAN 2.5GB ROUGHLY?
> >>
> >> Thanks in advance,
> >>
> >> Dean Furness
> >> Quilogy
> >> dfurness@quilogy.com
> >>
> >
> >


Geoff_Smith Posted on 2001-05-08 00:54:29.0Z
From: Geoff_Smith
Date: Mon, 7 May 2001 20:54:29 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: NT Memory Maximum
Message-ID: <98716E1C9B057C7D0004FD1C85256A46.0075263385256A40@webforums>
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com> <3AF06F8F.4B6D3AD6@bjc.org>
Lines: 16
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:789
Article PK: 1087397

OK

I have been following all this and will implement an increase of ASE memory
from 1.4 G to 2.4 G increasing pagefile size from 3500M to 4800M and
changing the shared memory starting address to 23662592.

This should be a good start.

I'll post any problems / results / performance changes over the next few
days to a week.

Thanks to everyone so far for some AWESOME information.

Cheers,

Geoff


Geoff_Smith Posted on 2001-05-08 01:05:37.0Z
From: Geoff_Smith
Date: Mon, 7 May 2001 21:05:37 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: NT Memory Maximum
Message-ID: <6AD0C89D29B3CD6E0006023085256A46.00058BB285256A46@webforums>
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com> <3AF06F8F.4B6D3AD6@bjc.org> <98716E1C9B057C7D0004FD1C85256A46.0075263385256A40@webforums>
Lines: 6
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:788
Article PK: 1087394

If I want to increase the pagefile above 4800M I will need to find space on
another drive (which wont be easy). If I do, are/or aren't there any
problems with this is respect to ASE. It seems there is a bit of descent in
this area????

Geoff


Jim Egan Posted on 2001-05-09 14:33:47.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: NT Memory Maximum
Date: Wed, 9 May 2001 08:33:47 -0600
Message-ID: <MPG.1563033abeb8c88898b338@forums.sybase.com>
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com> <3AF06F8F.4B6D3AD6@bjc.org> <98716E1C9B057C7D0004FD1C85256A46.0075263385256A40@webforums> <6AD0C89D29B3CD6E0006023085256A46.00058BB285256A46@webforums>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.50
Newsgroups: sybase.public.sqlserver.nt
Lines: 14
NNTP-Posting-Host: jpe650.sybase.com 157.133.56.39
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:771
Article PK: 1087379


Geoff_Smith wrote...
> If I want to increase the pagefile above 4800M I will need to find space on
> another drive (which wont be easy). If I do, are/or aren't there any
> problems with this is respect to ASE. It seems there is a bit of descent in
> this area????
>
> Geoff
>

Just to confirm what Tony said, I spread the swap (3 to 4GB) file over two disks and didn't
have any problem.
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Get your free subscription to PowerTimes at http://www.powertimes.com


Tony Imbierski Posted on 2001-05-08 09:36:45.0Z
Message-ID: <3AF7BE2D.96798FBC@sybase.com>
Date: Tue, 08 May 2001 10:36:45 +0100
From: Tony Imbierski <tonyi@sybase.com>
X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: NT Memory Maximum
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com> <3AF06F8F.4B6D3AD6@bjc.org> <98716E1C9B057C7D0004FD1C85256A46.0075263385256A40@webforums> <6AD0C89D29B3CD6E0006023085256A46.00058BB285256A46@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 18
NNTP-Posting-Host: aja.sybase.com 158.76.131.36
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:782
Article PK: 1087391


Geoff_Smith wrote:

> If I want to increase the pagefile above 4800M I will need to find space on
> another drive (which wont be easy). If I do, are/or aren't there any
> problems with this is respect to ASE. It seems there is a bit of descent in
> this area????
>
> Geoff

The distribution of your paging files is invisible to ASE, only the total size
matters. I am the engineer directly responsible for this section of code so if
you find this is not true, let me know straight away! btw. I am running a
number of NT systems with page files spread over 2 or more disks.

cheers,
tonyi
--
Tony Imbierski
Sybase Engineering

-- how much daylight did you save today? --


Ray DiMarcello Posted on 2001-05-10 20:37:59.0Z
From: "Ray DiMarcello" <rdimarcello@ingva.com>
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com> <3AF06F8F.4B6D3AD6@bjc.org> <98716E1C9B057C7D0004FD1C85256A46.0075263385256A40@webforums> <6AD0C89D29B3CD6E0006023085256A46.00058BB285256A46@webforums> <3AF7BE2D.96798FBC@sybase.com>
Subject: Re: NT Memory Maximum
Date: Thu, 10 May 2001 16:37:59 -0400
Lines: 52
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <Rq$F0PZ2AHA.302@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 207.245.124.67
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:757
Article PK: 1087364

Tony or Jim, any comment on the following? I posted it earlier in this
thread ... I'm referring to shared memory starting address here ...



I believe the unit is bytes. 23662592 / 1048576 bytes per meg = 22.5 meg.
23662592 is the number recommended by Sybase (as they stated in an email to
me once). But I have no idea why. Where'd you get that number? They say
the default for that setting on NT is 500meg. There must be some, maybe
negative, implications to changing it from 500 to 22.5. I can't just change
it here in production without providing the higher-ups some detailed
reasoning behind it other than, "see, I can set total memory higher." Until
I get some more detail from them I'm stuck allocating 1.5 gig out of 3.5 to
Sybase on our Compaq 8500R 700mhz 8-way.

Anyone from Sybase want to weigh in? I've tried but cannot find any good
whitepapers, etc. on this topic.

Tony Imbierski wrote in message <3AF7BE2D.96798FBC@sybase.com>...
>
>
>Geoff_Smith wrote:
>
>> If I want to increase the pagefile above 4800M I will need to find space
on
>> another drive (which wont be easy). If I do, are/or aren't there any
>> problems with this is respect to ASE. It seems there is a bit of descent
in
>> this area????
>>
>> Geoff
>
>The distribution of your paging files is invisible to ASE, only the total
size
>matters. I am the engineer directly responsible for this section of code so
if
>you find this is not true, let me know straight away! btw. I am running a
>number of NT systems with page files spread over 2 or more disks.
>
>cheers,
>tonyi
>--
>Tony Imbierski
>Sybase Engineering
>
>-- how much daylight did you save today? --
>
>


Tony Imbierski Posted on 2001-05-11 10:45:05.0Z
Message-ID: <3AFBC2B1.26308227@sybase.com>
Date: Fri, 11 May 2001 11:45:05 +0100
From: Tony Imbierski <tonyi@sybase.com>
X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: NT Memory Maximum
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com> <3AF06F8F.4B6D3AD6@bjc.org> <98716E1C9B057C7D0004FD1C85256A46.0075263385256A40@webforums> <6AD0C89D29B3CD6E0006023085256A46.00058BB285256A46@webforums> <3AF7BE2D.96798FBC@sybase.com> <Rq$F0PZ2AHA.302@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 157
NNTP-Posting-Host: aja.sybase.com 158.76.131.36
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:746
Article PK: 1087352

Sorry I didn't see this the first time. The following is long and took ages to
type in, so I hope it is worth it 8*) You may still just say 'huh' at the end
tho 8*)

The shared memory starting address is not a size of anything, it is the address
in our virtual address space where ASE starts mapping its shared memory.

Virtual address spaces on NT are always 4Gb in size (regardless of how much
physical memory the machine has). Addresses from 0 to 7FFFFFFF (hex) are
normally available to the application (in this case, ASE). Addresses from
80000000 to FFFFFFFF are reserved for the system. If you have enterprise NT with
the /3GB option, then the application is given from 0-BFFFFFFF and the system
gets C0000000-FFFFFFFF.

The way the application memory is split up is as follows. Starting at the bottom
and working upwards, the first few pages from 0-FFF hex are reserved and are
known as the guard pages. The main application code (in this case sqlsrvr.exe)
loads at 400000 (hex). Above and below this, shared libraries such as libct,
libsrv (connectivity) get loaded. Then somewhere on top of this lot you get
application private data areas. Once all this is loaded, we have a chunk of
address space free to create our shared memory.

By default we request shared memory starting at 20000000 (hex). This equals
536870912 and is probably the '500mb' you are referring to, but remember this
isn't a size, it's merely the starting address. Theoretically then the maximum
size of shared memory is the amount that can fit between 20000000 and 7FFFFFFF
(on a normal system) or 20000000 and BFFFFFFF on an enterprise NT system. Almost
but not quite, as NT stuffs some system dll's (kernel32.dll for example) right
at the top which restricts us slightly. Ignoring this for the moment, this
allows up to 5FFFFFFF bytes of shared memory or 9FFFFFFF on an enterprise
system. Convert these numbers to decimal and you get 1,610,612,735 or on the
enterprise system 2,684,354,559. Or about 1.5Gb (normal) / 2.5Gb (Enterprise).
(remember actually slightly less because of those system dlls taking up space at
the top).

Now the top end of the address space is a hard limit fixed by the OS. But we can
squeeze in more by lowering the place we start shared memory. This is the
purpose of the 'shared memory starting address'. The number you were given
(23662592) equates to 1691000 hex. This means the amount of shared memory we can
squeeze in becomes 7FFFFFFF-1691000 = 7E96EFFF hex or 2123821055 decimal or 1.9
Gb (except not quite that big because we can't go all the way up to 7fffffff
remember). Enterprise systems again get a gig more.

So where did we come up with the number 23662592? To be honest, probably trial
and error. The lower you make the shared memory starting address, the more
shared memory you can have, until you make it so low that it clashes with memory
already allocated for some other purpose. We actually cope with that situation
and increase the value internally until it reaches a clear space. However you
are then in a position where the server has absolutely no free space in its
virtual address range at all, which may lead to a memory allocation failure some
time down the line. You also have the problem that other applications such as
monitor server that want to map the shared memory may not be able to because
they themselves may not have that low area free. The 23662592 figure is probably
one that has been recommended many times by tech support and works.

As for the default, this was originally chosen to be a round number (in hex
anyway) that is way up in the address range that will never cause conflict with
other areas already in use. Remember this default was set when the server was
first ported to NT in what, 94? Nobody dreamed of PC systems with 4Gb physical
ram back then. It's probably about time the default was reviewed to a lower
value, I might make this suggestion internally.

I just thought of a good analogy for your managers. Imagine the total
application space is like Route 66. By default we start shared memory in Chicago
and end it in LA. Lowering the shared memory is like starting Route 66 in New
York - it gets longer. But move the start too far east and you end up trying to
build a road in the sea 8*)

HTH,
tonyi

Ray DiMarcello wrote:

> Tony or Jim, any comment on the following? I posted it earlier in this
> thread ... I'm referring to shared memory starting address here ...
>
> I believe the unit is bytes. 23662592 / 1048576 bytes per meg = 22.5 meg.
> 23662592 is the number recommended by Sybase (as they stated in an email to
> me once). But I have no idea why. Where'd you get that number? They say
> the default for that setting on NT is 500meg. There must be some, maybe
> negative, implications to changing it from 500 to 22.5. I can't just change
> it here in production without providing the higher-ups some detailed
> reasoning behind it other than, "see, I can set total memory higher." Until
> I get some more detail from them I'm stuck allocating 1.5 gig out of 3.5 to
> Sybase on our Compaq 8500R 700mhz 8-way.
>
> Anyone from Sybase want to weigh in? I've tried but cannot find any good
> whitepapers, etc. on this topic.
>
> Tony Imbierski wrote in message <3AF7BE2D.96798FBC@sybase.com>...
> >
> >
> >Geoff_Smith wrote:
> >
> >> If I want to increase the pagefile above 4800M I will need to find space
> on
> >> another drive (which wont be easy). If I do, are/or aren't there any
> >> problems with this is respect to ASE. It seems there is a bit of descent
> in
> >> this area????
> >>
> >> Geoff
> >
> >The distribution of your paging files is invisible to ASE, only the total
> size
> >matters. I am the engineer directly responsible for this section of code so
> if
> >you find this is not true, let me know straight away! btw. I am running a
> >number of NT systems with page files spread over 2 or more disks.
> >
> >cheers,
> >tonyi
> >--
> >Tony Imbierski
> >Sybase Engineering
> >
> >-- how much daylight did you save today? --
> >
> >

--
Tony Imbierski
Sybase Engineering

-- how much daylight did you save today? --


Jay Kwon Posted on 2001-05-16 20:39:38.0Z
From: "Jay Kwon" <jkwon@macgreg.ws>
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com> <3AF06F8F.4B6D3AD6@bjc.org> <98716E1C9B057C7D0004FD1C85256A46.0075263385256A40@webforums> <6AD0C89D29B3CD6E0006023085256A46.00058BB285256A46@webforums> <3AF7BE2D.96798FBC@sybase.com> <Rq$F0PZ2AHA.302@forums.sybase.com> <3AFBC2B1.26308227@sybase.com>
Subject: Re: NT Memory Maximum
Date: Wed, 16 May 2001 16:39:38 -0400
Lines: 189
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <uw1V0rk3AHA.261@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: host224.merrin.com 206.0.17.224
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:730
Article PK: 1087337

My head hurts!

j

"Tony Imbierski" <tonyi@sybase.com> wrote in message
news:3AFBC2B1.26308227@sybase.com...
> Sorry I didn't see this the first time. The following is long and took
ages to
> type in, so I hope it is worth it 8*) You may still just say 'huh' at the
end
> tho 8*)
>
> The shared memory starting address is not a size of anything, it is the
address
> in our virtual address space where ASE starts mapping its shared memory.
>
> Virtual address spaces on NT are always 4Gb in size (regardless of how
much
> physical memory the machine has). Addresses from 0 to 7FFFFFFF (hex) are
> normally available to the application (in this case, ASE). Addresses from
> 80000000 to FFFFFFFF are reserved for the system. If you have enterprise
NT with
> the /3GB option, then the application is given from 0-BFFFFFFF and the
system
> gets C0000000-FFFFFFFF.
>
> The way the application memory is split up is as follows. Starting at the
bottom
> and working upwards, the first few pages from 0-FFF hex are reserved and
are
> known as the guard pages. The main application code (in this case
sqlsrvr.exe)
> loads at 400000 (hex). Above and below this, shared libraries such as
libct,
> libsrv (connectivity) get loaded. Then somewhere on top of this lot you
get
> application private data areas. Once all this is loaded, we have a chunk
of
> address space free to create our shared memory.
>
> By default we request shared memory starting at 20000000 (hex). This
equals
> 536870912 and is probably the '500mb' you are referring to, but remember
this
> isn't a size, it's merely the starting address. Theoretically then the
maximum
> size of shared memory is the amount that can fit between 20000000 and
7FFFFFFF
> (on a normal system) or 20000000 and BFFFFFFF on an enterprise NT system.
Almost
> but not quite, as NT stuffs some system dll's (kernel32.dll for example)
right
> at the top which restricts us slightly. Ignoring this for the moment, this
> allows up to 5FFFFFFF bytes of shared memory or 9FFFFFFF on an enterprise
> system. Convert these numbers to decimal and you get 1,610,612,735 or on
the
> enterprise system 2,684,354,559. Or about 1.5Gb (normal) / 2.5Gb
(Enterprise).
> (remember actually slightly less because of those system dlls taking up
space at
> the top).
>
> Now the top end of the address space is a hard limit fixed by the OS. But
we can
> squeeze in more by lowering the place we start shared memory. This is the
> purpose of the 'shared memory starting address'. The number you were given
> (23662592) equates to 1691000 hex. This means the amount of shared memory
we can
> squeeze in becomes 7FFFFFFF-1691000 = 7E96EFFF hex or 2123821055 decimal
or 1.9
> Gb (except not quite that big because we can't go all the way up to
7fffffff
> remember). Enterprise systems again get a gig more.
>
> So where did we come up with the number 23662592? To be honest, probably
trial
> and error. The lower you make the shared memory starting address, the more
> shared memory you can have, until you make it so low that it clashes with
memory
> already allocated for some other purpose. We actually cope with that
situation
> and increase the value internally until it reaches a clear space. However
you
> are then in a position where the server has absolutely no free space in
its
> virtual address range at all, which may lead to a memory allocation
failure some
> time down the line. You also have the problem that other applications such
as
> monitor server that want to map the shared memory may not be able to
because
> they themselves may not have that low area free. The 23662592 figure is
probably
> one that has been recommended many times by tech support and works.
>
> As for the default, this was originally chosen to be a round number (in
hex
> anyway) that is way up in the address range that will never cause conflict
with
> other areas already in use. Remember this default was set when the server
was
> first ported to NT in what, 94? Nobody dreamed of PC systems with 4Gb
physical
> ram back then. It's probably about time the default was reviewed to a
lower
> value, I might make this suggestion internally.
>
> I just thought of a good analogy for your managers. Imagine the total
> application space is like Route 66. By default we start shared memory in
Chicago
> and end it in LA. Lowering the shared memory is like starting Route 66 in
New
> York - it gets longer. But move the start too far east and you end up
trying to
> build a road in the sea 8*)
>
> HTH,
> tonyi
>
> Ray DiMarcello wrote:
>
> > Tony or Jim, any comment on the following? I posted it earlier in this
> > thread ... I'm referring to shared memory starting address here ...
> >
> > I believe the unit is bytes. 23662592 / 1048576 bytes per meg = 22.5
meg.
> > 23662592 is the number recommended by Sybase (as they stated in an email
to
> > me once). But I have no idea why. Where'd you get that number? They
say
> > the default for that setting on NT is 500meg. There must be some, maybe
> > negative, implications to changing it from 500 to 22.5. I can't just
change
> > it here in production without providing the higher-ups some detailed
> > reasoning behind it other than, "see, I can set total memory higher."
Until
> > I get some more detail from them I'm stuck allocating 1.5 gig out of 3.5
to
> > Sybase on our Compaq 8500R 700mhz 8-way.
> >
> > Anyone from Sybase want to weigh in? I've tried but cannot find any
good
> > whitepapers, etc. on this topic.
> >
> > Tony Imbierski wrote in message <3AF7BE2D.96798FBC@sybase.com>...
> > >
> > >
> > >Geoff_Smith wrote:
> > >
> > >> If I want to increase the pagefile above 4800M I will need to find
space
> > on
> > >> another drive (which wont be easy). If I do, are/or aren't there any
> > >> problems with this is respect to ASE. It seems there is a bit of
descent
> > in
> > >> this area????
> > >>
> > >> Geoff
> > >
> > >The distribution of your paging files is invisible to ASE, only the
total
> > size
> > >matters. I am the engineer directly responsible for this section of
code so
> > if
> > >you find this is not true, let me know straight away! btw. I am running
a
> > >number of NT systems with page files spread over 2 or more disks.
> > >
> > >cheers,
> > >tonyi
> > >--
> > >Tony Imbierski
> > >Sybase Engineering
> > >
> > >-- how much daylight did you save today? --
> > >
> > >
>
> --
> Tony Imbierski
> Sybase Engineering
>
> -- how much daylight did you save today? --
>
>


Ray DiMarcello Posted on 2001-05-11 21:06:28.0Z
From: "Ray DiMarcello" <rdimarcello@ingva.com>
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com> <3AF06F8F.4B6D3AD6@bjc.org> <98716E1C9B057C7D0004FD1C85256A46.0075263385256A40@webforums> <6AD0C89D29B3CD6E0006023085256A46.00058BB285256A46@webforums> <3AF7BE2D.96798FBC@sybase.com> <Rq$F0PZ2AHA.302@forums.sybase.com> <3AFBC2B1.26308227@sybase.com>
Subject: Re: NT Memory Maximum
Date: Fri, 11 May 2001 17:06:28 -0400
Lines: 197
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <xrWmbEm2AHA.254@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 207.245.124.67
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:742
Article PK: 1087348

Thanks for the great post and your time ... one concern I have is that I
have read the following ...

"Each user connection is an NT fiber, and these NT fibers can run on any of
the DBMS engines. For Adaptive Server on NT the total memory parameter does
not include the memory for DBMS task (or NT fiber) program stacks, as it
does for UNIX versions of this product, because each fiber is assigned a
program stack by NT. For like amounts of physical memory, the total memory
configured for a Sybase ASE NT server needs to be less than that for an ASE
for UNIX server. "

This implies there has to be space outside of the total memory setting for
each user connection. In the memory map you've drawn in your post, where do
these NT fiber stacks live? If I move the memory starting address, am I
clobbering that space?

RD

Tony Imbierski wrote in message <3AFBC2B1.26308227@sybase.com>...
>Sorry I didn't see this the first time. The following is long and took ages
to
>type in, so I hope it is worth it 8*) You may still just say 'huh' at the
end
>tho 8*)
>
>The shared memory starting address is not a size of anything, it is the
address
>in our virtual address space where ASE starts mapping its shared memory.
>
>Virtual address spaces on NT are always 4Gb in size (regardless of how much
>physical memory the machine has). Addresses from 0 to 7FFFFFFF (hex) are
>normally available to the application (in this case, ASE). Addresses from
>80000000 to FFFFFFFF are reserved for the system. If you have enterprise NT
with
>the /3GB option, then the application is given from 0-BFFFFFFF and the
system
>gets C0000000-FFFFFFFF.
>
>The way the application memory is split up is as follows. Starting at the
bottom
>and working upwards, the first few pages from 0-FFF hex are reserved and
are
>known as the guard pages. The main application code (in this case
sqlsrvr.exe)
>loads at 400000 (hex). Above and below this, shared libraries such as
libct,
>libsrv (connectivity) get loaded. Then somewhere on top of this lot you get
>application private data areas. Once all this is loaded, we have a chunk of
>address space free to create our shared memory.
>
>By default we request shared memory starting at 20000000 (hex). This equals
>536870912 and is probably the '500mb' you are referring to, but remember
this
>isn't a size, it's merely the starting address. Theoretically then the
maximum
>size of shared memory is the amount that can fit between 20000000 and
7FFFFFFF
>(on a normal system) or 20000000 and BFFFFFFF on an enterprise NT system.
Almost
>but not quite, as NT stuffs some system dll's (kernel32.dll for example)
right
>at the top which restricts us slightly. Ignoring this for the moment, this
>allows up to 5FFFFFFF bytes of shared memory or 9FFFFFFF on an enterprise
>system. Convert these numbers to decimal and you get 1,610,612,735 or on
the
>enterprise system 2,684,354,559. Or about 1.5Gb (normal) / 2.5Gb
(Enterprise).
>(remember actually slightly less because of those system dlls taking up
space at
>the top).
>
>Now the top end of the address space is a hard limit fixed by the OS. But
we can
>squeeze in more by lowering the place we start shared memory. This is the
>purpose of the 'shared memory starting address'. The number you were given
>(23662592) equates to 1691000 hex. This means the amount of shared memory
we can
>squeeze in becomes 7FFFFFFF-1691000 = 7E96EFFF hex or 2123821055 decimal or
1.9
>Gb (except not quite that big because we can't go all the way up to
7fffffff
>remember). Enterprise systems again get a gig more.
>
>So where did we come up with the number 23662592? To be honest, probably
trial
>and error. The lower you make the shared memory starting address, the more
>shared memory you can have, until you make it so low that it clashes with
memory
>already allocated for some other purpose. We actually cope with that
situation
>and increase the value internally until it reaches a clear space. However
you
>are then in a position where the server has absolutely no free space in its
>virtual address range at all, which may lead to a memory allocation failure
some
>time down the line. You also have the problem that other applications such
as
>monitor server that want to map the shared memory may not be able to
because
>they themselves may not have that low area free. The 23662592 figure is
probably
>one that has been recommended many times by tech support and works.
>
>As for the default, this was originally chosen to be a round number (in hex
>anyway) that is way up in the address range that will never cause conflict
with
>other areas already in use. Remember this default was set when the server
was
>first ported to NT in what, 94? Nobody dreamed of PC systems with 4Gb
physical
>ram back then. It's probably about time the default was reviewed to a lower
>value, I might make this suggestion internally.
>
>I just thought of a good analogy for your managers. Imagine the total
>application space is like Route 66. By default we start shared memory in
Chicago
>and end it in LA. Lowering the shared memory is like starting Route 66 in
New
>York - it gets longer. But move the start too far east and you end up
trying to
>build a road in the sea 8*)
>
>HTH,
>tonyi
>
>Ray DiMarcello wrote:
>
>> Tony or Jim, any comment on the following? I posted it earlier in this
>> thread ... I'm referring to shared memory starting address here ...
>>
>> I believe the unit is bytes. 23662592 / 1048576 bytes per meg = 22.5
meg.
>> 23662592 is the number recommended by Sybase (as they stated in an email
to
>> me once). But I have no idea why. Where'd you get that number? They
say
>> the default for that setting on NT is 500meg. There must be some, maybe
>> negative, implications to changing it from 500 to 22.5. I can't just
change
>> it here in production without providing the higher-ups some detailed
>> reasoning behind it other than, "see, I can set total memory higher."
Until
>> I get some more detail from them I'm stuck allocating 1.5 gig out of 3.5
to
>> Sybase on our Compaq 8500R 700mhz 8-way.
>>
>> Anyone from Sybase want to weigh in? I've tried but cannot find any good
>> whitepapers, etc. on this topic.
>>
>> Tony Imbierski wrote in message <3AF7BE2D.96798FBC@sybase.com>...
>> >
>> >
>> >Geoff_Smith wrote:
>> >
>> >> If I want to increase the pagefile above 4800M I will need to find
space
>> on
>> >> another drive (which wont be easy). If I do, are/or aren't there any
>> >> problems with this is respect to ASE. It seems there is a bit of
descent
>> in
>> >> this area????
>> >>
>> >> Geoff
>> >
>> >The distribution of your paging files is invisible to ASE, only the
total
>> size
>> >matters. I am the engineer directly responsible for this section of code
so
>> if
>> >you find this is not true, let me know straight away! btw. I am running
a
>> >number of NT systems with page files spread over 2 or more disks.
>> >
>> >cheers,
>> >tonyi
>> >--
>> >Tony Imbierski
>> >Sybase Engineering
>> >
>> >-- how much daylight did you save today? --
>> >
>> >
>
>--
>Tony Imbierski
>Sybase Engineering
>
>-- how much daylight did you save today? --
>
>


Tony Imbierski Posted on 2001-05-15 21:26:55.0Z
Message-ID: <3B019F1F.97EFE8EF@sybase.com>
Date: Tue, 15 May 2001 22:26:55 +0100
From: Tony Imbierski <tonyi@sybase.com>
X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: NT Memory Maximum
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com> <3AF06F8F.4B6D3AD6@bjc.org> <98716E1C9B057C7D0004FD1C85256A46.0075263385256A40@webforums> <6AD0C89D29B3CD6E0006023085256A46.00058BB285256A46@webforums> <3AF7BE2D.96798FBC@sybase.com> <Rq$F0PZ2AHA.302@forums.sybase.com> <3AFBC2B1.26308227@sybase.com> <xrWmbEm2AHA.254@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 227
NNTP-Posting-Host: aja.sybase.com 158.76.131.36
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:738
Article PK: 1087345

Well you can't 'clobber' any stacks that already exist, NT just wouldn't allow
us to map over va's already in use. But if you totally fill virtual memory
there's a chance there will be nowhere left to allocate stacks for new fibers.
I've never actually tried pushing shared memory down as low as it would go, I
might take a look to see what happens. NT does appear to reserve a certain
amount of space for the stacks but of course it can't possibly know in advance
how many we are going to create. The stacks get put at the top end of the lowest
portion of memory, above all the code, dll's and static and initialised data
areas, and also leaving a certain amount of heap space. Each new stack gets
allocated at higher addresses according to the total size we say the stack can
be, from where it grows downwards towards the previous fiber's stack. If it ever
meets the previous fibers stack of course we get stack overflow. Memory only
gets committed to the stacks on demand, the space is merely 'reserved' to begin
with. I haven't ever seen the case where we allocate the memory immediately
above the topmost stack. That would imply creation of a new fiber would fail,
but I need to test this.

cheers,
tonyi

Ray DiMarcello wrote:

> Thanks for the great post and your time ... one concern I have is that I
> have read the following ...
>
> "Each user connection is an NT fiber, and these NT fibers can run on any of
> the DBMS engines. For Adaptive Server on NT the total memory parameter does
> not include the memory for DBMS task (or NT fiber) program stacks, as it
> does for UNIX versions of this product, because each fiber is assigned a
> program stack by NT. For like amounts of physical memory, the total memory
> configured for a Sybase ASE NT server needs to be less than that for an ASE
> for UNIX server. "
>
> This implies there has to be space outside of the total memory setting for
> each user connection. In the memory map you've drawn in your post, where do
> these NT fiber stacks live? If I move the memory starting address, am I
> clobbering that space?
>
> RD
>
> Tony Imbierski wrote in message <3AFBC2B1.26308227@sybase.com>...
> >Sorry I didn't see this the first time. The following is long and took ages
> to
> >type in, so I hope it is worth it 8*) You may still just say 'huh' at the
> end
> >tho 8*)
> >
> >The shared memory starting address is not a size of anything, it is the
> address
> >in our virtual address space where ASE starts mapping its shared memory.
> >
> >Virtual address spaces on NT are always 4Gb in size (regardless of how much
> >physical memory the machine has). Addresses from 0 to 7FFFFFFF (hex) are
> >normally available to the application (in this case, ASE). Addresses from
> >80000000 to FFFFFFFF are reserved for the system. If you have enterprise NT
> with
> >the /3GB option, then the application is given from 0-BFFFFFFF and the
> system
> >gets C0000000-FFFFFFFF.
> >
> >The way the application memory is split up is as follows. Starting at the
> bottom
> >and working upwards, the first few pages from 0-FFF hex are reserved and
> are
> >known as the guard pages. The main application code (in this case
> sqlsrvr.exe)
> >loads at 400000 (hex). Above and below this, shared libraries such as
> libct,
> >libsrv (connectivity) get loaded. Then somewhere on top of this lot you get
> >application private data areas. Once all this is loaded, we have a chunk of
> >address space free to create our shared memory.
> >
> >By default we request shared memory starting at 20000000 (hex). This equals
> >536870912 and is probably the '500mb' you are referring to, but remember
> this
> >isn't a size, it's merely the starting address. Theoretically then the
> maximum
> >size of shared memory is the amount that can fit between 20000000 and
> 7FFFFFFF
> >(on a normal system) or 20000000 and BFFFFFFF on an enterprise NT system.
> Almost
> >but not quite, as NT stuffs some system dll's (kernel32.dll for example)
> right
> >at the top which restricts us slightly. Ignoring this for the moment, this
> >allows up to 5FFFFFFF bytes of shared memory or 9FFFFFFF on an enterprise
> >system. Convert these numbers to decimal and you get 1,610,612,735 or on
> the
> >enterprise system 2,684,354,559. Or about 1.5Gb (normal) / 2.5Gb
> (Enterprise).
> >(remember actually slightly less because of those system dlls taking up
> space at
> >the top).
> >
> >Now the top end of the address space is a hard limit fixed by the OS. But
> we can
> >squeeze in more by lowering the place we start shared memory. This is the
> >purpose of the 'shared memory starting address'. The number you were given
> >(23662592) equates to 1691000 hex. This means the amount of shared memory
> we can
> >squeeze in becomes 7FFFFFFF-1691000 = 7E96EFFF hex or 2123821055 decimal or
> 1.9
> >Gb (except not quite that big because we can't go all the way up to
> 7fffffff
> >remember). Enterprise systems again get a gig more.
> >
> >So where did we come up with the number 23662592? To be honest, probably
> trial
> >and error. The lower you make the shared memory starting address, the more
> >shared memory you can have, until you make it so low that it clashes with
> memory
> >already allocated for some other purpose. We actually cope with that
> situation
> >and increase the value internally until it reaches a clear space. However
> you
> >are then in a position where the server has absolutely no free space in its
> >virtual address range at all, which may lead to a memory allocation failure
> some
> >time down the line. You also have the problem that other applications such
> as
> >monitor server that want to map the shared memory may not be able to
> because
> >they themselves may not have that low area free. The 23662592 figure is
> probably
> >one that has been recommended many times by tech support and works.
> >
> >As for the default, this was originally chosen to be a round number (in hex
> >anyway) that is way up in the address range that will never cause conflict
> with
> >other areas already in use. Remember this default was set when the server
> was
> >first ported to NT in what, 94? Nobody dreamed of PC systems with 4Gb
> physical
> >ram back then. It's probably about time the default was reviewed to a lower
> >value, I might make this suggestion internally.
> >
> >I just thought of a good analogy for your managers. Imagine the total
> >application space is like Route 66. By default we start shared memory in
> Chicago
> >and end it in LA. Lowering the shared memory is like starting Route 66 in
> New
> >York - it gets longer. But move the start too far east and you end up
> trying to
> >build a road in the sea 8*)
> >
> >HTH,
> >tonyi
> >
> >Ray DiMarcello wrote:
> >
> >> Tony or Jim, any comment on the following? I posted it earlier in this
> >> thread ... I'm referring to shared memory starting address here ...
> >>
> >> I believe the unit is bytes. 23662592 / 1048576 bytes per meg = 22.5
> meg.
> >> 23662592 is the number recommended by Sybase (as they stated in an email
> to
> >> me once). But I have no idea why. Where'd you get that number? They
> say
> >> the default for that setting on NT is 500meg. There must be some, maybe
> >> negative, implications to changing it from 500 to 22.5. I can't just
> change
> >> it here in production without providing the higher-ups some detailed
> >> reasoning behind it other than, "see, I can set total memory higher."
> Until
> >> I get some more detail from them I'm stuck allocating 1.5 gig out of 3.5
> to
> >> Sybase on our Compaq 8500R 700mhz 8-way.
> >>
> >> Anyone from Sybase want to weigh in? I've tried but cannot find any good
> >> whitepapers, etc. on this topic.
> >>
> >> Tony Imbierski wrote in message <3AF7BE2D.96798FBC@sybase.com>...
> >> >
> >> >
> >> >Geoff_Smith wrote:
> >> >
> >> >> If I want to increase the pagefile above 4800M I will need to find
> space
> >> on
> >> >> another drive (which wont be easy). If I do, are/or aren't there any
> >> >> problems with this is respect to ASE. It seems there is a bit of
> descent
> >> in
> >> >> this area????
> >> >>
> >> >> Geoff
> >> >
> >> >The distribution of your paging files is invisible to ASE, only the
> total
> >> size
> >> >matters. I am the engineer directly responsible for this section of code
> so
> >> if
> >> >you find this is not true, let me know straight away! btw. I am running
> a
> >> >number of NT systems with page files spread over 2 or more disks.
> >> >
> >> >cheers,
> >> >tonyi
> >> >--
> >> >Tony Imbierski
> >> >Sybase Engineering
> >> >
> >> >-- how much daylight did you save today? --
> >> >
> >> >
> >
> >--
> >Tony Imbierski
> >Sybase Engineering
> >
> >-- how much daylight did you save today? --
> >
> >

--
Tony Imbierski
Sybase Engineering

-- how much daylight did you save today? --


Jim Egan Posted on 2001-05-11 20:36:39.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: NT Memory Maximum
Date: Fri, 11 May 2001 14:36:39 -0600
Message-ID: <MPG.1565fb3b19d7909a98b358@forums.sybase.com>
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com> <3AF06F8F.4B6D3AD6@bjc.org> <98716E1C9B057C7D0004FD1C85256A46.0075263385256A40@webforums> <6AD0C89D29B3CD6E0006023085256A46.00058BB285256A46@webforums> <3AF7BE2D.96798FBC@sybase.com> <Rq$F0PZ2AHA.302@forums.sybase.com> <3AFBC2B1.26308227@sybase.com>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.50
Newsgroups: sybase.public.sqlserver.nt
Lines: 5
NNTP-Posting-Host: jpe650.sybase.com 157.133.56.39
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:744
Article PK: 1087350

Excellent explanation!!
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Get your free subscription to PowerTimes at http://www.powertimes.com


Ray DiMarcello Posted on 2001-05-11 20:33:14.0Z
From: "Ray DiMarcello" <rdimarcello@ingva.com>
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com> <3AF06F8F.4B6D3AD6@bjc.org> <98716E1C9B057C7D0004FD1C85256A46.0075263385256A40@webforums> <6AD0C89D29B3CD6E0006023085256A46.00058BB285256A46@webforums> <3AF7BE2D.96798FBC@sybase.com> <Rq$F0PZ2AHA.302@forums.sybase.com> <3AFBC2B1.26308227@sybase.com>
Subject: Re: NT Memory Maximum
Date: Fri, 11 May 2001 16:33:14 -0400
Lines: 7
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <QLX71xl2AHA.261@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 207.245.124.67
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:743
Article PK: 1087351

thanks ... much appreciated.

RD


Jim Egan Posted on 2001-05-11 02:04:40.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: NT Memory Maximum
Date: Thu, 10 May 2001 20:04:40 -0600
Message-ID: <MPG.1564f6a3f7a5606f98b342@forums.sybase.com>
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com> <3AF06F8F.4B6D3AD6@bjc.org> <98716E1C9B057C7D0004FD1C85256A46.0075263385256A40@webforums> <6AD0C89D29B3CD6E0006023085256A46.00058BB285256A46@webforums> <3AF7BE2D.96798FBC@sybase.com> <Rq$F0PZ2AHA.302@forums.sybase.com>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.50
Newsgroups: sybase.public.sqlserver.nt
Lines: 7
NNTP-Posting-Host: c1420400-b.hiland1.co.home.com 65.7.153.228
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:753
Article PK: 1087360

I have a vague understanding but not enough to provide an explanation that you won't just
say "Huh?" to.

--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Get your free subscription to PowerTimes at http://www.powertimes.com


Jay Kwon Posted on 2001-05-02 20:31:23.0Z
From: "Jay Kwon" <jkwon@macgreg.ws>
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com>
Subject: Re: NT Memory Maximum
Date: Wed, 2 May 2001 16:31:23 -0400
Lines: 68
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <Lvvell00AHA.256@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: host132.merrin.com 206.0.17.132
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:826
Article PK: 1087433

no the person I'd talked to didn't think it made any sense but what can I
say. It fixed my problem. But it'd really be nice if someone over at
Sybase could test & confirm.

Jay Kwon
Macgregor

"Ray DiMarcello" <rdimarcello@ingva.com> wrote in message
news:HH6wmQ00AHA.178@forums.sybase.com...
> Did Sybase TS confirm that the ASE server only recognizes the first
instance
> of the swap file? That sounds strange.
>
> Dean, did you change the "shared memory starting address" using
sp_configure
> ??
>
> RD
>
>
>
> Jay Kwon wrote in message ...
> >I had a similar issue on ASE1192 on NT. Problem I had was that my paging
> >file was spread out across multiple discs (for perf reasons) but ASE only
> >recognized paging file on my first disc only. I think I had about 1GB on
> C:
> >then 3GB's each on 2 other discs but I kept getting shared memory msg
until
> >I increased my paging file on my first drive. Keep increasing paging
file
> >(or first instance of swap file I should say) to about 2:1/Page file to
ASE
> >memory ratio. Hope that helps.
> >
> >Jay Kwon
> >MacGregor
> >
> >"Justin Largent" <jlargent@bjc.org> wrote in message
> >news:3AEF2F35.890FD227@bjc.org...
> >> I have a Compaq Proliant 6400R, 4 CPU, 4GB RAM machine. I have NT
> >> Enterprise 4.0 with SP4 installed AND have the 4GT option enabled. I
> >> have installed ASE 11.9.2 with EBF8613. I have a paging file size of
> >> 267MB.
> >>
> >> Can someone please tell me why the maximum amount of memory I can put
in
> >> for "total memory" is about 1292000 pages (~2523MB)? I have tried
> >> 1390000, 1300000, 1295000. and 1290000 in hopes of maximizing my memory
> >> use. 1290000 worked, and 1292000 worked, but why can I not get any
> >> higher!!!!!!?????
> >>
> >> I realize NT is supposed to get 1GB. WHY CANNOT I NOT GET SYBASE
HIGHER
> >> THAN 2.5GB ROUGHLY?
> >>
> >> Thanks in advance,
> >>
> >> Dean Furness
> >> Quilogy
> >> dfurness@quilogy.com
> >>
> >
> >
>
>


Tony Imbierski Posted on 2001-05-03 10:09:56.0Z
Message-ID: <3AF12E74.C6624CA5@sybase.com>
Date: Thu, 03 May 2001 11:09:56 +0100
From: Tony Imbierski <tonyi@sybase.com>
X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: NT Memory Maximum
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com> <Lvvell00AHA.256@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 76
NNTP-Posting-Host: aja.sybase.com 158.76.131.36
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:818
Article PK: 1087425

I can confirm that there is NO WAY that ASE even *knows* where your pagefiles
are stored, and whether they are in one big file or spread across multiple
disks. Only the operating system cares about that. ASE simply maps a chunk of
memory and requests that NT back it up with pagefile storage. If the total free
space in all your pagefiles is less than we ask for, we get a fail status back
from NT and we fail to startup.

There *must* have been something else you did that fixed this at the time. For
example, simply rebooting the system will clean out all other apps that are
using the pagefile, so when the system comes back up there would be more
pagefile free than before the reboot.

cheers, HTH

tonyi (ASE Engineering, NT kernel specialist)

Jay Kwon wrote:

> no the person I'd talked to didn't think it made any sense but what can I
> say. It fixed my problem. But it'd really be nice if someone over at
> Sybase could test & confirm.
>
> Jay Kwon
> Macgregor
>
> "Ray DiMarcello" <rdimarcello@ingva.com> wrote in message
> news:HH6wmQ00AHA.178@forums.sybase.com...
> > Did Sybase TS confirm that the ASE server only recognizes the first
> instance
> > of the swap file? That sounds strange.
> >
> > Dean, did you change the "shared memory starting address" using
> sp_configure
> > ??
> >
> > RD
> >
> >
> >
> > Jay Kwon wrote in message ...
> > >I had a similar issue on ASE1192 on NT. Problem I had was that my paging
> > >file was spread out across multiple discs (for perf reasons) but ASE only
> > >recognized paging file on my first disc only. I think I had about 1GB on
> > C:
> > >then 3GB's each on 2 other discs but I kept getting shared memory msg
> until
> > >I increased my paging file on my first drive. Keep increasing paging
> file
> > >(or first instance of swap file I should say) to about 2:1/Page file to
> ASE
> > >memory ratio. Hope that helps.
> > >
> > >Jay Kwon
> > >MacGregor
> > >
> > >"Justin Largent" <jlargent@bjc.org> wrote in message
> > >news:3AEF2F35.890FD227@bjc.org...
> > >> I have a Compaq Proliant 6400R, 4 CPU, 4GB RAM machine. I have NT
> > >> Enterprise 4.0 with SP4 installed AND have the 4GT option enabled. I
> > >> have installed ASE 11.9.2 with EBF8613. I have a paging file size of
> > >> 267MB.
> > >>
> > >> Can someone please tell me why the maximum amount of memory I can put
> in
> > >> for "total memory" is about 1292000 pages (~2523MB)? I have tried
> > >> 1390000, 1300000, 1295000. and 1290000 in hopes of maximizing my memory
> > >> use. 1290000 worked, and 1292000 worked, but why can I not get any
> > >> higher!!!!!!?????
> > >>
> > >> I realize NT is supposed to get 1GB. WHY CANNOT I NOT GET SYBASE
> HIGHER
> > >> THAN 2.5GB ROUGHLY?
> > >>
> > >> Thanks in advance,
> > >>
> > >> Dean Furness
> > >> Quilogy
> > >> dfurness@quilogy.com
> > >>
> > >
> > >
> >
> >

--
Tony Imbierski
Sybase Engineering

-- how much daylight did you save today? --


Jay Kwon Posted on 2001-05-03 18:27:22.0Z
From: "Jay Kwon" <jkwon@macgreg.ws>
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com> <Lvvell00AHA.256@forums.sybase.com> <3AF12E74.C6624CA5@sybase.com>
Subject: Re: NT Memory Maximum
Date: Thu, 3 May 2001 14:27:22 -0400
Lines: 117
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <JHgGAFA1AHA.160@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: host132.merrin.com 206.0.17.132
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:812
Article PK: 1087418

Thanks. But based on my numerous attempts at fixing this problem at my
client site who had this problem this was the only workaround. I can
actually replicate this problem at will. I thought it was strange too.

Jay Kwon
MacGregor

"Tony Imbierski" <tonyi@sybase.com> wrote in message
news:3AF12E74.C6624CA5@sybase.com...
> I can confirm that there is NO WAY that ASE even *knows* where your
pagefiles
> are stored, and whether they are in one big file or spread across multiple
> disks. Only the operating system cares about that. ASE simply maps a chunk
of
> memory and requests that NT back it up with pagefile storage. If the total
free
> space in all your pagefiles is less than we ask for, we get a fail status
back
> from NT and we fail to startup.
>
> There *must* have been something else you did that fixed this at the time.
For
> example, simply rebooting the system will clean out all other apps that
are
> using the pagefile, so when the system comes back up there would be more
> pagefile free than before the reboot.
>
> cheers, HTH
>
> tonyi (ASE Engineering, NT kernel specialist)
>
> Jay Kwon wrote:
>
> > no the person I'd talked to didn't think it made any sense but what can
I
> > say. It fixed my problem. But it'd really be nice if someone over at
> > Sybase could test & confirm.
> >
> > Jay Kwon
> > Macgregor
> >
> > "Ray DiMarcello" <rdimarcello@ingva.com> wrote in message
> > news:HH6wmQ00AHA.178@forums.sybase.com...
> > > Did Sybase TS confirm that the ASE server only recognizes the first
> > instance
> > > of the swap file? That sounds strange.
> > >
> > > Dean, did you change the "shared memory starting address" using
> > sp_configure
> > > ??
> > >
> > > RD
> > >
> > >
> > >
> > > Jay Kwon wrote in message ...
> > > >I had a similar issue on ASE1192 on NT. Problem I had was that my
paging
> > > >file was spread out across multiple discs (for perf reasons) but ASE
only
> > > >recognized paging file on my first disc only. I think I had about
1GB on
> > > C:
> > > >then 3GB's each on 2 other discs but I kept getting shared memory msg
> > until
> > > >I increased my paging file on my first drive. Keep increasing paging
> > file
> > > >(or first instance of swap file I should say) to about 2:1/Page file
to
> > ASE
> > > >memory ratio. Hope that helps.
> > > >
> > > >Jay Kwon
> > > >MacGregor
> > > >
> > > >"Justin Largent" <jlargent@bjc.org> wrote in message
> > > >news:3AEF2F35.890FD227@bjc.org...
> > > >> I have a Compaq Proliant 6400R, 4 CPU, 4GB RAM machine. I have NT
> > > >> Enterprise 4.0 with SP4 installed AND have the 4GT option enabled.
I
> > > >> have installed ASE 11.9.2 with EBF8613. I have a paging file size
of
> > > >> 267MB.
> > > >>
> > > >> Can someone please tell me why the maximum amount of memory I can
put
> > in
> > > >> for "total memory" is about 1292000 pages (~2523MB)? I have tried
> > > >> 1390000, 1300000, 1295000. and 1290000 in hopes of maximizing my
memory
> > > >> use. 1290000 worked, and 1292000 worked, but why can I not get any
> > > >> higher!!!!!!?????
> > > >>
> > > >> I realize NT is supposed to get 1GB. WHY CANNOT I NOT GET SYBASE
> > HIGHER
> > > >> THAN 2.5GB ROUGHLY?
> > > >>
> > > >> Thanks in advance,
> > > >>
> > > >> Dean Furness
> > > >> Quilogy
> > > >> dfurness@quilogy.com
> > > >>
> > > >
> > > >
> > >
> > >
>
> --
> Tony Imbierski
> Sybase Engineering
>
> -- how much daylight did you save today? --
>
>


Tony Imbierski Posted on 2001-05-04 09:35:39.0Z
Message-ID: <3AF277EB.D2BE8DD9@sybase.com>
Date: Fri, 04 May 2001 10:35:39 +0100
From: Tony Imbierski <tonyi@sybase.com>
X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: NT Memory Maximum
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com> <Lvvell00AHA.256@forums.sybase.com> <3AF12E74.C6624CA5@sybase.com> <JHgGAFA1AHA.160@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 101
NNTP-Posting-Host: aja.sybase.com 158.76.131.36
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:805
Article PK: 1087412

Hi Jay,

If you open a case with tech support and supply exact steps for the repro, I
will gladly investigate this.

cheers,
tonyi

Jay Kwon wrote:

> Thanks. But based on my numerous attempts at fixing this problem at my
> client site who had this problem this was the only workaround. I can
> actually replicate this problem at will. I thought it was strange too.
>
> Jay Kwon
> MacGregor
>
> "Tony Imbierski" <tonyi@sybase.com> wrote in message
> news:3AF12E74.C6624CA5@sybase.com...
> > I can confirm that there is NO WAY that ASE even *knows* where your
> pagefiles
> > are stored, and whether they are in one big file or spread across multiple
> > disks. Only the operating system cares about that. ASE simply maps a chunk
> of
> > memory and requests that NT back it up with pagefile storage. If the total
> free
> > space in all your pagefiles is less than we ask for, we get a fail status
> back
> > from NT and we fail to startup.
> >
> > There *must* have been something else you did that fixed this at the time.
> For
> > example, simply rebooting the system will clean out all other apps that
> are
> > using the pagefile, so when the system comes back up there would be more
> > pagefile free than before the reboot.
> >
> > cheers, HTH
> >
> > tonyi (ASE Engineering, NT kernel specialist)
> >
> > Jay Kwon wrote:
> >
> > > no the person I'd talked to didn't think it made any sense but what can
> I
> > > say. It fixed my problem. But it'd really be nice if someone over at
> > > Sybase could test & confirm.
> > >
> > > Jay Kwon
> > > Macgregor
> > >
> > > "Ray DiMarcello" <rdimarcello@ingva.com> wrote in message
> > > news:HH6wmQ00AHA.178@forums.sybase.com...
> > > > Did Sybase TS confirm that the ASE server only recognizes the first
> > > instance
> > > > of the swap file? That sounds strange.
> > > >
> > > > Dean, did you change the "shared memory starting address" using
> > > sp_configure
> > > > ??
> > > >
> > > > RD
> > > >
> > > >
> > > >
> > > > Jay Kwon wrote in message ...
> > > > >I had a similar issue on ASE1192 on NT. Problem I had was that my
> paging
> > > > >file was spread out across multiple discs (for perf reasons) but ASE
> only
> > > > >recognized paging file on my first disc only. I think I had about
> 1GB on
> > > > C:
> > > > >then 3GB's each on 2 other discs but I kept getting shared memory msg
> > > until
> > > > >I increased my paging file on my first drive. Keep increasing paging
> > > file
> > > > >(or first instance of swap file I should say) to about 2:1/Page file
> to
> > > ASE
> > > > >memory ratio. Hope that helps.
> > > > >
> > > > >Jay Kwon
> > > > >MacGregor
> > > > >
> > > > >"Justin Largent" <jlargent@bjc.org> wrote in message
> > > > >news:3AEF2F35.890FD227@bjc.org...
> > > > >> I have a Compaq Proliant 6400R, 4 CPU, 4GB RAM machine. I have NT
> > > > >> Enterprise 4.0 with SP4 installed AND have the 4GT option enabled.
> I
> > > > >> have installed ASE 11.9.2 with EBF8613. I have a paging file size
> of
> > > > >> 267MB.
> > > > >>
> > > > >> Can someone please tell me why the maximum amount of memory I can
> put
> > > in
> > > > >> for "total memory" is about 1292000 pages (~2523MB)? I have tried
> > > > >> 1390000, 1300000, 1295000. and 1290000 in hopes of maximizing my
> memory
> > > > >> use. 1290000 worked, and 1292000 worked, but why can I not get any
> > > > >> higher!!!!!!?????
> > > > >>
> > > > >> I realize NT is supposed to get 1GB. WHY CANNOT I NOT GET SYBASE
> > > HIGHER
> > > > >> THAN 2.5GB ROUGHLY?
> > > > >>
> > > > >> Thanks in advance,
> > > > >>
> > > > >> Dean Furness
> > > > >> Quilogy
> > > > >> dfurness@quilogy.com
> > > > >>
> > > > >
> > > > >
> > > >
> > > >
> >
> > --
> > Tony Imbierski
> > Sybase Engineering
> >
> > -- how much daylight did you save today? --
> >
> >

--
Tony Imbierski
Sybase Engineering

-- how much daylight did you save today? --


Justin Largent Posted on 2001-05-02 20:10:30.0Z
Message-ID: <3AF069B6.D82AC436@bjc.org>
Date: Wed, 02 May 2001 15:10:30 -0500
From: Justin Largent <jlargent@bjc.org>
X-Mailer: Mozilla 4.7 [en] (WinNT; U)
X-Accept-Language: en,pdf
MIME-Version: 1.0
Subject: Re: NT Memory Maximum
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 46
NNTP-Posting-Host: pele1.bjc.org 199.217.143.98
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:827
Article PK: 1087436

Ray - any guesses what value I should use? What units are used in that
parameter?

Ray DiMarcello wrote:

> Did Sybase TS confirm that the ASE server only recognizes the first instance
> of the swap file? That sounds strange.
>
> Dean, did you change the "shared memory starting address" using sp_configure
> ??
>
> RD
>
> Jay Kwon wrote in message ...
> >I had a similar issue on ASE1192 on NT. Problem I had was that my paging
> >file was spread out across multiple discs (for perf reasons) but ASE only
> >recognized paging file on my first disc only. I think I had about 1GB on
> C:
> >then 3GB's each on 2 other discs but I kept getting shared memory msg until
> >I increased my paging file on my first drive. Keep increasing paging file
> >(or first instance of swap file I should say) to about 2:1/Page file to ASE
> >memory ratio. Hope that helps.
> >
> >Jay Kwon
> >MacGregor
> >
> >"Justin Largent" <jlargent@bjc.org> wrote in message
> >news:3AEF2F35.890FD227@bjc.org...
> >> I have a Compaq Proliant 6400R, 4 CPU, 4GB RAM machine. I have NT
> >> Enterprise 4.0 with SP4 installed AND have the 4GT option enabled. I
> >> have installed ASE 11.9.2 with EBF8613. I have a paging file size of
> >> 267MB.
> >>
> >> Can someone please tell me why the maximum amount of memory I can put in
> >> for "total memory" is about 1292000 pages (~2523MB)? I have tried
> >> 1390000, 1300000, 1295000. and 1290000 in hopes of maximizing my memory
> >> use. 1290000 worked, and 1292000 worked, but why can I not get any
> >> higher!!!!!!?????
> >>
> >> I realize NT is supposed to get 1GB. WHY CANNOT I NOT GET SYBASE HIGHER
> >> THAN 2.5GB ROUGHLY?
> >>
> >> Thanks in advance,
> >>
> >> Dean Furness
> >> Quilogy
> >> dfurness@quilogy.com
> >>
> >
> >


Justin Largent Posted on 2001-05-02 20:41:22.0Z
Message-ID: <3AF070F2.D1E36266@bjc.org>
Date: Wed, 02 May 2001 15:41:22 -0500
From: Justin Largent <jlargent@bjc.org>
X-Mailer: Mozilla 4.7 [en] (WinNT; U)
X-Accept-Language: en,pdf
MIME-Version: 1.0
Subject: Re: NT Memory Maximum
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com> <3AF069B6.D82AC436@bjc.org>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 74
NNTP-Posting-Host: pele1.bjc.org 199.217.143.98
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:822
Article PK: 1087429

Ok....I changed the shared memory starting address to 23662592 - and I have no
idea what units those are or not. I rebooted and configured ASE 11.9.2 to have
1294600 - and it worked - WTF..... We made attempts to change the total memory to
3000MB (1536000 pages), and it worked! LMFAO. We tried 3074MB (1572864) - 3GB
for real....and.....it failed....no big deal though.....I can handle giving NT
1GB, with 74MB in limbo....

To recap....
Compaq Proliant 6400R, 4GB RAM, 4 CPU XEON 550s
I have a swap file size of 2MB on C:, and 4000MB on a second drive.
ASE 11.9.2 on NT Enterprise, with the 4GT option in use. /3GB in the boot.ini
file.
I have configured 'shared memory starting address' to 23662592 (??????)
I have configured 'total memory' to 1536000 to grab 3000MB of RAM.


THANKS TO ALL WHO HELPED. PLEASE LEARN AND TAKE WHAT YOU CAN FROM THIS AND FEEL
FREE TO EMAIL ME DIRECTLY IF YOU HAVE QUESTIONS.

THANKS!
Dean Furness
dfurness@quilogy.com

Justin Largent wrote:

> Ray - any guesses what value I should use? What units are used in that
> parameter?
>
> Ray DiMarcello wrote:
>
> > Did Sybase TS confirm that the ASE server only recognizes the first instance
> > of the swap file? That sounds strange.
> >
> > Dean, did you change the "shared memory starting address" using sp_configure
> > ??
> >
> > RD
> >
> > Jay Kwon wrote in message ...
> > >I had a similar issue on ASE1192 on NT. Problem I had was that my paging
> > >file was spread out across multiple discs (for perf reasons) but ASE only
> > >recognized paging file on my first disc only. I think I had about 1GB on
> > C:
> > >then 3GB's each on 2 other discs but I kept getting shared memory msg until
> > >I increased my paging file on my first drive. Keep increasing paging file
> > >(or first instance of swap file I should say) to about 2:1/Page file to ASE
> > >memory ratio. Hope that helps.
> > >
> > >Jay Kwon
> > >MacGregor
> > >
> > >"Justin Largent" <jlargent@bjc.org> wrote in message
> > >news:3AEF2F35.890FD227@bjc.org...
> > >> I have a Compaq Proliant 6400R, 4 CPU, 4GB RAM machine. I have NT
> > >> Enterprise 4.0 with SP4 installed AND have the 4GT option enabled. I
> > >> have installed ASE 11.9.2 with EBF8613. I have a paging file size of
> > >> 267MB.
> > >>
> > >> Can someone please tell me why the maximum amount of memory I can put in
> > >> for "total memory" is about 1292000 pages (~2523MB)? I have tried
> > >> 1390000, 1300000, 1295000. and 1290000 in hopes of maximizing my memory
> > >> use. 1290000 worked, and 1292000 worked, but why can I not get any
> > >> higher!!!!!!?????
> > >>
> > >> I realize NT is supposed to get 1GB. WHY CANNOT I NOT GET SYBASE HIGHER
> > >> THAN 2.5GB ROUGHLY?
> > >>
> > >> Thanks in advance,
> > >>
> > >> Dean Furness
> > >> Quilogy
> > >> dfurness@quilogy.com
> > >>
> > >
> > >


Ray DiMarcello Posted on 2001-05-03 17:23:24.0Z
From: "Ray DiMarcello" <rdimarcello@ingva.com>
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com> <3AF069B6.D82AC436@bjc.org> <3AF070F2.D1E36266@bjc.org>
Subject: Re: NT Memory Maximum
Date: Thu, 3 May 2001 13:23:24 -0400
Lines: 122
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <YRS6Bj$0AHA.254@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 207.245.124.67
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:813
Article PK: 1087420

I believe the unit is bytes. 23662592 / 1048576 bytes per meg = 22.5 meg.
23662592 is the number recommended by Sybase (as they stated in an email to
me once). But I have no idea why. Where'd you get that number? They say
the default for that setting on NT is 500meg. There must be some, maybe
negative, implications to changing it from 500 to 22.5. I can't just change
it here in production without providing the higher-ups some detailed
reasoning behind it other than, "see, I can set total memory higher." Until
I get some more detail from them I'm stuck allocating 1.5 gig out of 3.5 to
Sybase on our Compaq 8500R 700mhz 8-way.

Anyone from Sybase want to weigh in? I've tried but cannot find any good
whitepapers, etc. on this topic.


RD

Justin Largent wrote in message <3AF070F2.D1E36266@bjc.org>...
>Ok....I changed the shared memory starting address to 23662592 - and I have
no
>idea what units those are or not. I rebooted and configured ASE 11.9.2 to
have
>1294600 - and it worked - WTF..... We made attempts to change the total
memory to
>3000MB (1536000 pages), and it worked! LMFAO. We tried 3074MB (1572864) -
3GB
>for real....and.....it failed....no big deal though.....I can handle giving
NT
>1GB, with 74MB in limbo....
>
>To recap....
> Compaq Proliant 6400R, 4GB RAM, 4 CPU XEON 550s
> I have a swap file size of 2MB on C:, and 4000MB on a second drive.
> ASE 11.9.2 on NT Enterprise, with the 4GT option in use. /3GB in the
boot.ini
>file.
> I have configured 'shared memory starting address' to 23662592
(??????)
> I have configured 'total memory' to 1536000 to grab 3000MB of RAM.
>
>
>THANKS TO ALL WHO HELPED. PLEASE LEARN AND TAKE WHAT YOU CAN FROM THIS AND
FEEL
>FREE TO EMAIL ME DIRECTLY IF YOU HAVE QUESTIONS.
>
>THANKS!
>Dean Furness
>dfurness@quilogy.com
>
>
>
>
>Justin Largent wrote:
>
>> Ray - any guesses what value I should use? What units are used in that
>> parameter?
>>
>> Ray DiMarcello wrote:
>>
>> > Did Sybase TS confirm that the ASE server only recognizes the first
instance
>> > of the swap file? That sounds strange.
>> >
>> > Dean, did you change the "shared memory starting address" using
sp_configure
>> > ??
>> >
>> > RD
>> >
>> > Jay Kwon wrote in message ...
>> > >I had a similar issue on ASE1192 on NT. Problem I had was that my
paging
>> > >file was spread out across multiple discs (for perf reasons) but ASE
only
>> > >recognized paging file on my first disc only. I think I had about 1GB
on
>> > C:
>> > >then 3GB's each on 2 other discs but I kept getting shared memory msg
until
>> > >I increased my paging file on my first drive. Keep increasing paging
file
>> > >(or first instance of swap file I should say) to about 2:1/Page file
to ASE
>> > >memory ratio. Hope that helps.
>> > >
>> > >Jay Kwon
>> > >MacGregor
>> > >
>> > >"Justin Largent" <jlargent@bjc.org> wrote in message
>> > >news:3AEF2F35.890FD227@bjc.org...
>> > >> I have a Compaq Proliant 6400R, 4 CPU, 4GB RAM machine. I have NT
>> > >> Enterprise 4.0 with SP4 installed AND have the 4GT option enabled.
I
>> > >> have installed ASE 11.9.2 with EBF8613. I have a paging file size
of
>> > >> 267MB.
>> > >>
>> > >> Can someone please tell me why the maximum amount of memory I can
put in
>> > >> for "total memory" is about 1292000 pages (~2523MB)? I have tried
>> > >> 1390000, 1300000, 1295000. and 1290000 in hopes of maximizing my
memory
>> > >> use. 1290000 worked, and 1292000 worked, but why can I not get any
>> > >> higher!!!!!!?????
>> > >>
>> > >> I realize NT is supposed to get 1GB. WHY CANNOT I NOT GET SYBASE
HIGHER
>> > >> THAN 2.5GB ROUGHLY?
>> > >>
>> > >> Thanks in advance,
>> > >>
>> > >> Dean Furness
>> > >> Quilogy
>> > >> dfurness@quilogy.com
>> > >>
>> > >
>> > >
>


Ray DiMarcello Posted on 2001-05-03 17:17:58.0Z
From: "Ray DiMarcello" <rdimarcello@ingva.com>
References: <3AEF2F35.890FD227@bjc.org> <UVSkUyy0AHA.262@forums.sybase.com> <HH6wmQ00AHA.178@forums.sybase.com> <3AF069B6.D82AC436@bjc.org> <3AF070F2.D1E36266@bjc.org>
Subject: Re: NT Memory Maximum
Date: Thu, 3 May 2001 13:17:58 -0400
Lines: 119
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <H1TN$f$0AHA.191@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 207.245.124.67
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:814
Article PK: 1087422

I believe the unit is bytes. 23662592 equates to 22.5 meg (23662592 /
1048576 bytes per meg). By the way, the number you chose is "recommended"
by Sybase (as they told me in an email once). But I have no idea why and I
have no idea if there could be any negative consequences to setting it to
that number. Where'd you get that number from? They also state that the
default value for that setting on NT is 500meg. There's got to be some
(negative) implications to changing it from 500 to 22.5. Until I can get
some details out of them that backs up their recommendation, I'm stuck with
allocating 1.5 gig out of 3.5 on my Compaq 8500R 700mhz 8-way to Sybase. I
can't just change that in production without showing the reasoning behind
it. Anyone from Sybase want to weigh in ???

RD

Justin Largent wrote in message <3AF070F2.D1E36266@bjc.org>...
>Ok....I changed the shared memory starting address to 23662592 - and I have
no
>idea what units those are or not. I rebooted and configured ASE 11.9.2 to
have
>1294600 - and it worked - WTF..... We made attempts to change the total
memory to
>3000MB (1536000 pages), and it worked! LMFAO. We tried 3074MB (1572864) -
3GB
>for real....and.....it failed....no big deal though.....I can handle giving
NT
>1GB, with 74MB in limbo....
>
>To recap....
> Compaq Proliant 6400R, 4GB RAM, 4 CPU XEON 550s
> I have a swap file size of 2MB on C:, and 4000MB on a second drive.
> ASE 11.9.2 on NT Enterprise, with the 4GT option in use. /3GB in the
boot.ini
>file.
> I have configured 'shared memory starting address' to 23662592
(??????)
> I have configured 'total memory' to 1536000 to grab 3000MB of RAM.
>
>
>THANKS TO ALL WHO HELPED. PLEASE LEARN AND TAKE WHAT YOU CAN FROM THIS AND
FEEL
>FREE TO EMAIL ME DIRECTLY IF YOU HAVE QUESTIONS.
>
>THANKS!
>Dean Furness
>dfurness@quilogy.com
>
>
>
>
>Justin Largent wrote:
>
>> Ray - any guesses what value I should use? What units are used in that
>> parameter?
>>
>> Ray DiMarcello wrote:
>>
>> > Did Sybase TS confirm that the ASE server only recognizes the first
instance
>> > of the swap file? That sounds strange.
>> >
>> > Dean, did you change the "shared memory starting address" using
sp_configure
>> > ??
>> >
>> > RD
>> >
>> > Jay Kwon wrote in message ...
>> > >I had a similar issue on ASE1192 on NT. Problem I had was that my
paging
>> > >file was spread out across multiple discs (for perf reasons) but ASE
only
>> > >recognized paging file on my first disc only. I think I had about 1GB
on
>> > C:
>> > >then 3GB's each on 2 other discs but I kept getting shared memory msg
until
>> > >I increased my paging file on my first drive. Keep increasing paging
file
>> > >(or first instance of swap file I should say) to about 2:1/Page file
to ASE
>> > >memory ratio. Hope that helps.
>> > >
>> > >Jay Kwon
>> > >MacGregor
>> > >
>> > >"Justin Largent" <jlargent@bjc.org> wrote in message
>> > >news:3AEF2F35.890FD227@bjc.org...
>> > >> I have a Compaq Proliant 6400R, 4 CPU, 4GB RAM machine. I have NT
>> > >> Enterprise 4.0 with SP4 installed AND have the 4GT option enabled.
I
>> > >> have installed ASE 11.9.2 with EBF8613. I have a paging file size
of
>> > >> 267MB.
>> > >>
>> > >> Can someone please tell me why the maximum amount of memory I can
put in
>> > >> for "total memory" is about 1292000 pages (~2523MB)? I have tried
>> > >> 1390000, 1300000, 1295000. and 1290000 in hopes of maximizing my
memory
>> > >> use. 1290000 worked, and 1292000 worked, but why can I not get any
>> > >> higher!!!!!!?????
>> > >>
>> > >> I realize NT is supposed to get 1GB. WHY CANNOT I NOT GET SYBASE
HIGHER
>> > >> THAN 2.5GB ROUGHLY?
>> > >>
>> > >> Thanks in advance,
>> > >>
>> > >> Dean Furness
>> > >> Quilogy
>> > >> dfurness@quilogy.com
>> > >>
>> > >
>> > >
>


Tony Imbierski Posted on 2001-05-02 09:42:41.0Z
Message-ID: <3AEFD691.E08748EF@sybase.com>
Date: Wed, 02 May 2001 10:42:41 +0100
From: Tony Imbierski <tonyi@sybase.com>
X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: NT Memory Maximum
References: <3AEF2F35.890FD227@bjc.org>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 37
NNTP-Posting-Host: aja.sybase.com 158.76.131.36
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:838
Article PK: 1087444


Justin Largent wrote:

> I have a Compaq Proliant 6400R, 4 CPU, 4GB RAM machine. I have NT
> Enterprise 4.0 with SP4 installed AND have the 4GT option enabled. I
> have installed ASE 11.9.2 with EBF8613. I have a paging file size of
> 267MB.
>
> Can someone please tell me why the maximum amount of memory I can put in
> for "total memory" is about 1292000 pages (~2523MB)? I have tried
> 1390000, 1300000, 1295000. and 1290000 in hopes of maximizing my memory
> use. 1290000 worked, and 1292000 worked, but why can I not get any
> higher!!!!!!?????
>
> I realize NT is supposed to get 1GB. WHY CANNOT I NOT GET SYBASE HIGHER
> THAN 2.5GB ROUGHLY?
>
> Thanks in advance,
>
> Dean Furness
> Quilogy
> dfurness@quilogy.com

... because of the 3GB left to the application, everything to do with the
application process has to fit. The program code itself, supporting DLL's,
stacks, i/o channels, probably lots of other stuff that I forgot about.
What's left over is available for shared memory. It is possible to mess
about with config parameters and squeeze in a little more, though how much
more depends a lot on the circumstances. Tech support would be best to
advise you on this as I think they have some kind of document on it (or
maybe search the tech archives on the Sybase web site).

cheers, HTH
tonyi

--
Tony Imbierski
Sybase Engineering

-- how much daylight did you save today? --


Justin Largent Posted on 2001-05-02 11:43:50.0Z
Message-ID: <3AEFF2F5.426C7755@bjc.org>
Date: Wed, 02 May 2001 06:43:50 -0500
From: Justin Largent <jlargent@bjc.org>
X-Mailer: Mozilla 4.7 [en] (WinNT; U)
X-Accept-Language: en,pdf
MIME-Version: 1.0
Subject: Re: NT Memory Maximum
References: <3AEF2F35.890FD227@bjc.org> <3AEFD691.E08748EF@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 41
NNTP-Posting-Host: pele1.bjc.org 199.217.143.98
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:836
Article PK: 1087443

I will be anxiously anticipating your response....Thanks Tony!

Tony Imbierski wrote:

> Justin Largent wrote:
>
> > I have a Compaq Proliant 6400R, 4 CPU, 4GB RAM machine. I have NT
> > Enterprise 4.0 with SP4 installed AND have the 4GT option enabled. I
> > have installed ASE 11.9.2 with EBF8613. I have a paging file size of
> > 267MB.
> >
> > Can someone please tell me why the maximum amount of memory I can put in
> > for "total memory" is about 1292000 pages (~2523MB)? I have tried
> > 1390000, 1300000, 1295000. and 1290000 in hopes of maximizing my memory
> > use. 1290000 worked, and 1292000 worked, but why can I not get any
> > higher!!!!!!?????
> >
> > I realize NT is supposed to get 1GB. WHY CANNOT I NOT GET SYBASE HIGHER
> > THAN 2.5GB ROUGHLY?
> >
> > Thanks in advance,
> >
> > Dean Furness
> > Quilogy
> > dfurness@quilogy.com
>
> ... because of the 3GB left to the application, everything to do with the
> application process has to fit. The program code itself, supporting DLL's,
> stacks, i/o channels, probably lots of other stuff that I forgot about.
> What's left over is available for shared memory. It is possible to mess
> about with config parameters and squeeze in a little more, though how much
> more depends a lot on the circumstances. Tech support would be best to
> advise you on this as I think they have some kind of document on it (or
> maybe search the tech archives on the Sybase web site).
>
> cheers, HTH
> tonyi
>
> --
> Tony Imbierski
> Sybase Engineering
>
> -- how much daylight did you save today? --


Justin Largent Posted on 2001-05-01 22:27:25.0Z
Message-ID: <3AEF384D.91D27705@bjc.org>
Date: Tue, 01 May 2001 17:27:25 -0500
From: Justin Largent <jlargent@bjc.org>
X-Mailer: Mozilla 4.7 [en] (WinNT; U)
X-Accept-Language: en,pdf
MIME-Version: 1.0
Subject: Re: NT Memory Maximum
References: <3AEF2F35.890FD227@bjc.org>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 27
NNTP-Posting-Host: pele1.bjc.org 199.217.143.98
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:841
Article PK: 1087449

More info....I have narrowed it down to the following:

I can get the server to boot with a total memory allocation of 1294500, but
it will not when I change it to 1294750. I am at the threshold. I have
also reduced the paging file on drive C:, and increased it on another
internal drive. Can someone please give me an answer?

--Thanks!

Justin

Justin Largent wrote:

> I have a Compaq Proliant 6400R, 4 CPU, 4GB RAM machine. I have NT
> Enterprise 4.0 with SP4 installed AND have the 4GT option enabled. I
> have installed ASE 11.9.2 with EBF8613. I have a paging file size of
> 267MB.
>
> Can someone please tell me why the maximum amount of memory I can put in
> for "total memory" is about 1292000 pages (~2523MB)? I have tried
> 1390000, 1300000, 1295000. and 1290000 in hopes of maximizing my memory
> use. 1290000 worked, and 1292000 worked, but why can I not get any
> higher!!!!!!?????
>
> I realize NT is supposed to get 1GB. WHY CANNOT I NOT GET SYBASE HIGHER
> THAN 2.5GB ROUGHLY?
>
> Thanks in advance,
>

Justin


Geoff_Smith Posted on 2001-05-02 00:08:44.0Z
From: Geoff_Smith
Date: Tue, 1 May 2001 20:08:44 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: NT Memory Maximum
Message-ID: <0EE29AC753C63EC80000CC9B85256A40.007D634285256A3F@webforums>
References: <3AEF2F35.890FD227@bjc.org> <3AEF384D.91D27705@bjc.org>
Lines: 33
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:840
Article PK: 1087447

Justin,

We have an almost identical installation of Sybase here (11.9.2)on and
almost identical machine (compaq proliant 4 cpu 4GB RAM).

I am interested in the same issue however I am new at the position here and
there is a bit of background that I need to bring you up to date on re
memory allocation to Sybase:

In the past I was told that Sybase was falling over 3 or more times a week.
It was eventually traced to a bug in Sybase that basically caused a memory
problem when certain queries were run on large tables. Sybase patched it
and the problem no longer occurs.

While the problem was occurring it was found that if you set the memory
above about 1.3 / 1.4 GB that the Sybase monitoring tools for basically
looking at a core-style dump of memory to trace the root of the problem
that these tools could not "look-into" the memory above 1.4GB.

Finally, our Sybase installation is still set at 1.4GB even
though the problem hasn't occurred since the patch.

I am at present setting up a test database to try and increase memory to
Sybase as our production machine never gets close to using all its memory
available (mostly we have approx 1.7GB free all-day in production).

I am intersetd in following this issue through with you and Sybase and the
DBA gurus who post on this site (enough sucking up for a response I
reckon...), comparing our results along the way.

Cheers,

Geoff