Hello,

Thank you kindly for the great article.

One question. (On a 64bit 2008 R2 Standard Server w/ paging file on much slower disk than data) Lets say the service account is set to lock pages in memory in attempt to avoid page swapping. The hope is that all pages will be read from memory to avoid paging file reads on slower disk. However, if the SQL Server is already under memory pressure and can't offload buffer to paging file could that potentially cause more issue than allowing the slower reads?

I have a prod server that is already under a great deal of memory pressure (causes already known). My concern is that if the instance can't offload to the paging file it might further increase this memory pressure.

Is it that when lock pages in memory is set SQL Server will handle / reuse / free up space more efficiently than if it was off, therefor not actually further increasing memory pressure? Apologies if my question is silly or misguided.

Thank you,

GP