One of the things we usually forget as DBAs is that we need to check from time to time the CPU speed on our SQL Servers. In a perfect world we should not do it, but since the world is not perfect I will advice you to do so. This advice is not new, Brent Ozar wrote about it in 2010 and in SQL Server central you can find a nice article nice article on how to check your SQL Server on power saving mode using a WMI query. I got the WMI query from my friend Tricia Crighton, you need to run the WMI query on PowerShell. Here is the query:
gwmi -class win32_Processor | select currentClockSpeed, MaxClockSpeed
Published by
isalom
I was born in Barranquilla, Colombia in 1975. When I was 17 I moved to Curacao where I lived 10 years and then move to The Hague, The Netherlands. I speak 4 languages (Dutch, English, Papiamento and Spanish).
I'm a Systems Engineer graduated from The Hague University (http://www.thehagueuniversity.com/). I have been working in IT for over 15 years. Since November 2014 I started www.cenlinea.com a webportal were the focus is to make learning more fun. At Cenlinea we are currently promoting PLAYDIOM a new methodology to learn English. While currently working part-time time at Cenlinea, I am also working as Senior Princiapal Consultant at www.ccgroep.com which helps me to keep up to date with Microsoft SQL Server, which I consider to be one of my favorite things in life as it has changed my life in many ways.
I hope you enjoy my blog and if you want to send a question, just drop me a mail at ignacio.salom@cenlinea.com or ignacio@ccgroep.com
View all posts by isalom
More processor speed or more cores? The key issue is to understanbd the workload – there are many factors – check some notes on : http://www.sqlserver-dba.com/2013/01/sql-server-more-processor-speed-or-cpu-cores.html
On many occassions CPU can look slow , but it’;s waiting for disk
In this post I refer to CPU that are not running at their max speed, due to power saving settings. Your post is not about the same issue, but thank you for the information anyway.