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 16, 2009 at 1:19 pm

    #1067147

    Jeff Moden (10/16/2009)

    Heh... wouldn't a reasonable alternative be to only have SQL Server on the SQL Server box? 😉

    Unfortunately not. I've heard of a case where SQL was the only thing installed on the box (other than OS) and and it was still getting paged out if max memory was set about about 60% of the total memory. This is a server with >16GB.

    Suspicion was a driver bug, but couldn't be sure.

    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