• Steve Jones - SSC Editor (8/29/2014)


    select cpu_count from sys.dm_os_sys_info

    That's what SQL Server sees. Should be in the error log. SQL should use all available.

    It probably doesnt matter in this case as it is 2008 R2 and it is limited to processors not cores but if this was a 2012 or 2014 box wouldn't sys.dm_os_info still show 32 cpu but only 16 of those be used due to standard edition? wouldnt sys.dm_os_schedulers show just 16?

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]