I have been told by someone who ought to know that setting Max Memory
on a SQL server instance through the Properties-->Memory tab in SSMS
has no effect in the above environment. Is this correct?
We have a Windows 2008 R2 box with IIS 7.5 and SQL 2008 R2 x64 on it
and I want to ensure SQL doesn't grab all the memory leaving IIS and
the .NET service struggling. Do I need to do anything or is the memory
management up to the task these days?