I have a machine with two network cards, one a private connection to our SQL Server box, the other a public connection to our company network. When I log into SQL Query Analyzer using the IP address of the private connection, Enterprise Manager shows the MAC address of the public network card in the Current Activity window. This leads me to believe that I may be connecting via our public lan, which is slower. However, by using the private IP address, there is no way that could be possible. When I ping using the private IP (and the server name) it resolves to the correct lan (the private one).
Anyone have a similiar problem or suggestions I could try? I thought of disabling the public network card and try connecting again, but just wanted to see if anyone had come across this before. Could it be that Enterprise Manager is reporting the wrong MAC address? It does not happen on all of my machines, but some.