CHAPTER 6 Server Infrastructure Design

In this chapter, you will learn about:

• Core server resources (memory, disk, processor, and NIC)

• Processor affinity

• A review of RAID and RAID implementations with SQL Server 2005

• System Monitor

• Server design considerations

• Automating deployment of service packs and patches

• Linked servers

It is the greatest mistake of all to do nothing because you can do only a little. Do what you can.

—Sydney Smith

This chapter focuses on the server infrastructure and some design considerations you'll need to consider when building a server. Once we put enough processing power and memory into a system, the next biggest bottleneck is the disk subsystem. RAID implementations allow us to optimize the disk subsystem. ...

Get MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444) now with O’Reilly online learning.

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