Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a Windows Hyper VPS plan with 1024 MB of RAM. After installing SQL Server 2008 Express, my memory usage went up to 75% without running my site yet. I know that SQL Server consumes a lot of memory, so I decided to host my DB on a shared server.

Which of the following is more scalable: install my DB on my VPS, or on a shared server ?

If the latter, then can you recommend me a good shared server? Thanks.

share|improve this question

SQL will consume up to about 90% of free memory regardless of how active it is, how much data it has, or the queries you throw at it. It's probably best to try the configuration you have now and stress test it to see how it performs. Then make a decision based on the results of that testing.

share|improve this answer
Does it do it by default because of the large page cache setting in the secpol.msc ? – Server System Specialist May 9 '11 at 2:17

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.