Post reply

Finding actual number of physical cpu installed

  • December 14, 2012 at 7:52 pm

    #266250

    Comments posted to this topic are about the item Finding actual number of physical cpu installed

  • January 14, 2013 at 6:56 am

    #1576865

    I like to check to see how many CPUs are online as well:

    -- cpu overview

    SELECT osi.cpu_count AS LogicalCpuCount,

    osi.hyperthread_ratio AS HyperthreadCoreRatio,

    osi.cpu_count / osi.hyperthread_ratio AS PhysicalCpuCount,

    (

    SELECT COUNT(*)

    FROM sys.dm_os_schedulers

    WHERE scheduler_id < osi.cpu_count

    AND is_online = 1

    ) AS LogicalCpuOnline

    FROM sys.dm_os_sys_info osi;

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • May 2, 2016 at 4:18 pm

    #1876113

    Thanks for the script.

  • May 2, 2016 at 4:19 pm

    #1876114

    Orlando Colamatteo (1/14/2013)

    I like to check to see how many CPUs are online as well:

    -- cpu overview

    SELECT osi.cpu_count AS LogicalCpuCount,

    osi.hyperthread_ratio AS HyperthreadCoreRatio,

    osi.cpu_count / osi.hyperthread_ratio AS PhysicalCpuCount,

    (

    SELECT COUNT(*)

    FROM sys.dm_os_schedulers

    WHERE scheduler_id < osi.cpu_count

    AND is_online = 1

    ) AS LogicalCpuOnline

    FROM sys.dm_os_sys_info osi;

    Nice, thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply