Sql server memory configuration options

  • 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

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 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.

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply