Post reply

'A significant part of sql server process memory has been paged out...' error

  • December 6, 2008 at 4:14 am

    #908789

    begs the question, what other apps are running on these sql servers?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • December 6, 2008 at 10:23 am

    #908827

    This is a brand new server we just configured. There is no other applications besides SQL Server and OS. SQL Server doesn't have any user databases and nobody and no users connected to the server.

  • December 7, 2008 at 12:45 pm

    #908962

    This can be a common error in SQL 2005 x64 standard, as per http://support.microsoft.com/kb/918483

    There are links to a couple of hotfixes as regards terminal services potentially causing this issue, but an upgrade to Enterprise Edition might be in the works.


    Shamless self promotion - read my blog http://sirsql.net

  • December 7, 2008 at 1:31 pm

    #908969

    Thanks Nicholas! I saw several cases like mine and people were reporting that Microsoft came up with hotfix for their enviroment. I was wondering if this fix might have been included in on the patches after SP2. Unfortunately, upgrading to EE is out of question because of the money difference.

  • December 7, 2008 at 1:44 pm

    #908971

    Have you tried going from direct memory allocation to just setting a hard value? Maybe that would help with paging (but then again maybe not).


    Shamless self promotion - read my blog http://sirsql.net

  • December 7, 2008 at 2:29 pm

    #908972

    I have configured max value used by SQL Server leaving 6GB to OS. The min value is currently set to 0.

    Is that what you meant?

  • December 7, 2008 at 2:36 pm

    #908973

    configure the min value to be a sensible value other than zero but not higher than max

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • December 7, 2008 at 2:37 pm

    #908974

    Try setting them the same. It should just grab that memory right away, not saying it'll do anything, but it might.


    Shamless self promotion - read my blog http://sirsql.net

  • December 7, 2008 at 6:13 pm

    #908982

    I will try setting min memory to the same value as max and report back the progress.

Viewing 9 posts - 1 through 10 (of 10 total)

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