O'Reilly logo

Professional Microsoft® SQL Server® 2008 Administration by Steven Wort, Ross LoForte, Wayne Snyder, Ketan Patel, Brian Knight

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

11.4. Optimizing the Server

The rest of this chapter covers optimizing the server. This includes the hardware and operating system configuration to provide SQL Server with the best environment in which to execute. The three key resources that you should consider any time you discuss optimization or performance are the CPU, memory, and I/O.

Starting with the CPU, there aren't a lot of options to play with here other than the number and type of processors. The only real configuration option to consider once the server is mounted in the data center is whether it is enabled for hyperthreading — that is, should you turn hyperthreading on or off? Other than helping you make the right decision about hyperthreading, most of this part of the chapter focuses on understanding the different processor attributes so you can make the right purchasing decisions.

Memory has more options, and it's a lot easier to add or remove memory (RAM) than it is to change the number or type of processors in a server. When you initially configure the server, you should have some idea of how much memory you might need and understand the available configuration options. These options are primarily for non-uniform memory access (NUMA) systems. On a NUMA system, you will often have the choice of using cell local memory or interleaved memory. In Windows 2003 32-bit systems, a number of boot.ini settings can affect memory configuration. These are settings such as enabling physical address extensions (PAEs), which ...

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