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 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.
