August 10, 2013 at 12:57 pm
We all know in windows 32 bit system VAS has 4Gd of memory space .out of which 2GB is allotted to kernal and rest 2GB to user mode.
what i wanted to know is that is above setting is independent of (physical/actual) RAM size in server .
I mean we have RAM of size suppose (1/2/3) GB size in server , then to user mode would have VAS of 2GB while kernal would have VAS of 2GB
or above windows memory setting is applicable only for servers having 4GB or more of ram
August 11, 2013 at 3:32 am
On 32-bit windows, VAS is 2GB kernel, 2GB user, that's universal no matter whether the server has 10MB memory or 64GB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 12, 2013 at 3:56 am
Of course, if the server has less than 4Gb of RAM, then actually *using* the full 4Gb of virtual address space requires you to swap memory to disk, and that kills performance something chronic.
August 12, 2013 at 7:08 am
paul.knibbs (8/12/2013)
Of course, if the server has less than 4Gb of RAM, then actually *using* the full 4Gb of virtual address space requires you to swap memory to disk, and that kills performance something chronic.
Same for 64 bit, with it's 16 TB of VAS (limited to 16TB from the many exabytes actually addressable)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply