Get CPU Details – SQL in Sixty Seconds #164

What is your CPU Configuration? When I ask this question to my clients of Comprehensive Database Performance Health Check, I often get different answers. I totally understand that there is no one way to describe the CPUs and that is the primary reason, why I get a different answer when I try to get CPU details.

Let us learn in this video how one can get more details about their CPU.

When I am doing SQL Server Performance tuning consultation, I need to understand more about the logical processors. While the speed of the processor is important, the Maximum Degree of Parallelism is even more important.

Here are the scripts which I have used in the video to get CPU details.

Query reading error log

EXEC sys.xp_readerrorlog 0, 1, N'detected', N'socket';

Query using DMV

SELECT socket_count, cores_per_socket, cpu_count
FROM sys.dm_os_sys_info;

Let me know if you are interested to know more about this topic. I will write more blogs as well as create an SQL in Sixty Seconds video.

Here are my few recent videos and I would like to know what is your feedback about them.

• Shutdown SQL Server Via T-SQL – SQL in Sixty Seconds #163
• SQL Server on Linux – SQL in Sixty Seconds 162
• Query Ignoring CPU Threads – SQL in Sixty Seconds 161
• Bitwise Puzzle – SQL in Sixty Seconds 160
• Find Expensive Queries – SQL in Sixty Seconds #159
• Case-Sensitive Search – SQL in Sixty Seconds #158
• Wait Stats for Performance – SQL in Sixty Seconds #157
• Multiple Backup Copies Stripped – SQL in Sixty Seconds #156

Reference: Pinal Dave (http://blog.SQLAuthority.com)