Check CPU clock speed using WMI

The following simple WMI query can help you quickly check if the CPUs in your SQL server are using the maximum clock speed and are not in power saving mode.
 
The following works on Windows 2003 and higher:
 
wmic path win32_processor get CurrentClockSpeed, MaxClockSpeed, Name
 
image1
 
If you’re running Windows 2008 and higher, then there are some extra columns which may be of interest to you i.e.
 
wmic path win32_processor get CurrentClockSpeed, MaxClockSpeed, Name, NumberOfCores, NumberOfLogicalProcessors
 
image2

Leave a Reply