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

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

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