Home Forums SQL Server 2017 SQL Server 2017 - Administration SQL Server 2017 not setting affinity for all processors in system RE: SQL Server 2017 not setting affinity for all processors in system

  • December 29, 2017 at 1:58 pm

    #1973893

    dnwobu - Friday, December 29, 2017 1:47 PM

    2017-12-29 14:08:48.83 Server  SQL Server detected 2 sockets with 24 cores per socket and 48 logical processors per socket, 96 total logical processors; using 96 logical processors based on SQL Server licensing. This is an informational message; no user action is required.

    Ok, my first assumption was wrong. I thought it was a licensing problem.

    Have you confirmed that SQL's not using those processors? Check the processor load, check sys.schedulers

    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