Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sql server memory configuration options Expand / Collapse
Author
Message
Posted Saturday, August 10, 2013 12:57 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, December 1, 2014 4:16 AM
Points: 92, Visits: 137
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
Post #1483052
Posted Sunday, August 11, 2013 3:32 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:14 PM
Points: 40,615, Visits: 37,081
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 2008, MVP
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

Post #1483079
Posted Monday, August 12, 2013 3:56 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, December 12, 2014 3:32 AM
Points: 1,639, Visits: 5,721
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.
Post #1483207
Posted Monday, August 12, 2013 7:08 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:14 PM
Points: 40,615, Visits: 37,081
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 2008, MVP
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

Post #1483286
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse