SQLServerCentral Logo SQLServerCentral Logo
  • Articles
  • Editorials
  • Stairways
  • Forums
    • Forums home
    • Active threads
    • Latest topics
    • Most popular
    • Leaderboard
  • Scripts
  • QotD
  • Books
  • Blogs
  • Register
  • Login
  • Write for us
  • Menu
  • Articles
  • Editorials
  • Stairways
  • Forums
    • Forums home
    • Active threads
    • Latest topics
    • Most popular
    • Leaderboard
  • Scripts
  • QotD
  • Books
  • Blogs
  • Write for us
  • Register
  • Login

Home Forums SQL Server 2005 Administering memory error RE: memory error

  • Adam Bean

    One Orange Chip

    Points: 26631

    More actions

    March 20, 2008 at 12:36 pm

    #792184

    Hmm, with your responses I wouldn't be to alarmed about enabling lock pages in memory then, but it is still good practice to have it enabled.

    You may want to read up on these articles: http://blogs.msdn.com/psssql/archive/2007/05/31/the-sql-server-working-set-message.aspx

    http://blogs.technet.com/askperf/archive/2007/05/18/sql-and-the-working-set.aspx

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

    http://weblogs.asp.net/omarzabir/archive/2007/10/19/a-significant-part-of-sql-server-process-memory-has-been-paged-out-this-may-result-in-performance-degradation.aspx

    • About SQLServerCentral
    • Contact Us
    • Terms of Use
    • Privacy Policy
    • Contribute
    • Contributors
    • Authors
    • Newsletters
    Redgate logo