Use sp_sysmon while making network configuration changes to observe the effects on performance. Use Adaptive Server Monitor to pinpoint network contention on a particular database object.
For more information about using sp_sysmon, see Chapter 8, “Monitoring Performance with sp_sysmon,” in Performance and Tuning Guide: Monitoring and Analyzing.
