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.