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

Posted by Donald Hughes on Stack Overflow See other posts from Stack Overflow or by Donald Hughes
Published on 2010-04-16T20:09:10Z Indexed on 2010/04/16 20:33 UTC
Read the original article Hit count: 202

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?

© Stack Overflow or respective owner

Related posts about vps

Related posts about sql-server