Re: LRe: How much RAM Windows 2003 Server Standard Edition can use?
Re: LRe: How much RAM Windows 2003 Server Standard Edition can use?
Peter wrote:
> Dear John,
>
> Thank you for your advice. From the articles, my understanding is that even
> though we have 2GB physical RAM and if SQL Server is installed, we still get
> 2 address spaces each of 2GB - One for the OS and one for the Application
> (In this case, the SQL Server 2005) ?
Yes, on 32-bit operating systems that is correct. 32-bit operating
systems can address 4 GB of memory and Windows operating systems devides
the address space evenly between user mode and kernel mode memory. Each
user mode process can be allocated 2GB of private address space. If you
use the /3GB switch the the kernel memory space is reduced to 1GB of
Virtual Address Space and the user mode processes that are Large Address
Aware can use 3GB.
> I just wonder how Windows 2003 manage the address spaces ? Does it use
> paging ?
The Virtual address space is always mapped to virtual memory, the
virtual memory addresses are translated into physical memory addresses
as needed, so yes, Windows uses the paging file to manage the address
space. That doesn't necessarilly mean the the system will page or that
it will page exessively, by mapping memory allocations to the virtual
memory the actual physical RAM is not directly allocated or all mapped
to one or a few user processes only.
John
Virtual Address Space
http://msdn2.microsoft.com/en-us/library/aa366912.aspx
RAM, Virtual Memory, PageFile and all that stuff
http://members.shaw.ca/bsanders/WindowsGeneralWeb/RAMVirtualMemoryPageFileEtc.htm#2_1
A description of the 4 GB RAM Tuning feature and the Physical Address
Extension switch
http://support.microsoft.com/kb/291988
The Virtual-Memory Manager in Windows NT
http://msdn2.microsoft.com/en-us/library/ms810616.aspx