How virtual memory works at start up?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » How virtual memory works at start up?

How virtual memory works at start up?

Rate Topic

Display Mode

Topic Options

Author

Message

ichayan2003

Posted Monday, March 09, 2009 2:51 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 2:45 PM
Points: 10, Visits: 170

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

Steve Jones - SSC Editor

Posted Tuesday, March 10, 2009 10:11 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 11:20 AM
Points: 31,437, Visits: 13,752

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

ichayan2003

Posted Tuesday, March 10, 2009 11:08 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 2:45 PM
Points: 10, Visits: 170

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 »

Permissions