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

How virtual memory works at start up? Expand / Collapse
Author
Message
Posted Monday, March 9, 2009 2:51 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:34 AM
Points: 10, Visits: 196
Dear Friends,

I have a doubt about how virtual memory works while starting up the server.
For eg i have reserverd 4 GB of space for virtual memory. When the machine reboots whther it resrve and lock this 4 GB space for virtual memory or does it allocate dynamically as and when load becomes bigger and bigger. All of your comments and explanations are greatly appreciatable.
Please respond and share your knowledge.

Thanks
Ichayan
Post #671983
Posted Tuesday, March 10, 2009 10:11 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 9:33 AM
Points: 33,052, Visits: 15,162
In windows, every machine has a 4GB address space. It's 2GB for the app, and 2GB for the OS in 32 bit systems. You can allocate more to SQL, but you need to /3GB switch, which will get you 3GB for SQL. you can go beyond that in terms of how physical memory is allocated, but it's swapped in and out of the 2 or 3GB space.

What version/edition of SQL?







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #672586
Posted Tuesday, March 10, 2009 11:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:34 AM
Points: 10, Visits: 196
Thanks for the response.
My version is windows 2000 advanced.
awe/pae enabled.
I have 4 gb of RAM.
No other application on the server other than sql.
I have added service account of sql server to page lock memory.
Every thing seems ok. But my question is about virtual memory.
I will explain my question in detail, i have 6 GB virtual physical memory enabled, 4 from C drive and 2 from another local drive. Since i enabled 4 GB of space from C drive when the system boot up does it reserve and block this 4 GB for virtual memory?
Or does it make available dynamically when it needs. if this is right what will be the error triggered to the even veiwer/sql server log when c drive run out of space?


Thanks
Thomas George

Post #672629
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse