Hi all,

for the last few months my site has randomly been crashing (sometimes 4-5 times a month) and every time my host fixes it by reseting the application pool.

My host has said:

[code]Regarding your application pool stuck issue, sometime excessive resource utilization of the server (generally when the site goes into loop) or if any connection is left unclosed like database connection.

In such cases the application pool stucks and the error shown is "Service Unavailable".

In this case I suggest you check your code and find out the section of code where there is a memory leak or looping structure[/code]

But i have no idea where to start - does any one know how I could try and find what is causing this?

My host seem to be blaming my code - but as i have never heard of this I have no idea what to ask them to try and figure out what is causing it.

Any help would be appreciated.

thanks
James

Hi James

Does the crashing appear to be random or when you are carrying out a particular task or visiting a certain section of the store?

It's a bit unfair for your host to say check your code, maybe they could have checked perhaps the error logs to see if there's any information there that acts as a pointer.

Are you running an Access or SQL database?

Andy

Please feel free to review / rate our software

Yeah I think my host is not being very helpful here...

I have not yet noticed any pattern, so it seems random...

However when it happened today, and they reset the app pool - i then had major issues with site crashing constantly, kept throwing up database connection errors...

I use an access database - its not a huge website, but looking at the db size it is 63Mb...

Do you think it could just be an overused DB?

First thing I would do is a compact & repair https://www.ecommercetemplates.com/help/troubleshooting.asp#asp10 it may sort it out and should get a small performance boost from it.

Andy

Please feel free to review / rate our software

Hi Guys,

Did the compact and repair on the access database as suggested (back in May), however the app pool issue has still happened several times since...

My host is not being very helpful at all - they are suggesting it is being caused by a database connection opening but not closing, and i have no idea how to find this.

I need to fix this as site is going down every week or two, and sometimes it happens at night so is offline for hours before I notice.

As I have no way of knowing what is causing this without going through every bit of code on my site - I was going to try two things:

1: buy SQL Server Creation Script (if problem persists then)

2: Change web host

is changing from access database a good or bad idea? what are the negatives?

I think it's probably a good idea and I can't see any negatives.

Andy

Please feel free to review / rate our software

Hi Andy,

how easy is it? do i just buy that script and "run it" or is there more to it?

It is very simple. Define a new database in your hosting control panel, copy those into details to db_conn_open.asp, set sqlserver=true in includes.asp and then run updatestore.asp from the server script. I would probably run the regular updater after that.

Andy

Please feel free to review / rate our software

Although it's probably fair to say it's easier to change host while you are still on Access, so you might want to make sure they provide you tools to get a solid database backup out of there and provide an easy escape route if you need it. Changing from Access is not a bad idea if you have some amount of traffic or products, but I doubt it will do much to help with application pool crashes.

FWIW we do have quality hosting for ECT in our London data center with none of that third world broken English support stuff you detailed above.

Peter

ServeLink
Professional ecommerce web hosting for ASP & PHP
https://servelink.com

Take a look at our image upload/resize tool for the ASP cart
https://servelink.com/clients/cart.php?gid=7

Hi All

Still having major issues with this (have not updated database to MySQL yet) - the hosts seems to be saying the issue is some kind of open database connection that is not closed...

Just checking if anyone knows any kind of tool or service that can scan an entire websites code to try and find where there is an opening of the database but not a closing etc...

Obviously I am aware this can not be the ect code as otherwise you have all have the issue - so its something i have done, but finding it manually is not working...

Let me know if anyone knows any tools for this.

thanks
James

to pete @ servelink

can you contact me with info about your UK hosting - I would be interested in dedicated server that is more than capable of handling ect stores etc...

Also need UK tech support - ideally via live chat 24/7?

please let me know details / pricing etc...

thanks
James

Moving to Servelink sounds like a very good solution and I know their pricing plans and the support there is very good.

Andy

Please feel free to review / rate our software