CCP DeNormalized

i sql in space!

[CCP DeNormalized @CCPDeNormalized]

@GlennAlanBerry @jfpoole It's a windows limitation - 64 logical cores per processor group.

We were trying for a single numa node 128 core EYPC test, but no dice

[CCP DeNormalized @CCPDeNormalized]

@CCP_Convict @BrentOzarULTD we're a year or so in on the new hardware and so far 4 tb of memory is still ok :)

[CCP DeNormalized @CCPDeNormalized]

@erlendur @stebets @BrentO @CCP_Explorer @CCP_RAM @KristjanFinn Observability into clock speed changes would be very nice! We are not tracking this currently, but perhaps we could somehow! Will investigate

[CCP DeNormalized @CCPDeNormalized]

@Rushlock @EveOnline Had so much fun with spelljammer back in the 2nd ed. days!

[CCP DeNormalized @CCPDeNormalized]

@PuiuCS @CCP_Explorer It is when you have to pay for the SQL licensing for those cores :)

Expect our DB Blog soon(tm) which discusses our AMD testing

[CCP DeNormalized @CCPDeNormalized]

@JadekMenaheim @CCP_Convict These lasers dealt no death i'm afraid :( When I cracked open the station hangar the dust was thick, no one had looked in on small army's worth of guns in many years

[CCP DeNormalized @CCPDeNormalized]

@Fuzzysteve @silvermoon82 We're getting close to being able to fit the entire DB in memory!

[CCP DeNormalized @CCPDeNormalized]

@CCP_Explorer our CPU graphs look much nicer now vs. the previous Friday's. Down from 50% to 20% and a much quicker leveling off as the simulation loads.

Across the board, we're seeing amazing reductions in wait times and IO latency. Lots more to be detailed in our upcoming Dev Blog

[CCP DeNormalized @CCPDeNormalized]

@darixzen @CCP_Explorer One of the best numbers of our tweaking so far - qd=254

Anyone care to guess what this is?

[CCP DeNormalized @CCPDeNormalized]

@CCP_Explorer It was a glorious day indeed! 199 seconds from shutdown starting at 11:00:00 to the very first character logged in

And we still have lots of tweaking to do on these machines and the SAN - records will continue to be broken in the coming weeks!

[CCP DeNormalized @CCPDeNormalized]

@flessuhh While I rarely get to use it in production, there is DB proc that is special to my heart - ClusterShutdown!

Sometimes though, the DB does spiral out of control on weird starts - This requires us to put it out of its misery, for the greater good

[CCP DeNormalized @CCPDeNormalized]

New DB = New Record!!! Today was the fastest shutdown/startup in recorded history!!

[CCP DeNormalized @CCPDeNormalized]

@hanneman9001 199 seconds - from shutdown starting at 11:00 to the first login

[CCP DeNormalized @CCPDeNormalized]

@CCP_Explorer @eXeler0n @ccp_aurora 2 only for HA in the primary cluster - our DR node will be upgraded later

[CCP DeNormalized @CCPDeNormalized]

@chribba @CCP_Explorer We did this a few times many years ago, I think they were sol servers from when we switched data centers for TQ Tech III.

Surprised you didn't get one - or yer just looking to add to the collection? :)

[CCP DeNormalized @CCPDeNormalized]

@CCP_Explorer I'll double check

[CCP DeNormalized @CCPDeNormalized]

@CCP_Explorer Even if this is how todays cold startup looked... I have faith we'll be online within the 15 DT window (no jinx no whammy!)

[CCP DeNormalized @CCPDeNormalized]

ooooo memory!! Om nom nom - new TQDB is HUNGRY!

[CCP DeNormalized @CCPDeNormalized]

@Fudster_ @Nakir_Eldrun I'm not sure they make memory chips in larger sizes :(

[CCP DeNormalized @CCPDeNormalized]

sooooon!! (tm)

[CCP DeNormalized @CCPDeNormalized]

@Fuzzysteve It has less cores than the EPYC we tested but more memory!

Intel based, dual socket/2 numa nodes and very very fast san ports

More details in upcoming devblog