CPU Capacity Planning
The CPU performance is a finite entity within the computer system. There are a finite number of CPUs in a system, and each CPU has a finite number of CPU cycles that can be used per second. Fortunately for us, there are CPU counters available in the Windows Performance Monitor, or perfmon. These CPU counters provide utilization information based on 100 percent utilization. In this section we will look at sizing CPUs and monitoring CPU utilization.
Sizing CPUs
Sizing CPUs is the process of allocating a sufficient number and type of CPUs so that normal On-Line Transaction Processing systems operate at less than or equal to 75 percent CPU utilization. This is so excessive CPU queuing does not occur and response times are reasonable. ...
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.
