sqlskills-logo-2015-white.png

Glenn’s Technical Insights For March 20, 2019

(Glenn’s Technical Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally relevant for SQL Server).

 

AMD Processors Not Vulnerable to SPOILER CPU Exploit

A new research paper (PDF warning) details a new speculative execution, side-channel CPU exploit that can dramatically speed up some previously known attack types. All modern Intel processors, going back to the original Intel Core architecture from 2006 are vulnerable to this exploit.

As the paper states:

“The root cause for SPOILER is a weakness in the address speculation of Intel’s proprietary implementation of the memory subsystem, which directly leaks timing behavior due to physical address conflicts. Existing spectre mitigations would therefore not interfere with SPOILER”

Intel was informed of these findings on December 1, 2018. AMD has released a short statement, where they confirm that their products are not vulnerable to SPOILER.

This is another piece of bad news for Intel. Initial analysis indicates that this exploit may be extremely difficult to patch at the software level. Patching at the microcode level could have a serious impact on performance.

Should You Be Worried?

That is a good question. Personally, I am more worried about more primitive, well-known attack methods, especially when it comes to SQL Server. Things like SQL injection attacks, applications using sys admin rights, and people running seriously unpatched systems. Getting those barn doors closed should be a much higher priority for most organizations.

What do you think? Were you concerned about the Spectre/Meltdown exploits in early 2018? Did you do any specific patching for that? I believe in digital “herd immunity” meaning that if a large percentage of the population does a good job of securing and patching their systems, it will help protect everyone. Plus, if you do a good job protecting your system, a higher percentage of lower skill attackers will look for an easier target.

 

Intel Demonstrates 100GbE OCP NIC 3.0 Adapters

At the Open Compute Project (OCP) Global Summit 2019, Intel showed and demonstrated several new 100GbE adapters that use the OCP NIC 3.0 form factor. These are relatively small daughter cards that easily fit horizontally in 1U servers. Intel is a little late to the 100GbE market, behind vendors like Mellanox. Despite this, having more vendors to choose from is a good thing. Intel did a short presentation about the OCP NIC 3.0 specification at the OCP Global Summit that you can watch here.

 

Intel Comet Lake Processors Coming Soon

With AMD’s 7nm Ryzen 3000 mainstream desktop processors getting closer to release (probably announced at the Computex 2019 show), Intel needs a competitive response for 2019. This appears to be a new 14nm Comet Lake family that may also be released in mid-2019. These are rumored to have up to 10 physical cores for desktop chips and up to eight physical cores for mobile chips.

It is unclear at this point whether these Comet Lake processors will work in existing Intel Z390 motherboards. Intel has a pretty mixed track record when it comes to backwards compatibility for motherboards, but perhaps they are changing their ways.

These processors should perform quite well on heavily multi-threaded workloads, and they will give you another alternative to jumping up to a more expensive HEDT system. This line of processors will have to compete with the AMD Ryzen 3000 processors.

AMD Ryzen 3000

Current speculation is that the 7nm AMD Ryzen 3000 series may have up to 16 physical cores in a mainstream desktop processor. The Ryzen 3000 series may also have better single-threaded performance than Comet Lake. If both of these rumors are true, it will be a huge achievement for AMD that will put a lot of pressure on Intel.

ryzen-3000-series-release

Figure 1: AMD Ryzen 3000 Desktop Processor

Healthy competition between Intel and AMD is good for consumers, and I hope it continues. Like many people, I was very tired of Intel rolling out annual product updates of four-core processors with very marginal performance increases. They had been doing this for the past 4-5 years, and they could get away with it because AMD just wasn’t competitive. That is no longer the case.

 

Intel Hires Kyle Bennet of HardOCP

Speaking of Intel changing their ways, they have hired Kyle Bennett (the founder of the HardOCP web site), starting April 1, 2019. He will be the Director of Enthusiast Engagement for their Technology Leadership Marketing group.

As a result, the HardOCP website will be “mothballed” with no new content. The HardForum will be demonetized and sold but will stay in operation. I have been a long-time reader of HardOCP, so I am sorry to see it essentially going away. This is a great opportunity for Kyle, and it is one piece of evidence that Intel is trying to change their image. This is similar to Ryan Shrout of PC Perspective going to Intel last October as their Chief Performance Strategist.

Leave a Reply

Your email address will not be published. Required fields are marked *

Other articles

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.