How to Monitor SQL Server Network Traffic

Question

I want to monitor the network traffic used by each transaction with Microsoft SQL Server, for example when a query ran on the SQL what was the size of the request & the response as it passed through the network interface.

Are there any tools which do this, especially free tools?

Answer 1

Wireshark, filter capture on port 1433:

host [your sql server's ip] and port 1433