Have you checked your SQL Server CPU speed lately?


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

Advertisements

2 thoughts on “Have you checked your SQL Server CPU speed lately?

    1. 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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s