A useful undocumented SQL Server command is DBCC sqlperf (netstats). It allows the DBA to monitor and report usage of network activity of the SQL Server Instance.

Reporing on network usage is useful in different situations, such as analysing communication between SQL Server and the the network

 The command are :

--issue the commnand to view the details
DBCC SQLPERF('netstats')

--clear existing statistics to start a new count
DBCC SQLPERF ('netstats', CLEAR);

 The output is :

Statistic |          Value

Network Reads  2.0427E+07

Network Writes  3.20437E+07

Network Bytes Read      -1.322977E+09

Network Bytes Written   -2.034788E+08

Command Queue Length            0

Max Command Queue Length     0

Worker Threads 0

Max Worker Threads      0

Network Threads            0

Max Network Threads     0

Read More

SQL Server – netstat monitoring and tuning performance - SQL ...

SQL Server - How to find Open Transactions

SQL Server – Current queries executing on SQL Server

SQL Server – network packet size - SQL Server DBA

Speed and Duplex settings - SQL Server DBA