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)
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 ?