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
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
Previous
Next