Monitoring the Network Interface

One area of possible congestion is the network card or network interface; it does not matter how fast the server’s work is if it has to queue up to go out through a small pipe. Remember that any activity on the server machine might be consuming some of the bandwidth of the network interface card. With the increasing implementations of gigabit networks and the increases in network bandwidth over wide area networks (WANs), network throughput is not as much of a bottleneck as it used to be. That’s not to say network performance issues do not arise. For example, a bad or misconfigured router can cause all sorts of network performance issues, especially if your users and your SQL Server are on different sides of the ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.