-1

Link: https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-2017#RDBMSSP

For NUMA Aware Large Page Memory and Buffer Array Allocation the table says No

And further below it says:

Standard Edition and SQL Server + CAL-based licensing can restrict how many processors SQL Server Standard can use, but SQL Server Standard is NUMA aware.

This question is to ask whether SQL standard edition (2016, 2017, 2019) has NUMA support because the table and the above quote show conflicting information.

The table for SQL server 2017 and 2019 say No without any quote. So was NUMA supported in 2016 and not supported in 2017 & 2019?

Links:

https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-2017#RDBMSSP

https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017?view=sql-server-2017#RDBMSSP

2 Answers 2

2

This question is to ask whether SQL standard edition (2016, 2017, 2019) has NUMA support [...]

Yes, it does. Take a few seconds to look at the errorlog and you'll find out. Simple repro, takes maybe a minute.

5
  • Yes I tried it on 2019 standard edition, but what's confusing me is that the above table says its not supported.
    – variable
    Oct 10, 2022 at 14:45
  • 2
    The table doesn't say NUMA, it says "NUMA Aware Large Page Memory and Buffer Array Allocation ". If your car takes 93 octane gas, you wouldn't say it doesn't take gas, you'd say it doesn't take anything lower than 93. Oct 10, 2022 at 14:51
  • It's not a simple repro if you don't have a SQL standard license installed on the target hardware already. I don't find the octane analogy to clarify things; if anything my understanding is that it would be similar to cars that take 93 octane gas but can still run on 87 with reduced performance (e.g. by retarding timing). In this analogy the car being a NUMA server, SQL Enterprise being 93 octane, and SQL Standard being 87
    – Mark Sowul
    Jan 9 at 12:41
  • I didn't make an octane analogy. I'm not sure what you're talking about. I also don't know why there needed to be a new answer to a question that was already answered a year and a half ago. Jan 9 at 15:28
  • There's a comment that says "If your car takes 93 octane gas..." I had the same question when preparing a new installation, and was hoping I could find the answer. Since I didn't find one, I did more research and added one. I suppose it was downvoted out of spite.
    – Mark Sowul
    Jan 18 at 2:52
-1

SQL Server Standard supports NUMA, in that it will run correctly on NUMA hardware; what this is talking about:

NUMA Aware Large Page Memory and Buffer Array Allocation

is "optimizing" for NUMA

See here for a related question: How to measure the performance improvement that NUMA brings?, this being the relevant piece:

Versions of SQL Server that are NUMA aware/optimized will try to keep memory usage within the same local NUMA node to avoid the hops [which hurt performance]...You can also track remote node access from perfmon using the SQL Server:Buffer Node\Remote node page lockups/sec counter.

It's not clear why they removed the clarifying language after SQL 2016

1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.