Post reply

licence is Core based .. we have 16 logiceal cpu but sql is using only 4 . how to fix it

  • September 16, 2015 at 8:13 am

    #311557

    licence is Core based .. we have 16 logiceal cpu but sql is using only 4 . how to fix it

  • September 16, 2015 at 2:15 pm

    #1827221

    What is maxdop set to?

    Are you using resource governor?

    Have you set processor affinity?

    just to verify how many CPUs SQL Server is recognizing,what does query below return?

    SELECT cpu_count,hyperthread_ratio,scheduler_count

    FROM sys.dm_os_sys_info

    you can also check the error log from when sql server was started for a message similar to this

    Detected 4 CPUs. This is an informational message; no user action is required.

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

  • September 16, 2015 at 3:53 pm

    #1827248

    Where are you seeing that SQL is only using 4 cores?

    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

  • September 21, 2015 at 1:15 am

    #1827994

    the above querry shows only available Cpu online as 4 only ..

    Hi Gail

    in the error message it shows..

    16 processors with 16 core is detected ..sql is 4 cpu only , this is informational message

  • September 21, 2015 at 1:17 am

    #1827995

    i found out that

    actually VM is configure as 1 core per CPU hence 16 core 16 cpu

    And std edition suooprts 4 cpu only .. hence we need to reconfigure 1 cpu = 4 core ..

    That what i learned from googeling some websites.

    Thanks

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

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