Using sp_sysmon while changing network configuration

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.