The are something wrong with our system lately that the application hangs from time to time. I am not 100% confident what it's causing this but one thing I am sure our database server is under powered, where we store the session variables. When the DB server is slow, our application hangs... However, when the DB server backs to normal, we have to restart the cold fuion service manually anyway. Besides buying a new DB server, what should I do to prevent this? I thought it's going to restart itself because:
I have the following settings in the administrator page.
Limit simultaneous requests to 10
Timeout requests after 1200 seconds
Restart at 10 unresponsive requests
Restart when requests terminate abnormally
Are they good settings? I am also thinking about restart the application service once every night, just to clear any cumulative memory leak from previous days or maybe just for fun ... Is there a way to do it?