Question : The previous Senior DBA left the company and I was made aware of a server which suffers from […]
Tag: numa
Understanding MAXDOP behaviour for queries going parallel
Question : For my current server as below 4 Sockets with 10 cores per socket and 20 logical processors per […]
Is socket a synonym of NUMA, and virtual processor synonym of physical processor in a virtualized SQL server environment?
Question : Link: https://docs.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 basic concept of max dop and cost threshold. I am reviewing 3 SQL […]
NUMA configuration
Question : We have clustered servers, each of which has 32 CPU cores and 512 GB memory. The cluster is […]
How big of an impact does NUMA really have?
Question : I was reading up on Non-Uniform Memory Access (NUMA) and I was wondering how much of a difference […]
Why does dm_os_memory_clerks have MEMORYCLERK_SQLCLR values on one NUMA node?
Question : We are using a SQLCLR stored procedure for service broker activation, and I want to monitor the memory […]
NUMA config – sp_blitz output
Question : I’m trying to learn more about how SQL Server works with NUMA nodes as I noticed something in […]
Configure RAM for SQL Server and NUMA
Question : Accidental DB admin here. Question: Would you still manually limit max RAM for SQL Server even though the […]
Unable to start MongoDB with NUMA interleave
Question : When I login to Mongo Shell in my production server, running Oracle Linux v7, I see the message: […]
Does RSS Profile have an effect on SQL Server with NUMA setup?
Question : I’m curious whether the RSS Profile which is default NUMAStatic on Windows 2012 R2 could/should be changed for […]
- 1
- 2