• Why would anyone run any other application on a SQL server? Especially one with large databases like this?

    I've had really good results with lock pages in memory. I've never done it on SQL 2016 but running older SQL on bare metal hardware it was almost a necessity. Otherwise all the HP crapware you have to run on HP servers take up memory and you'll see periodic errors about it being pooled out or something like that. Forgot the exact error. Haven't seen it on vmware with vmtools, but it can still happen.

    When I ran into this problem we would get periodic issues with SQL and memory issues. Once we enabled lock pages in memory they went away.