RAM

[Ellen K.]

Is it true that SQL Server Standard edition can only use 2 GB of RAM?

If so, and the box has more, does that mean the excess WILL be
available for the O/S and any other apps?

[GL]

Re: RAM

You are correct

(assuming we are talking about SQL server 2000 standard edition)

GL

"Ellen K." <72322.enno.ess peeayem.1016@co mpuserve.com> wrote in message
news:ia8d805t3v p4c3riv2hfnfgaa 3ubhk0nvp@4ax.c om...[color=blue]
> Is it true that SQL Server Standard edition can only use 2 GB of RAM?
>
> If so, and the box has more, does that mean the excess WILL be
> available for the O/S and any other apps?[/color]

[Daniel A. Thomas]

Re: RAM


"Ellen K." <72322.enno.ess peeayem.1016@co mpuserve.com> wrote in message
news:ia8d805t3v p4c3riv2hfnfgaa 3ubhk0nvp@4ax.c om...
| Is it true that SQL Server Standard edition can only use 2 GB of RAM?
|
| If so, and the box has more, does that mean the excess WILL be
| available for the O/S and any other apps?


Keep your OS specifications in mind when choosing your version of SQL
Server. For example, Windows Server 2000 / 2003 Standard Edition has the
following memory specifications:

Support for up to 4GB of memory. Of that 4GB, the operating system always
reserves anything above 2GB for its own use. This allows applications
on the server to share a maximum of 2GB.

Dan Thomas