I have a 2003 server running SQL 2008. multiple Users are intermittenly loosing connectivity to sql and to the server network drives.
I am trying to troubleshoot whether it is the server or the switch. What tools do you recommend.
THe server is runninig beautifully and the server event viewer is clean(no errors) and the riad 10 config says ok.
We recently had a drive fail but that has been replaced and the raid has been rebuilt successfully although it took 4 day to rebuild raid 10, 4X500gb drives.
Please help with any troubleshooting techniques you may have.
This issue is intermitten, one minute the network is snappy and responsive, the next i am kicked out of the server.
I would like to test the switch and see if it is intermittenly dropping packets.