Close! 64 cores is right (we have SMT enabled, so 128 HT cores) but it has 2 TB of memory
Close! 64 cores is right (we have SMT enabled, so 128 HT cores) but it has 2 TB of memory
It is a MS SQL server, and its not fun in any way to hint or think about the license cost
We may have had a CPU spike just after failing over… but its all good now
I’m not sure But things like that are not typically DB heavy
EYPC 7742, yup
it would of been REALLY interesting to have the other socket populated the same - 128/256 ht cores and 4 tb of memory, hmmm!
this is 16x128gb modules for 2 tb it would have been 4 tb of memory but the vendor said all 256gb chips were sold out worldwide.
but correct on the dual sockets / unused memory slots
No, I don’t think so The DB typically isn’t a bottleneck in big fights. But this will likely help with slowness for the first while post-startup and also on busy weekends the current DB struggles.
Market is one of the big things that should be snappier with this type of change
in the near future we’ll also test more traditional setups - dual socket, 8 core CPU’s from intel/amd - this will match our current 32 cores, with as you say, max cpu performance.
We’ll do a devblog later and have more info on what we’re measuring with more cores/less numa nodes, etc…
And licensing is a giant thing
we’ll do a dev blog for sure
The core of the simulation is still on Windows (DB and Sol Nodes). This particular server is Win 2019 - and I hear you with lots left on the table, but not just with linux. SQL Server in general really benefits from tuning to the workload being thrown at it.
AMD!! We’ll see how 128 cores compares to 32 tomorrow!
close enough!! This is a R7525 with a single EPYC 7742
no, this is testing new db hardware for tq
some of those numbers are correct!
(post withdrawn by author, will be automatically deleted in 24 hours unless flagged)
It is a dell chassis, R7xxxx
You can hold to the faith… it has significantly more ram and cpu cores than that
We’re excited to test this in production tomorrow!! Anyone care to guess specs??
we now have it so your tq auth changes are reflected on sisi after 24 hours! You should be able to get in now.