• Here's a couple of articles for you to look into it.

    http://bradmcgehee.com/2011/03/10/do-you-enable-lock-pages-in-memory/[/url]

    https://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/[/url]

    In my case, the only reason this option wasn't enabled was based on a MS article at the time saying it was no longer required. As it turns out it was.

    FWIW the SQLCAT team now recommend this be enabled as standard. If you do need to enable this setting, ensure you set you MAX Server memory to allow for enough OS space and any other over heads the system has.