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?