O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Network Capacity Planning

The network is a slightly different case than the components discussed above. Network performance is important, but it affects SQL Server 2005 in a different manner than the other components. When executing a SQL statement, the CPU, memory, and I/O subsystems are all used extensively to execute that operation. Unless you are performing a distributed transaction or a query that includes a linked server, you will be accessing the network only during the beginning phase, when the query is submitted to the SQL Server database engine, and during the final phase, when the results are returned to the client. Thus, the execution of the query is not affected by a slow network.

Sizing the Network

The network is probably easier to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required