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 ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.
