What is the major perpetrator that cause high CPU load? too many database(db) connections/user sessions? Or db connection accidentally left open (especially in the servlets). Or is it just a simple case of too many page hits/web traffic, hence a signal for a better dedicated hosting package with more RAMs/CPU power/JVM size ?
Q2) Will restarting Resin every few days be a good temporary solution? We need to keep the site (with paid members) running, so I plan to do this around midnight, 2 times a week.