Spotlight on SQL Server Enterprise 11.7 - Release Notes

Number of processors installed.

Speed of the processor(s) installed.

Type of processor(s) installed (Intel Pentium III, for example).

Shows how long it has been since Windows was started.

In a virtual environment the physical CPU of a host is shared by virtual machines and the hypervisor. Multiple processes may want to use the physical CPU of the host at the same time. The virtual machines may have to wait to be scheduled on a CPU.

Represents the total amount of CPU being used on the Windows server. It includes CPU consumed by all windows processes.

This component spins faster as CPU demands increase.

Shows the number of threads (program execution units) that are waiting on all processors to be run. A sustained processor queue length greater than ten can indicate processor congestion.

Shows the number of applications and services that are currently active on the system.)

Shows the number of memory pages per second that are being written to disk from physical memory, in order to free up physical memory.

The memory pages are checked first to see if they have been modified - if no modification has taken place, they are discarded.

This is a measure of the number of page faults per second on the system. This value includes soft faults and hard faults.

A page fault occurs when a process requires code or data that is not in its space in physical memory.

A soft fault is when a memory page is not in the physical memory of the process, but resides in another segment of physical memory.

A hard fault occurs when a memory page is not in the physical memory of the process, and has to be brought from disk.

Shows the rate at which cache pages are written to disk from memory, in order to satisfy a write through request (an application request to not write information to cache, but directly to disk) or a cache flush (a regular writing of data from the write-cache to disk).