Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning sql pages out before hitting low memory RE: sql pages out before hitting low memory

  • March 18, 2013 at 10:47 am

    #1598113

    SQL doesn't page out it's own memory. The OS may page SQL out if its under memory pressure. Older versions of the OS (Server 2003) were more agressive about this, later versions are a lot less prone to page SQL out.

    You can enable locked pages, but then make very sure you're leaving enough memory for the OS.

    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