I'm running SQL Server 2008 and a web based application, on a single dedicated server, with only 2Gb of memory available.
As is noted elsewhere, SQL Server regularly takes up to 98% of physical memory, which appears to slow down the web application running on the server.
In Server Properties in SSMS, under Memory, Maximum Server Memory (in Mb) is set to: 2147483647
My question is, what would be the recommended number to put in the maximum server memory box, given the amount of memory I have available, and that the same server is also running the web application?
Additionally, is it safe to make a change to this number, while SQL Server is running?
Thank you for your advice.