Questions tagged [numa]
NUMA refers to "Non-Uniform Memory Access", and is a technology for providing RAM that can be accessed faster by the local core or CPU than it can be by other cores present in the computer.
44
questions
0
votes
1
answer
380
views
Is socket a synonym of NUMA, and virtual processor synonym of physical processor in a virtualized SQL server environment?
Link: https://learn.microsoft.com/en-US/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option?view=sql-server-ver15#Recommendations
I understand the ...
3
votes
1
answer
563
views
NUMA configuration
We have clustered servers, each of which has 32 CPU cores and 512 GB memory. The cluster is home to 7 instances of SQL Server 2012 Standard Edition.
With Standard Edition allowing a maximum of 64 ...
0
votes
0
answers
56
views
Two NumaNode0 on SQL
we encountered one mysterious problem. After adding 6 more processors to our database server, from 6 to 12, we are unable to adjust the processor settings on any of the instances.
We are now running ...
-1
votes
2
answers
192
views
Whether SQL standard edition has NUMA support?
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 ...
24
votes
3
answers
1k
views
Does CPU utilization affect the cost of foreign NUMA access?
Scenario
Let's assume I have a SQL Server with 4 sockets with each 1 NUMA node. Each socket has 4 physical cores. There is 512 GB of memory total so each NUMA node has 128 GB of RAM.
A key table is ...
10
votes
3
answers
2k
views
Configure RAM for SQL Server and NUMA
Accidental DB admin here.
Question:
Would you still manually limit max RAM for SQL Server even though the sole purpose of that server is to serve SQL Server database engine only?
I have Microsoft ...
1
vote
0
answers
120
views
Can you help clarify my server's NUMA configuration?
I have a SQL Server 2022 Enterprise instance in a VMWare VM. We upgraded this instance last week from Standard to Enterprise and I want to now make sure we use the appropriate instance level setting ...
1
vote
1
answer
324
views
How to reduce latency with fast short queries in Postgresql 15.3 on a NUMA server
We're running two different versions of Postgresql on two separate servers:
Server A: Postgresql 9.3
Server B: Postgresql 15.3
Server B is way more powerful than server A:
Server A: 1x Intel Xeon ...
4
votes
1
answer
779
views
NUMA Nodes - MAXDOP - PLE
We have a server with 8 CPUS across 2 NUMAs with hyperthreading enabled. Currently Maxdop is set to 8, but actually should be set to 4 as per the Maxdop section of this article:
https://support....
16
votes
2
answers
3k
views
Why is SQL Server setup recommending MAXDOP 8 here?
I'm running SQL Server 2022 RC1 setup on an AWS i3.16xlarge with 2 sockets, 2 NUMA nodes, 32 logical processors per node, 64 logical processors altogether.
Setup is recommending MAXDOP 8:
But if you ...
-3
votes
1
answer
94
views
When accessing memory, whether is it slower or faster to access central memory access vs via non-local access (NUMA - interconnect NUMA)?
Link: https://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/solutions/sql-server-on-vmware-best-practices-guide.pdf
This architecture having ultimate benefits also poses some trade-offs
...
0
votes
2
answers
93
views
How to limit which NUMA nodes are used by SQL Server / SSRS?
I have SSRS and SQL Server running on same physical server (2 NUMA nodes).
How do you configure SQL Server and SSRS to use separate NUMA nodes?
I just didn't want SQL Data Engine to potentially ...
0
votes
1
answer
176
views
Testing SQL Server with NUMA architecture
I just learned some NUMA related knowledge and I want to know:
Is NUMA a bad thing for SQL Server? I ask because this Microsoft employee said that:
Basically fewer nodes is better, but there's a ...
-2
votes
1
answer
567
views
NUMAnodes and SQL Server performance
Pretty sure I understand this, but wanted to be sure I do.
We have a SQL Server 2016, that is running with 2 NumaNodes, each with 8 vCPUs. The Max Degrees of Parallelism (MAXDOP) is set to 8.
This ...
1
vote
1
answer
994
views
Check auto-numa is enabled
I run query
select cpu_count, hyperthread_ratio, softnuma_configuration, softnuma_configuration_desc
from sys.dm_os_sys_info
and got results, where said, that numa is off:
cpu_count ...
0
votes
1
answer
1k
views
What is the num of NUMA nodes for MAXDOP calculation when there is discrepancy between various ways to count the NUMA nodes?
Querying the dm_os_performance_counters shows that I have 2 NUMA nodes:
select *
from sys.dm_os_performance_counters
where object_name = 'SQLServer:Buffer Node'
and counter_name = 'Page life ...
-2
votes
1
answer
789
views
Does tempdb recommended count depend on the total processors on the computer or on the processors in a single NUMA node?
The number of secondary data files depends on the number of (logical)
processors on the machine. As a general rule, if the number of logical
processors is less than or equal to eight, use the same ...
6
votes
1
answer
1k
views
SQLServer 2016 continually increasing stolen memory
We are experiencing a slow growth of Stolen Memory on our database servers over the space of several days. It appears to plateau around 130-140GB, at which point we start having larger problems such ...
21
votes
1
answer
5k
views
Anyone use SUMA, trace flag 8048, or trace flag 8015?
Recently included SQL Server startup Trace Flag 8048 to resolve a serious spinlock contention issue in a SQL Server 2008 R2 system.
Interested to hear from others who have found usage cases where ...
0
votes
0
answers
127
views
SQL Server Numa config - Why is VAS reservered memory different on each numa mode? [closed]
I have a virtual machine running on hyper-V. The VM has 26 processors assigned to it and 300 GB of RAM.
The underlying physical server has 2 CPU sockets, both with 8 cores each.
Looking at the NUMA ...
2
votes
0
answers
380
views
Confounding NUMA configuration in SQL Server for 24 vcore system in Azure
I need some help understanding how SQL Server takes a 24 core VM and displays it as 11 NUMA nodes under properties.
At startup, this is the key message about hardware SQL Server found:
SQL Server ...
3
votes
1
answer
233
views
NUMA config - sp_blitz output
I'm trying to learn more about how SQL Server works with NUMA nodes as I noticed something in the output of sp_Blitz that I didn't understand:
Node: 0 State: ONLINE Online schedulers: 8 Offline ...
1
vote
2
answers
1k
views
MySQL swaps on system with more than enough RAM
Om my new dual AMD EPYC 7401 24-Core (128G RAM) MySQL starts swapping even after a restart with no data in memory.
NUMA
# numactl --hardware
available: 8 nodes (0-7)
node 0 cpus: 0 1 2 3 4 5 48 49 ...
1
vote
1
answer
225
views
Setting MAX memory for SQL servers depending upon the model of CPU
I have a general question regrading setting up the MAX SQL memory settings-
For our current CPU with below specs, server team bumped up OS memory from 400GB to 1TB:
Intel® Xeon® Processor E5-4640 v2 ...
1
vote
1
answer
3k
views
Using NUMA Nodes with SQL Server
I have a question to understand better how NUMA nodes help in SQL Server:
In our current set up, we have 4 NUMA nodes with 20 cores and hyper threading enabled, making a total of 40 logical ...
1
vote
2
answers
1k
views
SQL Server Virtualization best practices - NUMA, HT, Cores vs Speed
We run on Cisco UCS + VMware ESX + HP 3PAR.
Host blade config :
UCSB-B200-M4 , Xeon E5-2667 v3 3.1GHz , 2 sockets , 8 cores each, Hyper-Threading Active
So total 16 physical cores, or 32 logical ...
2
votes
1
answer
186
views
Understanding MAXDOP behaviour for queries going parallel
For my current server as below
4 Sockets with 10 cores per socket and 20 logical processors per socket.
Total 80 per SQL licensing: 4 NUMA nodes with HT enabled
I've set CTOP 50 and MAXDOP 8 on ...
2
votes
1
answer
1k
views
Numa Node configuration for SQL server 2016
I have a question on one of my new build sql servers where we are planning to migrate our SQL databases from older SQL2012 running on windows 2012.
New build- SQL2016 on Windows 2016
My current [...
1
vote
1
answer
974
views
Memory distribution across numa nodes within Sql server
I need to understand following behavior of memory distribution across numa nodes within sql server
Current set up:
2 node cluster SQL server 2014 SP2 with virtualization disabled
We have 4 NUMA ...
3
votes
2
answers
695
views
MAX NUMA/ "Affinity" in SQL Server
Is there now, or possibly in the works a way to tell SQL Server to stay inside one NUMA node, either server wide or at the query level? Basically the same functionality as MAXDOP, but MAXNUMA?
...
0
votes
0
answers
331
views
Affinity Masking
One of the servers I'm responsible for now was set up under the wrong license so can only use 40 cores on the server. This has led to an imbalance in the NUMA node schedulers. I'm planning on using ...
3
votes
1
answer
2k
views
SQL Server not using all NUMA memory with 20 core limit and affinity mask
I have a physical SQL Server 2016 SP1 machine with this spec:
CPU Sockets: 2
Cores per socket: 44
Multithreading: Yes
Number of cores: 88
RAM: 256 GB
SQL Server Max Memory: 240 GB
...
7
votes
1
answer
2k
views
automatic soft NUMA results in odd number of cores
I ran sp_blitz on one of our SQL Server 2016 production servers and one of the findings was that there were CPUs with an odd number of cores. The detailed message indicated this is a really bad NUMA ...
1
vote
1
answer
560
views
Unable to start MongoDB with NUMA interleave
When I login to Mongo Shell in my production server, running Oracle Linux v7, I see the message:
WARNING: You are running on a NUMA machine.
To address this, I have used the init script as ...
8
votes
1
answer
4k
views
SQL Server detected 2 sockets with 4 cores per socket but only one NUMA node
We have a SQL Server 2012 SP 2 CU 8 instance in a VMWare host. The operating system is Windows Server 2012 R2.
Windows Task Manager says that we have two sockets and 8 virtual cores. This number ...
3
votes
1
answer
1k
views
One NUMA node uses all memory
I am running a SQL 2012 SP3 CU9 Standard server with 2 CPU's each having 4 cores (hyperthreading enabled). I have 384 GB RAM (Yes I know that I cannot use it all in SQL standard). Lock pages in memory ...
10
votes
2
answers
1k
views
Low PLE on NUMA node 000, high on 001
I'm looking at PLE (Page Life Expectancy) across NUMA nodes on our SQL Servers, and came across a rather weird distribution. NUMA node 000 has a very low PLE compared to 001. I'm unsure why this is. I'...
4
votes
2
answers
1k
views
4 CPUs of 20 (NUMA node 0) Pegged at 100%
The previous Senior DBA left the company and I was made aware of a server which suffers from multiple problems, largely slowness (all the way from SSMS taking a long time to open, long running queries,...
0
votes
3
answers
2k
views
Memory(buffer pool) not populating on mysql start on Percona 5.6.28
We are testing Percona 5.6.28 at the moment, during our testing we found out even though the innodb_buffer_pool_populate is set to ON, it doesn't populate the memory(buffer pool) during mysql start.
...
2
votes
0
answers
343
views
SQL Server 2012; Incorrect PLE buffer manager value for NUMA server
We are receiving PLE alerts from SCOM for several instances.
These instances are on hardware servers, and use NUMA nodes. SQL Server 2012 SP1 CU7 Enterprise Edition is installed. Memory is fixed and ...
8
votes
1
answer
2k
views
Does RSS Profile have an effect on SQL Server with NUMA setup?
I'm curious whether the RSS Profile which is default NUMAStatic on Windows 2012 R2 could/should be changed for SQL Server with a NUMA setup.
Has anyone done performance benchmarks on high load SQL ...
8
votes
1
answer
2k
views
Why does dm_os_memory_clerks have MEMORYCLERK_SQLCLR values on one NUMA node?
We are using a SQLCLR stored procedure for service broker activation, and I want to monitor the memory used by the CLR code. Looking at sys.dm_os_memory_clerks, I see that only NUMA node 1 has any ...
2
votes
1
answer
1k
views
How to measure the performance improvement that NUMA brings?
I am testing how one of our stored procedure is working on SQL Server Standard vs SQL Server Enterprise editions.
I have created two virtual machines and install a SQL Server(SQL Server 2014) and ...
5
votes
1
answer
267
views
How big of an impact does NUMA really have?
I was reading up on Non-Uniform Memory Access (NUMA) and I was wondering how much of a difference it can really make? Another way to word that, what level of throughput is required before this ...