Once you have gathered the data, you can take advantage of several techniques that should improve network performance, including:
Using small packets for most database activity
Using larger packet sizes for tasks that perform large data transfers
Using stored procedures to reduce overall traffic
Filtering data to avoid large transfers
Isolating heavy network users from ordinary users
Using client control mechanisms for special cases
Use sp_sysmon while making network configuration changes to observe the effects on performance. Use Monitor Server to identify network contention on a particular database object.
See Performance and Tuning Series: Monitoring Adaptive Server with sp_sysmon.
