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