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
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
Discover more from SQL Authority with Pinal Dave
Subscribe to get the latest posts sent to your email.
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 ?