Post reply

CPU's

  • June 8, 2012 at 2:09 pm

    #262734

    How can I find out Current number of CPU cores on my sql server?

    Thank you

  • June 8, 2012 at 7:42 pm

    #1498996

    You can utilize the sys.dm_os_sys_info DMV to get this information:

    select cpu_count

    from sys.dm_os_sys_info;

    PowerShell:

    Get-WmiObject -Class Win32_Processor | Select-Object NumberOfCores


    Twitter: @SQLife
    Email: sqlsalt(at)outlook(dot)com

  • June 8, 2012 at 8:25 pm

    #1498997

    A useful information.

    Thank you too.

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

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