a tip: I've seen this problem with a corrupt index on a SQL table. Look
for an improper index. There is no easy way to find the exact problem,
but you can see current processes in the EM.
Robert Shubert
Tronics
www.witangostore.com
Web Dude wrote:
>
> 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
