Chapter 2Architecture and Tools

When the proper planning is complete and SQL Server 2005 is installed, it is time to configure the system for production use. To properly configure and maintain the landscape, you need a sound understanding of how SQL Server operates. In the first part of this chapter, I focus on the many architectures within SQL Server that affect the transfer of data into and out of the system, including the processing engines, memory, I/O, and the networking layer, which has changed since previous versions. Depending on the edition, SQL Server 2005 does not have the TCP/IP protocol enabled, making the system “secure by default.” I show you how to enable that protocol (and others) in this chapter. I explain the path that a query ...

Get Administrator’s Guide to SQL Server 2005 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.