SQL server causing network collisions
Posted on 2003-12-08
I am the IT admin for a medium size NT domain running win2k server, win2k pro terminals.
The network architecture is thus:
3 networks -->
192.168.0.0 --> A network specifically to connect to my router, contains no client computers
192.168.1.0--> A network for _most_ users. Using RAS I am able to bridge this with the other networks seamlessly, making my server also a gateway.
192.168.2.0--> A network for administrative users, so that our bandwidth use is not affected by, and doesn't affect, other users...
As I said-Server runs win2k server, sp4. Also running MSSQL server 2000.
Whenever the SQL server is running for more than a few minutes, it somehow takes over the network and sends massive amounts of data to one or other of the networking cards...
I can see the network lights blinking like mad, and the only fix I have found is to disable MSSQL server and restart the machine... Please note, even disabling the network cards does not fix the issue, as it only switches the traffic to another device...
Any questions for me? If I can provide more information I will.