In which of the following two cases, OS can pressurize SQL to release memory.
Suppose a VM has 6Gb RAM
If I set sql MAXMemory to 3Gb (without setting Lock pages in memory), would OS be able to free some memory from sql if it needs.
If I set sql MAXMemory to 3Gb (And also set Lock pages in memory), would OS be able to free some memory from sql if it needs.
Can OS really pressurize SQL to release memory? I have not encountered any such issue when using non-default value in MAXmemory setting.
Thank you in advance