The theme of the lecture will be focused on a journey which was necessary to get to the needed performance level at very high concurrency. This is a real personal story which happened while building one of the features in the SQL Server Engine. This experience was full of learning which happens only on projects that have an extreme demand, therefore, it's not very common in the industry.
The goal was to have less than 5% performance regression on TPC-C benchmark. The machines at the time were up to 80 physical cores, with 4 NUMA nodes. Although the task to be performed was very trivial, things didn't work as expected.
General computer science and computer architecture