• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1238
  • Last Modified:

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
0
kamal_2002
Asked:
kamal_2002
  • 2
  • 2
1 Solution
 
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
 
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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now