Well, the SQL errors stopped after they rebooted the host server.
We've seen our host boot the server we're on at least 3 times in the last month.
Yesterday, I had to re-login at least 6 times and session info was lost a lot.
so I contacted them again, and go this very nice detailed response!
(BTW - what does the thread number mean in this case??)
Hello Bill,
I monitored you resource usage for about a half hour and in that time I only saw
your worker process recycle twice due to hitting the memory limit in place. I also
checked the number of threads for your worker process and your site by far had the
most activity on the entire server for the time I was monitoring your resource usage.
I will have to put some scripts in place to monitor the total thread count for the
day but I suspect that your site is the most heavily visited on the server. At one
point your worker process was handling over 115 threads, at which point your worker
process recycled due to reaching the memory limit.
Here are the recycle events from the system log:
A worker process with process id of '9260' serving application pool
'theamcforum.com(domain)(pool)' has requested a recycle because it reached its
private bytes memory limit. 12:52:53pm
A worker process with process id of '3372' serving application pool
'theamcforum.com(domain)(pool)' has requested a recycle because it reached its
private bytes memory limit. 12:40:52pm
A worker process with process id of '7452' serving application pool
'theamcforum.com(domain)(pool)' has requested a recycle because it reached its
private bytes memory limit. 11:51:47am
As you can see from the log data the only times there is a reset is due to the
memory limit in place.
I checked for other heavy resource users on the server and there simply are not any
that have a high enough resource usage to cause a problem as the current memory load
on the server is only about 60% which is well within normal operations for a web
server.
Based off of my observations from monitoring your site resource usage and the number
of threads your worker process is raising I would really suggest looking into a
dedicated server, even the entry level one as it would provide you with the greatest
flexibility for your site.
--
Best Regards,
Bill King
System Admin Team - Windows and Linux Junior System Administrator I