High Network usage on SQL Server port Possible Duplicate:
  Find out what queries are causing the biggest amount of network traffic  




We are getting over 90 Mbps from SQL Server to each web servers on port 1433.


We are using connection pooling.
We have CLR Integration enabled.
We are running CDC.
We have snapshot transactions turned on.
We are using SQL Server 2008 R2 SP1


But when we get SQL Profiler on the case and remove all the Login and Logout events we are seeing low activity.

Any recommendation of getting great visibility on what's going over the wire?

Or are the Login and Logout events very chatty over the network?
We used Wireshark and SQL Profiler and were able to uncover an SP returning 700,000 records repetitively.

As far as we were able to tell then login and logout were part of connection pooling.