homepage Welcome to WebmasterWorld Guest from 54.167.238.60
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / WebmasterWorld / Webmaster General
Forum Library, Charter, Moderators: phranque & physics

Webmaster General Forum

    
Website gets down frequently
due to database connection limit
iloveu




msg:377144
 7:04 am on Jun 22, 2006 (gmt 0)

We have a couple of database-driven websites hosted by godaddy.com, we use MS SQL at backend. Recently, one major site gets more and more down time intermittently, it affects our online business seriously. I think the down time is mostly resulted from hosting server's database connection limit because the static page is always on but the static page shows "connection timeout". The site got a lot of down time before, so we upgraded the hosting service plan to the highest level, but now it seems the site approaches the connection limit again. How should we do? We just don't want to get the down time. If we upgrade the service to dedicated server, will the down-time problem be resolved?

 

mikeyb




msg:377145
 10:52 am on Jun 22, 2006 (gmt 0)

Are you sure you are closing all open database connections in your code?

A very easy way to reach the connection limit is to fail to close database connections at the end of scripts.

Easy_Coder




msg:377146
 12:45 pm on Jun 22, 2006 (gmt 0)

^ that and ask your host if connection pooling is enabled.

lovethecoast




msg:377147
 12:47 pm on Jun 22, 2006 (gmt 0)

Aye -- check on the two previous suggestions and also check to be sure you're not using the MSDE version. If you are, you may want to consider upgrading to Standard.

Easy_Coder




msg:377148
 5:08 pm on Jun 22, 2006 (gmt 0)

run this in query analyzer to see what version you're firing on
select @@version

iloveu




msg:377149
 8:12 pm on Jun 22, 2006 (gmt 0)

We actually checked all our source codes long time ago to make sure every db connection was closed. I called GoDaddy.com technical support guy, and he said there are simultaneous 150 connections for my site, which I think is not enough. So we decide to upgrade to virtual dedicated or dedicated server. Are there any guys using these services? Can anyone give me some suggestions? I am not familiar with web server configuration. Is it easy to configure web server?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / Webmaster General
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved