CCP_DeNormalized

CCP_DeNormalized



24 Jun

Comment

Close! 64 cores is right (we have SMT enabled, so 128 HT cores) but it has 2 TB of memory

Comment

It is a MS SQL server, and its not fun in any way to hint or think about the license cost :slight_smile:

Comment

We may have had a CPU spike just after failing over… but its all good now :slight_smile:

poc_db_server_cpu_ram_max_cpu1408×813 111 KB

Comment

I’m not sure :frowning: But things like that are not typically DB heavy


23 Jun

Comment

it would of been REALLY interesting to have the other socket populated the same - 128/256 ht cores and 4 tb of memory, hmmm!

Comment

this is 16x128gb modules for 2 tb :slight_smile: 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

Comment

No, I don’t think so :frowning: 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

Comment

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 :frowning:

Comment

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.

Comment

AMD!! We’ll see how 128 cores compares to 32 tomorrow!

Comment

close enough!! This is a R7525 with a single EPYC 7742

Comment

no, this is testing new db hardware for tq

Comment

some of those numbers are correct!

Comment

(post withdrawn by author, will be automatically deleted in 24 hours unless flagged)

Comment

It is a dell chassis, R7xxxx :slight_smile:

Comment

You can hold to the faith… it has significantly more ram and cpu cores than that :slight_smile:

Comment

We’re excited to test this in production tomorrow!! Anyone care to guess specs?? :slight_smile:

poc_db_server_cpu_ram4032×3024 1.47 MB


12 Jun

Comment

we now have it so your tq auth changes are reflected on sisi after 24 hours! You should be able to get in now.