I've got a 2008 R2 SQL x64 and the sqlsrvr.exe is using 5gb of memory. I've limited the usage according to the info I've seen online: rigt
click ->server Properties-> memory-> set the Max memory
This did NOT lower the memory usage. Before you start saying 0 mem free on a server is the correct way
for a server to operate, this server has 16gb of memory and one simple database cannot be allowed to take up 5gb of memory. The SQL server is "supposed" to release memory as required by other programs but it isn't. The server locks up every week
because of this memory usage issue. I can turn SQL Express off completely and it has tons of free memo ...
Go to the complete details ...