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 the Performance and Tuning Guide: Tools for Monitoring and Analyzing Performance book.
