Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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