How do i solve OUT of memory problem on VPS Hosting ,godaddy??

im hosting an ASP.net 3.5 on a VPS on godaddy , RAM are 512 MB
always w3wp.exe consume the whole memory as well as sqlservr.exe do,but CPU usage would be very low .
so when some visitors access the site, after a while  the application hangs and then it will give you service unavailable also sqlsrve process will be shut down ,then i have to restart the server
in event viewer errors are
Source:ASP.NET 2.0.50727.0
Event id=1309

also for MSSQL2005
im reciieving
There is insufficient system memory to run this query

my website url is
www.jo-auto.com

Please help me
kamal_2002Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

debuggerauCommented:
I'm wondering if you reduce the memory footprint of the SQL engine if that would help, but really 512 MB sounds too low for that setup.

http://blog.stevehorn.cc/2007/10/limit-memory-usage-in-sql-server-2005.html
0
Amandeep Singh BhullarCommented:
What i think 512 MB Ram is not enough for web server and sql.
You should think of upgrading the same.

Regarding .NET error please check
http://support.microsoft.com/kb/941386
0
kamal_2002Author Commented:
AmanBhullar:
my hosting is VPS windows server 2003 does the hot fix apply for it?
debuggerau:
what are the limits i should put for the memory

by the way when i was hosting my site on their shared hosting i didnt face any problem at all
Please advance
always memory usage for w3wp.exe is almost eating all the memory
but for cpu usage is very low
0
debuggerauCommented:
yes, windows will utilize (if possible) all the memory available to it..
I cant give you an exact figure in regards to memory allocation, as it may affect timeouts if too low and will be dependent on the size of the DB and its configuration. I'd start with 128 MB and experiment from there, but I feel your time is waisted on a VPS with only that much memory.

What was your shared hosting servers assets? esp memory..
And I doubt they had SQL + IIS on the same box..

And you say your CPU is very low, but I think that is because it is not utilized at all, and breaks easily. Have you done any load testing?

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kamal_2002Author Commented:
i think i should be moving from VPS to another Dedicated Server ,i review my code and it seems debug directive was enabled on the web.config ,also i was only closing the database connection but not Disposing them which i feel it may cause problems i will deploy my site and check if problem goes
Thanks all
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Networking

From novice to tech pro — start learning today.