O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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

I/O Capacity Planning

One of the most common performance problems that we experience in the field is an undersized I/O subsystem. However, unlike CPU and memory sizing, it is fairly easy to add more I/O capacity. The I/O subsystem should be monitored constantly, and more capacity should added as needed. As with any sizing and capacity planning exercise, care should be taken to carefully monitor and assess your changing needs. Unlike CPU, Memory, and Network, the I/O subsystem problems leave a very specific indication within perfmon counters. This will be discussed later in this section.

Sizing the I/O Subsystem

As you have seen in earlier in this chapter, a disk drive can handle only a finite number of IOPS (I/Os per second). By monitoring the I/O ...

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