|
In Management Studio's Activity Monitor, (Current Activity > Process Info if using Enterprise Manager on SQL2000), there's a column labeled Net Address. One source I found says its the host's MAC address, though this doesn't seem right, as currently my three connections are represented with two different Net Addresses. Books Online says it's an:
Is this some value that SQL Server assigns to a connection, or can I trace it back to a specific machine on the network (in this case, the Host field is empty)?
(comments are locked)
|
|
I see this mapped to client_net_address in sys.dm_exec_connections in some searches. I'm not sure, but my guess is that this is a socket of some sort for network routing. It combines the MAC Or IP with some port to get a socket that allows it to be sure the correct results go to the correct connection. Possibly through a hash of some sort.
(comments are locked)
|
|
How many network cards do you have in your machine? Can you compare your multiple MACs with the net_address values you are seeing? I have 2 (one wired, one wireless) and I see 2 different net_addresses on my connections. This then ties up with what Steve said about client_net_address in sys.dm_exec_connections, as I have 2 IP addresses too. I have one physical network card and one on a virtual machine that's not running. The MAC address of the physical NIC (physical address as reported by Vista via an ipconfig /all) in no way corresponds to the Net Address that SQL Server shows. I also have several "tunnel adapter local area connection"s reported, but none of their addresses match; I'm not even sure what those are.
Oct 20 at 12:50 PM
ddavis
Mine don't either, I was just checking! Strangely enough though the net_address of those processes that are being run from the server have a matching MAC. True client connections must be a combo of the MAC plus port/socket as Steve suggests.
Oct 20 at 01:43 PM
Kev Riley ♦♦
(comments are locked)
|
