question on memory

26 May 2005 7:04 PM

ChrisR

Win2K Advanced Server
SQL2K Enterprise

I need to set up 1 big fat Disaster Recovery box for my 6 production boxes.
I will do this by putting 6 instances of SQL on the DR box. I know that
there is an 8 gig max (using AWE) limit. But what I don't know is can each
instance have its own 8 gigs, or do all 6 instances need to share the same 8
gigs? Also, would switching to Win2K3 help me to be able to use more RAM?
Basically, I dont want to tell anyone to order 48 gigs or RAM (6 instances
with 8 gigs each) when Im only going to be able to use 8.

TIA, ChrisR

26 May 2005 10:10 PM

Andrew J. Kelly

Chris,

Each instance can use it's own block of memory but I don't think Win2K Adv
server can use more than 8GB. I believe you need Data Center for more than
8GB. Certainly for 48GB. Do you need 8GB for each instance? Do each of
the 6 Prod boxes have 8GB now? Does your DR plan say you need to run all 6
instances on the one box at the same time? Seems kind of silly to have 6
individual boxes in prod and expect to run all 6 instances at once on one
box. In any case Win2K3 will not allow you to use any more ram but it does
have certain performance enhancements over 2K that you should take advantage
of.

--
Andrew J. Kelly SQL MVP

Show quoteHide quote

"ChrisR" <noem***@bla.com> wrote in message
news:euDyuWiYFHA.2380@tk2msftngp13.phx.gbl...
> Win2K Advanced Server
> SQL2K Enterprise
>
> I need to set up 1 big fat Disaster Recovery box for my 6 production
> boxes. I will do this by putting 6 instances of SQL on the DR box. I know
> that there is an 8 gig max (using AWE) limit. But what I don't know is can
> each instance have its own 8 gigs, or do all 6 instances need to share the
> same 8 gigs? Also, would switching to Win2K3 help me to be able to use
> more RAM? Basically, I dont want to tell anyone to order 48 gigs or RAM (6
> instances with 8 gigs each) when Im only going to be able to use 8.
>
>
> TIA, ChrisR
>

27 May 2005 5:31 PM

ChrisR

I typed out a reply yesterday but I guess I forgot to hit the reply button.
No I don't need 8 gigs per instance, but 6 boxes sharing 8 gigs wont do
either. Yes, all of them may need to be on at once.

Thanks Andrew.

CR

Show quoteHide quote

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:%23MHGH$jYFHA.1152@tk2msftngp13.phx.gbl...
> Chris,
>
> Each instance can use it's own block of memory but I don't think Win2K Adv
> server can use more than 8GB. I believe you need Data Center for more
> than 8GB. Certainly for 48GB. Do you need 8GB for each instance? Do
> each of the 6 Prod boxes have 8GB now? Does your DR plan say you need to
> run all 6 instances on the one box at the same time? Seems kind of silly
> to have 6 individual boxes in prod and expect to run all 6 instances at
> once on one box. In any case Win2K3 will not allow you to use any more
> ram but it does have certain performance enhancements over 2K that you
> should take advantage of.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "ChrisR" <noem***@bla.com> wrote in message
> news:euDyuWiYFHA.2380@tk2msftngp13.phx.gbl...
>> Win2K Advanced Server
>> SQL2K Enterprise
>>
>> I need to set up 1 big fat Disaster Recovery box for my 6 production
>> boxes. I will do this by putting 6 instances of SQL on the DR box. I know
>> that there is an 8 gig max (using AWE) limit. But what I don't know is
>> can each instance have its own 8 gigs, or do all 6 instances need to
>> share the same 8 gigs? Also, would switching to Win2K3 help me to be able
>> to use more RAM? Basically, I dont want to tell anyone to order 48 gigs
>> or RAM (6 instances with 8 gigs each) when Im only going to be able to
>> use 8.
>>
>>
>> TIA, ChrisR
>>
>
>