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.

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

CPU Scheduler, CPU Threads, SQL CPU, SQL in Sixty Seconds, SQL Scripts, SQL Server
Previous Post
Shutdown SQL Server Via T-SQL – SQL in Sixty Seconds #163
Next Post
CPU, Linux and Shutdown – 3 SQL in Sixty Seconds Video

Related Posts

1 Comment. Leave new

  • SQL Server detected 8 sockets with 1 cores per socket and 1 logical processors per socket, 8 total logical processors; using 8 logical processors based on SQL Server licensing.

    socket_count cores_per_socket cpu_count
    24 1 24

    is this good configuration ?

    Reply

Leave a Reply

Menu
Exit mobile version