Logging Of Conectivity IN SQL Server 2000

[BiggerD]

Can any of you bright sparks out there tell me where i can find out about what connectivity issues a server might be having. I specificaly want to know when it lost connectivity (such as if a cable has been unpuged etc)

Can anyone out there help? or if i can find them do i have to hire The A team?

 

[Catadmin]

Sparks? Ohhh. Another GirlGenuis fan I presume? @=)

Anynoddles, you'll need a network sniffer of some flavor to verify loss of connectivity on the network. SQL Server doesn't have any built in tools. However, most servers do have an OS option of Network Monitor (similar to Performance Monitor) that can be installed which gives basic network connectivity information.

Check with your network / hardware guys to see if this is installed and how to get it if its not.

Hope this helps.


Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"