Re: database slowing down after few hours

I had this same problem several years ago. I do not know if you are having the same problem, but ours was caused by the cool screen savers. Someone had turned on the pipes screen saver - everytime the screen saver came on the system would slow down. When we went to check on the system - everything started to work right. Took the NT administrators 3 weeks to determine that the screen saver was taking 100% of a CPU.

You might want to look for a program (not nec. a screensaver) that could be running in the back ground.

At another client, we had the a simular problem with inbound packets. The network card started to refuse the packets. The card was a 3Com card, but I do not think that had anything to do with it. When the card was replaced everything started to work ok.

Thanks,
Bryan Lenihan

Prosibel wrote:

> We have a lan with one NT4 Server and a few Win95 workstations. We use
> TCP/IP and Netbeui, CentreCOM 3624TR 10Base-T HUB/repeater and UTP cable.
> The server is running : Oracle7 Workgroup Server 7.3.2.2.1 and a database
> written in Visual Basic.
> The Win95 workstation is running : database clients software, Oracle7 16bit
> ODBC Driver 2.0.3.1.1 and Oracle SQL*Net Client 2.3.2.1.4.
> First, the database works fine but after a few hours the responses are
> getting very slow. When using TNGPing : every 7th ping i receive something
> of 3400 or 9700 ms ! (regular Ping gives 1-10ms tho...)
> The server has enough memory and the processor activity is normal.
> The strange thing is : when i REBOOT the server, everything is back to
> normal ! TNGPing gives 0 - 60ms. The database is working fine. After a few
> hours ... everything slows down again!
>
> Anyone got a clue ?
>
> Kris
Received on Fri Feb 06 1998 - 00:00:00 CST