Wednesday, March 7, 2012

Memory Question

This question is aimed to the experienced DBAs in server
configuration:
We currently have the following configuration:
-. Windows 2000 Server SP4
-. SQL Server Standard SP3
-. 1GB RAM
We are going to upgrade the RAM size. According with Books
On Line, SQL Server supports up to 2GB.
My question is, if we put 4GB on the server, SQL Server
will use 2GB max and Windows would be able to use the
other 2 Gigs?
or
The server (Windows and SQL Server) will not see more than
2GB alltogether?
Thanks in advance.Hope you will get you answer here:
http://support.microsoft.com/?id=274750
"DBA" <anonymous@.discussions.microsoft.com> wrote in message
news:00e201c39800$7cb7fb40$a501280a@.phx.gbl...
> This question is aimed to the experienced DBAs in server
> configuration:
> We currently have the following configuration:
> -. Windows 2000 Server SP4
> -. SQL Server Standard SP3
> -. 1GB RAM
> We are going to upgrade the RAM size. According with Books
> On Line, SQL Server supports up to 2GB.
> My question is, if we put 4GB on the server, SQL Server
> will use 2GB max and Windows would be able to use the
> other 2 Gigs?
> or
> The server (Windows and SQL Server) will not see more than
> 2GB alltogether?
> Thanks in advance.

No comments:

Post a Comment