When my Windows 2000 server is idle the whole processor is used by SQL Server 2000 and all switches and hubs on the network show collisions continuously. When some load comes on server it becomes normal. Can anybody suggest solution.
Try removing all network protocols except TCPIP and see what happens.
Also, make sure the OS knows what its local default gateway is ( open command prompt & type ipconfig /all ) , otherwise it may trying broadcasts to find other servers on the network and so give you lots of network traffic.