Post reply

How virtual memory works at start up?

  • March 9, 2009 at 2:51 pm

    #71395

    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

  • March 10, 2009 at 10:11 am

    #956924

    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?

  • March 10, 2009 at 11:08 am

    #956957

    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

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

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