EVE Online Dev Tracker

Hmm, looking back at my notes I don’t think we actually managed a full start!

We knew we could (we thought we could) if we disabled ESI to allow for a softer startup but I don’t think we went forward with that test.

sept 28, 2020 - * TQ failover testing on Intel28 - no luck - still fails after manual soft numa
sept 23, 2020 - * TQ Failover to Intel 28 - failure

AMD’s approach of a high number of cores doesn’t fit well with Microsoft’s licensing of SQL Server per core. I would love for Microsoft to measure volume, throughput, usage for licensing purposes somehow differently than just counting the cores.

That would be a massive undertaking; migrating all tables, views, functions, and stored procedures from T-SQL to PL/pgSQL, along with all monitoring, metrics, and institutional knowledge; and would therefore have to entail massive benefits.

Did we ever get EVE started on that 28C Intel box?

All production hardware is transferred to use for test servers for many years.

Probably never.

No.

(Post must be 5 characters, so here are more characters…)

I’ve not done any real in-depth checking into which is more stable.

They both seem fairly reliable though and I’d guess instability comes more from us changing things and bugs being fixed/introduced than actual underlining platform issues.

It’s difficult to baseline and compare things over time when the code base changes daily

we’re indeed heavily invested in stored procs - not to mention a few enterprise edition features of MSSQL - in particular table partitions for swapping out entire blocks of data for deletes.

Dev Teams are and have been using other database tech for their features for some years now however, so we’re far from ONLY using MS SQL.

There’s at least CosmosDB/PostGres and a few other cloud based managed DB services being used.

Horses for courses and such

Our next blog will focus on the software side, but you are right, it is Windows 2019 and it’s Standard.

I don’t think the DC version gives us anything unless its being used as a hypervisor host.

Next blog will focus on the software side of the database config with all that fun stuff.

Peak is around 15,000 while our average is around 8k.

We had another amd dual socket 8core cpu box in to play with but it ended up having weird hba issues so we had to rule it out.

There was also a single socket 28 core Intel box we tested - at the time EVE’s code base overran it mercilessly on cold starts. We could barely get the cluster started