locked
Memory / virtual memory problem on Win2K8 server RRS feed

  • Question

  • Greetings everyone !

    This kind of trouble and question.
    I have Windows 2008 R2 Standard server installed on VM host on
    1 vCPU (4 cores), 5120MB vRAM and 600GB vHDD virtual machine.

    Server acts as SQL server and takes all the physical memory
    (about 4.8GB showed in task manager (screenshot 3)).

    I have also enabled virtual memory paging with 7678MB initial
    size on the operating system drive (screenshot attached).
    Databases are on other logical drive, but in there there is
    no paging activated.

    The physical memory is full , but I don't think that pagings does work.
    I also have conflicting scene (screenshot 2) with OS indicators view
    that shows that memory is not used as much as it shows in operating system.

    Please assist me with this problem. If any information is insufficient
    write it here and I will provide.

    Thank you
    Thursday, March 7, 2013 10:52 AM

Answers

  • To know more how to configure your sql memory see this:

    http://msdn.microsoft.com/en-us/library/ms178067%28v=sql.105%29.aspx

    Regards,


    André CR / Helped? If the answer is yes mark! If the answer is no, wait a little bit because i'll back! Visit my blog! sqlmagu.blogspot.com.br

    • Marked as answer by Narius1 Monday, April 22, 2013 6:22 AM
    Friday, April 19, 2013 12:13 PM

All replies

  • Hi,

    The paging only happens when server is runs out of physical memory. 

    Are you having any memory issue at the moment? Check the SQL waits to confirm what kind of issue you have.

    Thanks

    Deepak


    Thursday, March 7, 2013 11:17 AM
  • You need to set max server memory in the SQL Server properties.  Leave the OS 1GB... more is better, but you can try 1GB and see if you still see paging.
    Thursday, March 7, 2013 2:26 PM
  • This is normal and expected behavior.

    Please see:

    http://support.microsoft.com/kb/321363

    SQL Server keeps all the memory given.  In a VM environment you need to "reserve" the memory.  Also, 512mbs is nowhere near enough.  It needs at least 2GBs dedicated to SQL Server for decent performance.

    Please see:

    http://blogs.msdn.com/b/cindygross/archive/2009/10/23/considerations-for-installing-sql-server-on-vmware.aspx


    • Edited by Tom Phillips Thursday, March 7, 2013 5:25 PM
    • Marked as answer by Allen Li - MSFT Thursday, March 14, 2013 1:46 AM
    • Unmarked as answer by Narius1 Friday, April 19, 2013 8:06 AM
    Thursday, March 7, 2013 5:24 PM
  • SQLServer will start consuming the memory as far as there is adequate memory in the system (If you do not cap the SQL Server max server memory).
    But if the OS turns lowphysicalmemory notification SQL Server will scale down its usage,same time OS will also page out SQLServer memory(Exception LPIM)

    When there is available memory on RAM,Why should windows page out the working set of a process?

    How are you checking the SQL Server memory usage and working set of SQL Server to identify if SQL Server paged?

    Post the output of two queries in http://mssqlwiki.com/2012/06/27/a-significant-part-of-sql-server-process-memory-has-been-paged-out/ that would tell us if there was low memory notification from windows and if SQL Server is paged.

    If you find SQL Server is  not using the memory it could be VMware balloning

     


    Thank you,

    Karthick P.K |My blogs|My Scribbles|Twitter|My Facebook Group|

    www.Mssqlwiki.com

    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    Friday, March 8, 2013 3:32 AM
  • Thank you for your answer

    Here is what I have in the memory screen in time when installed memory is 7GB



    do I need to correct this ? (I understand stupid question I know that I do need that)
    And what is the best to set when I have 7GBs of RAM installed ?


    • Edited by Narius1 Friday, April 19, 2013 8:11 AM
    Friday, April 19, 2013 8:09 AM
  • To know more how to configure your sql memory see this:

    http://msdn.microsoft.com/en-us/library/ms178067%28v=sql.105%29.aspx

    Regards,


    André CR / Helped? If the answer is yes mark! If the answer is no, wait a little bit because i'll back! Visit my blog! sqlmagu.blogspot.com.br

    • Marked as answer by Narius1 Monday, April 22, 2013 6:22 AM
    Friday, April 19, 2013 12:13 PM