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 Components and Performance

The network can be divided broadly into two layers: the software layer, which houses the network protocols, and the hardware layer, which includes the network interface cards (NIC), cables, and so on. Each network layer has its own characteristics and performance considerations. There are several reasons for choosing a particular protocol or network hardware component. Usually, this choice is made based on your business rules and how each system is connected to the other systems in your network. In this section we’ll examine the software and hardware related factors that affect SQL Server performance.

The Software Layer

With the newer versions of the Windows operating system and SQL Server 2005, the software layer ...

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