Post reply

Memory Pressure on SQL SERVER 2005

  • November 15, 2012 at 12:48 pm

    #150125

    Hi Everyone,

    We have sql server 2005(Enterprise edition 64bit) with 64GB RAM(Maximum server memory has set to 58GB in SQL SERVER side).

    Today all of sudden many tarnsactions on this server started to fail.When I checked the log I found the following error:"A significant part of sql server process memory has been paged out. This may result in a performance degradation"

    Is there anyway that I can find the cause of problem?

    Thanks

  • November 15, 2012 at 1:59 pm

    #1559527

    The operating system decided that it needed memory (maybe some process, maybe a file copy, etc) and paged SQL Server's memory to the swap file, which is a rather bad thing.

    You may want to consider locked pages in memory (consider and investigate, not implement immediately). Jonathan Kehayias has written a fair bit on the subject

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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