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 ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
