Post reply

lock pages in memory in SQL Server 2016

  • April 10, 2018 at 1:39 pm

    #328279

    Hi,
    Does enabling "lock pages in memory"  in SQL Server 2016 is still recommended?

    Thanks

  • April 10, 2018 at 2:51 pm

    #1986228

    gary1 - Tuesday, April 10, 2018 1:39 PM

    Hi,
    Does enabling "lock pages in memory"  in SQL Server 2016 is still recommended?

    Thanks

    It's been debated for since 64-bit instances. This blog post is one side of the debate and he does mention the arguments for both sides:
    Great SQL Server Debates: Lock Pages in Memory

    That's the one I have bookmarked. I just searched on it and you can find quite a few other articles. On both sides of the debate. It may be like most other things - it depends. 

    Sue

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

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