On a VPS that runs DB and IIS, should I limit the RAM used by SQL Server?

Posted by Donald Hughes on Server Fault See other posts from Server Fault or by Donald Hughes
Published on 2010-04-16T20:09:10Z Indexed on 2010/04/18 1:54 UTC
Read the original article Hit count: 566

I have a Windows 2008 R2 VPS with 1 GB of RAM. I'm using the VPS to run 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?

© Server Fault or respective owner

Related posts about vps

Related posts about sql-server