• If it were me, I would NOT set the lock pages in memory and I'd set a max memory value that would leave enough memory for the other Apps to run (and the OS !).

    Now if these other apps could grab huge amounts of memory and cause paging to occur on SQL server allocations I'd consider locking pages.But then if that were the case I'd also0 consider moving them to their own separate machines (virtual or otherwise).

    The probability of survival is inversely proportional to the angle of arrival.