On a VPS that runs DB and IIS, should I limit the RAM used by MS SQL Server?
- by Donald Hughes
I have a Windows 2008 R2 VPS with 1 GB of RAM. I'm using the VPS to run MS SQL Server 2008 Express and IIS 7.5. I've noticed that SQL Server tends to use as much memory as it can, to the detriment of other applications (and this makes sense with a server is dedicated to running SQL Server). Should I set a limit? If so, what would a reasonable level be?