hi team, we user 16 GB RAM in our sql server, and these days we have started facing a issue **There is insufficient system memory in resource pool 'internal' to run this query. Error: 701, Severity: 17, State: 65.** and we have decided to place a memory cap, but question is how to decide the maximum memory allocated to the sqlservr.exe thanks
Just as a comparison we have servers here that are running SQL Std 64bit with 2GB reserved for the OS and other processes and dont have any issues. I would be very wary of dropping below 2GB though, depending on OS and other applications/services that the server is also running.