Avoid High Cpu Usage
You should
periodically monitor an instance of Microsoft SQL Server to verify that the
values of CPU usage is within the normal ranges. If
the rate is consistently high CPU utilization may be necessary to perform a CPU
upgrade or add additional processors. A
consistently high value of CPU usage can also indicate the presence of an
application does not properly designed or optimized. The
optimization of the application could reduce the CPU usage.An effective solution to determine the CPU usage is to use the counter Processor: % Processor Time counter in System Monitor. This counter lets you monitor the amount of time used by the CPU for the execution of a thread is not idle. If the value for this state is included between 80% and 90%, you may have to upgrade your CPU or add more processors. In the case of multiprocessor systems, it is necessary to monitor an instance of the counter for each processor. The value represents the total time of a specific processor. To determine the average of all processors, use the System Counter:% Total Processor Time.
Optionally, to monitor the processor utilization can also use the following counters:
Processor:%
Privileged Time
Indicates the percentage of time the processor for the Microsoft Windows kernel command, such as processing requests for I / O SQL Server. If the value of this counter is consistently high and the Physical Disk counters also have high values, consider installing a faster disk subsystem, or more efficient.
Processor: % User Time
Indicates the percentage of time the processor for execution of user processes, such as SQL Server.
Indicates the percentage of time the processor for the Microsoft Windows kernel command, such as processing requests for I / O SQL Server. If the value of this counter is consistently high and the Physical Disk counters also have high values, consider installing a faster disk subsystem, or more efficient.
Processor: % User Time
Indicates the percentage of time the processor for execution of user processes, such as SQL Server.
System: Processor
Queue Length
Indicates the number of threads waiting to be processed. If the threads of a process requiring a number of processor cycles greater than that available, there is a bottleneck at the processor. If a significant amount of processes attempting to use processor time, you may need to install a faster processor, or in the case of multiprocessor systems, add a processor.
CPU USAGE
Indicates the number of threads waiting to be processed. If the threads of a process requiring a number of processor cycles greater than that available, there is a bottleneck at the processor. If a significant amount of processes attempting to use processor time, you may need to install a faster processor, or in the case of multiprocessor systems, add a processor.
CPU USAGE
Labels: cpu processor
<< Home