I wonder if you have a sql statement that is causing a deadlock on the SQL Server which in turn is hold the thread, which then witango would open another thread until running out of the thread count.
Maybe you could increase tread count, due to a sql statement taking longer than expected due to increase in data. Just some thoughts Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-witango-talk@;witango.com] On Behalf Of Web Dude Sent: Monday, October 28, 2002 12:02 PM To: Multiple recipients of list witango-talk Subject: Witango-Talk: HELP What the heck?? Okay... 2 production servers. Server 1 NT 4.0 SP 6a IIS 4 Witango 2000 sp1 40 sites 1 gig RAM All security updates in place Server 2 NT 4.0 SP 6a SQL 7.0 1 gig RAM All security updates in place. Last Friday I was on server 2 just surfing when suddenly the computer pretty much froze. I went to the task manager (which took forever) and noticed the cpu being hogged by sqlserver.exe. I went to server 1 and noticed in task manager(which also took forever) that the witango server was hogging all the cpu. I managed to stop the witango server and immediately the cpu was freed. I restarted the witango server and about 15 minutes later, everything froze again on both servers. I haven't coded in the past week, so I don't think there is a coding problem in witango. Most of the sites have been up and running for the past 2 years, some have been up for 4 years or more. BUT suddenly I am having all sorts of problems. It seems the servers (both) are freezing 8 to 10 times a day. There are no email servers or email clients on these servers, so I don't think I have a virus (but not sure). I have used netstat extensively to see if I can find a wierd connection. I did notice however, that microsft transaction server seemed to have been started at about the time that I started getting these freezes. Not sure if this is related or not. I did reboot both machines several times that day. I am pretty sure that MSDTS is installed by default, even though I do not use it. I have looked at configuration files for witango, and all seems to be the way I left them. I have turned on logging to see if I can catch an offending taf file being executed, but it seems that the freezes are random. I have noticed, however, that whenever a freeze happens, I seem to get anywhere from 10 to 30 system reapers in the log file. Not sure if this is related. I have since shut down microsoft transaction server on server 1 (not even sure that I need it), but left it up on server 2. I need to know: Do I need the transaction server? Any other ways of trying to figure this out (it is driving me nuts)? Anything I should be looking for in the logs? Any Suggestions at all? -- ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
