My application server is running SQL Server 2008 R2. OS is Windows 2008 R2 with SP1. Total physical memory is 16 GB.
When I looked into the Task Manager, the sqlservr.exe was using "6,734,588 K".
When I looked the Memory Setting, it's all default (see below).
It is obvious that the max memory can go as high as 2,147,483,647,000,000 in BYTES, which is more than the available physical memory.
How much is the recommended setting for typical server like mine?
My application sometimes throw "out of memory" error. I haven't linked that issue with the SQL Server, but I am trying to see what I can do in terms of memory usage.
If I changed the max memory setting, do I need to restart the SQL Server?