O'Reilly logo

MCITP SQL Server 2005 Database Administration All-in-One exam Guide by Darril Gibson

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

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

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