locked
SQL Server soft-numa RRS feed

  • Question

  • If the server has 2 socket and each has 8 phyiscal core per each. and enable hardware numa. So SQL Server 2016 will still do the auto-software numa configuration during startup ?
    Tuesday, August 11, 2020 3:00 AM

All replies

  • No, it won't. This is documented here: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/soft-numa-sql-server?view=sql-server-ver15

    "With SQL Server 2016 (13.x), whenever the SQL Server Database Engine detects more than eight physical cores per NUMA node or socket at startup, soft-NUMA nodes are created automatically by default."


    Tibor Karaszi, SQL Server MVP (Web Blog)

    Tuesday, August 11, 2020 7:35 AM
  • may I know it's physical core or logical core > 8 ?

    Tuesday, August 11, 2020 10:09 AM
  • may I know it's physical core or logical core > 8 ?

    I dont have confirm answer but if you read the document it says "physical cores"

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Tuesday, August 11, 2020 11:28 AM
  • may I know it's physical core or logical core > 8 ?

    It is in that article I linked to: "Hyper-threaded processor cores are not differentiated when counting physical cores in a node."

    Tibor Karaszi, SQL Server MVP (Web Blog)

    Tuesday, August 11, 2020 4:56 PM
  • so it detect physical core?

    so it's for physical environment or virtual environment?

    Tuesday, August 11, 2020 6:38 PM
  • run this so we know what you have

    SELECT os.memory_node_id AS [numa_node_id], sc.cpu_id, sc.scheduler_id , os.node_id, os.processor_group
    FROM sys.dm_os_nodes AS os INNER JOIN sys.dm_os_schedulers AS sc ON os.node_id = sc.parent_node_id
    AND sc.scheduler_id < 1048576


    jchang

    Tuesday, August 11, 2020 6:52 PM
  • Hi sakurai_db,

    >>so it detect physical core?

    Yes.

    >>so it's for physical environment or virtual environment?

    Yes. You can see the relevant information at the beginning of the error log.

    Best Regards,

    Amelia

    =======================================

    Please remember to click " Mark as Answer" and upvote the responses that resolved your issue. This can be beneficial to other community members reading this thread.


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    Thursday, August 13, 2020 8:31 AM
  • Hi sakurai_db,

    Did the answers above help you?

    Please feel free to let us know if you have any other question.

    If you find any post in the thread is helpful, you could kindly mark it as answer. This would benefit the community, and encourage the community member to keep working on your issues.

    Best Regards,

    Amelia


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    Friday, August 14, 2020 9:02 AM
  • Hi sakurai_db,

    Did the answers above help you?

    Please feel free to let us know if you have any other question.

    If you find any post in the thread is helpful, you could kindly mark it as answer to close this thread. This would benefit the community, and encourage the community member to keep working on your issues.

    Best Regards,

    Amelia


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    Wednesday, August 19, 2020 9:33 AM
  • Hi sakurai_db,

    >>so it detect physical core?

    Yes.

    >>so it's for physical environment or virtual environment?

    Yes. You can see the relevant information at the beginning of the error log.

    Best Regards,

    Amelia

    =======================================

    Please remember to click " Mark as Answer" and upvote the responses that resolved your issue. This can be beneficial to other community members reading this thread.


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    if physical cores, and then enabled hyper thread ?

    so the auto numa, is detecting logical core or physical cores ?

    if it has 4 physical cores 

    Friday, August 21, 2020 4:29 AM