Installing Standard Edition on server with 4Gb memory

Are there any problems associated with installing SQL
Server 2000 "Standard Edition" on Windows 2000 Server on a
server with 4Gb of memory? I believe that the standard
edition will only "support" 2Gb of memory, but does that
mean that it will only access 2Gb or that it is not
supported on a server with more than 2Gb? I cannot find
any documentation on this.It just means the relational server won't access more than 2GB of memory.
There is no problem running it on a 4GB server, or an 8GB server, or ...
--
Hal Berenson, SQL Server MVP
True Mountain Group LLC
"Ludwig" <lbdba@.yahoo.com> wrote in message
news:06f901c36c50$d665dfd0$a401280a@.phx.gbl...
> Are there any problems associated with installing SQL
> Server 2000 "Standard Edition" on Windows 2000 Server on a
> server with 4Gb of memory? I believe that the standard
> edition will only "support" 2Gb of memory, but does that
> mean that it will only access 2Gb or that it is not
> supported on a server with more than 2Gb? I cannot find
> any documentation on this.|||Is that documented anywhere in a KB article or in Books-
online?
>--Original Message--
>It just means the relational server won't access more
than 2GB of memory.
>There is no problem running it on a 4GB server, or an 8GB
server, or ...
>--
>Hal Berenson, SQL Server MVP
>True Mountain Group LLC
>
>"Ludwig" <lbdba@.yahoo.com> wrote in message
>news:06f901c36c50$d665dfd0$a401280a@.phx.gbl...
>> Are there any problems associated with installing SQL
>> Server 2000 "Standard Edition" on Windows 2000 Server
on a
>> server with 4Gb of memory? I believe that the standard
>> edition will only "support" 2Gb of memory, but does that
>> mean that it will only access 2Gb or that it is not
>> supported on a server with more than 2Gb? I cannot find
>> any documentation on this.
>
>.
>|||Books Online:
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\architec.chm::/8_ar_ts_8dbn
.htm
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Ludwig" <lbdba@.yahoo.com> wrote in message news:069e01c36c65$aa8e6020$a601280a@.phx.gbl...
> Is that documented anywhere in a KB article or in Books-
> online?
> >--Original Message--
> >It just means the relational server won't access more
> than 2GB of memory.
> >There is no problem running it on a 4GB server, or an 8GB
> server, or ...
> >
> >--
> >Hal Berenson, SQL Server MVP
> >True Mountain Group LLC
> >
> >
> >"Ludwig" <lbdba@.yahoo.com> wrote in message
> >news:06f901c36c50$d665dfd0$a401280a@.phx.gbl...
> >> Are there any problems associated with installing SQL
> >> Server 2000 "Standard Edition" on Windows 2000 Server
> on a
> >> server with 4Gb of memory? I believe that the standard
> >> edition will only "support" 2Gb of memory, but does that
> >> mean that it will only access 2Gb or that it is not
> >> supported on a server with more than 2Gb? I cannot find
> >> any documentation on this.
> >
> >
> >.
> >|||Thanks Tibor. This is a good summary page, but it only
states ambiguously:
"This table shows the maximum amount of physical memory,
or RAM, that the database engine in each SQL Server 2000
edition can support"
It does not state if the server can have more than 2Gb.
>--Original Message--
>Books Online:
>mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%
20Server\80\Tools\Books\architec.chm::/8_ar_ts_8dbn
>..htm
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>|||At some point it becomes silly to document things, and this one is over that
line.
Why would SQL Server care if there was more memory on the machine then it
will actually utilize? It doesn't, nor could it.
--
Hal Berenson, SQL Server MVP
True Mountain Group LLC
"Ludwig" <lbdba@.yahoo.com> wrote in message
news:0f1401c36cfd$a9cb6230$a001280a@.phx.gbl...
> Thanks Tibor. This is a good summary page, but it only
> states ambiguously:
> "This table shows the maximum amount of physical memory,
> or RAM, that the database engine in each SQL Server 2000
> edition can support"
> It does not state if the server can have more than 2Gb.
> >--Original Message--
> >Books Online:
> >mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%
> 20Server\80\Tools\Books\architec.chm::/8_ar_ts_8dbn
> >..htm
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at: http://groups.google.com/groups?oi=djq&as
> ugroup=microsoft.public.sqlserver
> >
>|||Hal
I disagree and I think you have missed the point. I don't
think I am alone in this as I have read other postings
along the same line - I was hoping this time maybe I'd
receive a reference to a Microsoft document that is a
little clearer about what "support" means.
If SQL Server is configured to handle the memory
dynamically - rather than be allocated a fixed amount of
RAM - I would imagine it would be very important for it to
know how much memory is available on the server for other
processes.
I try not to be cynical, but I'm wondering if perhaps
there is a reason for the ambiguous documentation of the
memory capability - "Well I'm not real sure and I better
not take a chance, let's get the Enterprise Edition".
Ludwig
>--Original Message--
>At some point it becomes silly to document things, and
this one is over that
>line.
>Why would SQL Server care if there was more memory on the
machine then it
>will actually utilize? It doesn't, nor could it.
>--
>Hal Berenson, SQL Server MVP
>True Mountain Group LLC
>