Search code examples
sql-serverado.netsql-server-2008-r2network-traffic

Which Dynamic Management View exposes network traffic from/to one SPID?

I need to determine how much network traffic is being sent between a SQL Server 2008 R2 Dev Edition and an Ado.Net client running Win 7. I thought there should be a Dynamic Management View, but somehow I cannot find anything useful.

Solution

  • sys.dm_exec_connections:

    • num_reads Number of packet reads that have occurred over this connection. Is nullable.
    • num_writes Number of data packet writes that have occurred over this connection. Is nullable.
      ...
    • net_packet_size Network packet size used for information and data transfer. Is nullable.