Re: Passing the Windows Memory Limits

postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0303140421.6ce0378a_at_posting.google.com>...
> drak0nian_at_yahoo.com (Paul Drake) wrote in message news:<1ac7c7b3.0303132246.3a45fe25_at_posting.google.com>...
> > Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote in message news:<8vas6vob2l8uem8tvadand8gl36okuk672_at_4ax.com>...
> > > On Tue, 11 Mar 2003 09:59:21 -0800, Chuck <ccarson_at_echeeba.com> wrote:
> > turn off the file cache and disable the services that you're not going
> > to use.
> > the ratio 41% is commonly known as to what NT4/W2K allocate to
> > filesystem caching in memory. do what any good DBA would do and turn
> > it off.
>
> Obviously I always turn that off.

good.

> > I would not trust metalink as to how much memory W2K Advanced Server
> > uses.
> > I'd use something like "c:\> pslist -m" - or does the use of a command
> > prompt scare you?
>
> No, of course not. However, the command must be from the resource kit.
> Most of our customers simply don't buy that.

good news - this utility is from SysInternals - http;//www.sysinternals.com.
There's also lots of programs from the W2K resource kit that are available from Microsoft and other sites. I've posted some sites on other posts - I'm on the road and don't have the info with me.

> > Boot options can be set in boot.ini to enable large memory support.
> > (/3GB, /PAE)
> > This is covered very well in the book:
> > "Oracle9i for Windows 2000 Tips & Techniques" Scott Jesse, Matthew
> > Sale.
> >
>
> I am aware of that book,and read the chapter on memory architecture.
> IIRC they are corroborating the Metalink evidence.
>
> > and in docs in Metalink.
> >
> > I have used the /3GB boot option with success (until the 8.1.7.4.1
> > patchset).
>
> The customer I am referring to has Oracle running on plain vanilla
> Win2k. Not our decision.
>
> >
> > I have not used indirect_block_buffers, but if used, could allow an
> > SGA of 7 GB
> > (3 GB under the 4 GB mark in physical memory and 4 GB of extended
> > memory using PAE). This is cpu functionality, so if you decide to
> > install your favorite Linux distibution on IA32, the same
> > limitations/workarounds apply.
>
> The same customer doesn't want for political reasons to deploy any
> Unix variant. They don't have Unix knowledge so they would need to
> transfer full control to my department, which they don't want. The
> rest of their network of (test, development etc.) databases is on NT.

a common scenario in my environment also.

> > Check out how inexpensive it is to get a Dell PE 6650 with 8 GB of
> > memory.
> > 1 GB DIMMs are cheap - its the 2 GB DIMMs that are pricey.
> >
> > Paul
>
> My company just dumped the CEO and the CFO and is about broke.

I'm sorry to hear that.
A college friend of mine lost most of staff last week in operations last week.
It really sucks to build something up only to have it decimated. I hope that things improve for you and your company.

Paul Received on Sat Mar 15 2003 - 03:11:46 CST