by
0
6
1,943
0
Top 1% !
Popular
Famous
Tagged
Easy-to-find
Specified
Popularity: 10774th place
This snippet is Public
DBMSMS SQL Server
LanguageSQL
LicenseMIT_X11

Finding actual number of physical cpu installed

By Rahul Singh, 2013/01/14

The Sql Server always see Logical cpu it does not distinguish between Hyperthreaded logical cpu and physical processor using the below query we can find out actual number of physical cpu installed on the server

The first column represent logical processor and second column represent actual  physical processor  installed
Copy Embed Code
<iframe id="embedFrame" style="width:600px; height:300px;"
src="https://www.snip2code.com/Embed/616/Finding-actual-number-of-physical-cpu-in?startLine=0"></iframe>
Click on the embed code to copy it into your clipboard Width Height
Leave empty to retrieve all the content Start End
SELECT cpu_count AS Logical_CPU_Count , cpu_count / hyperthread_ratio AS Physical_CPU_Count FROM sys.dm_os_sys_info ;
If you want to be updated about similar snippets, Sign in and follow our Channels

blog comments powered by Disqus