Home Forums Article Discussions Article Discussions by Author Discuss content posted by Amit Kumar Singh Poor Man's Enterprise Feature - Lock Pages in Memory RE: Poor Man's Enterprise Feature - Lock Pages in Memory

  • October 15, 2009 at 9:37 am

    #1066350

    Steve Vassallo (10/15/2009)

    What about SQL 2008? Is this an option there?

    Yes.

    SQL 2008 SP1 CU2 allows locked pages on standard edition. Good reference for this topic is the PSS Engineers' blog

    http://blogs.msdn.com/psssql/archive/2009/05/19/an-update-for-standard-sku-support-for-locked-pages.aspx

    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