Post reply

Number of CPU cores used by SQL Server

  • July 29, 2016 at 6:31 pm

    #320199

    Hi,

    In one of our customer, they have SQL Server licensing based on CPU cores. I was wondering how I can check how many CPU cores have been utilized by SQL Server?

    Thanks,

  • July 31, 2016 at 7:06 am

    #1892812

    yujinagata72 (7/29/2016)

    Hi,

    In one of our customer, they have SQL Server licensing based on CPU cores. I was wondering how I can check how many CPU cores have been utilized by SQL Server?

    Thanks,

    run msinfo32 , you will get the specification of that server, by default SQL Server will be using all available processors.

  • July 31, 2016 at 3:29 pm

    #1892830

    If that number is for licensing purposes, then it's irrelevant how many SQL uses. You must license all cores visible to the OS.

    You can't use SQL's processor affinity to reduce the number of cores you need to license.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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