More CPU Competition Coming for Intel

On January 9, 2019, AMD CEO and President Dr. Lisa Su presented a CES 2019 Keynote where she demonstrated (at 1:25:00 in the video) a 7nm, eight core/sixteen thread, 3rd Generation AMD Ryzen “Matisse” desktop processor running the Cinebench R15 Multithreaded (MT) benchmark vs. a 14nm, eight core/sixteen thread Intel Core i9-9900K “Coffee Lake” desktop […]

How to Check if Your Processor Supports Second Level Address Translation (SLAT)

If you want to run Docker for Windows, you will need to be running Windows 10 Professional, Windows 10 Enterprise, Windows 10 Pro for Workstations, or Windows 10 Education Edition. Since Docker for Windows requires Microsoft Hyper-V, you will also need a processor on your host machine that supports second level address translation (SLAT) in […]

CPU Upgrade to AMD Ryzen Threadripper 2950X

About a year ago, I built a high-end desktop (HEDT) workstation based on the then, top-of-the-line 14nm AMD Ryzen Threadripper 1950X processor. This is the machine that I use for most of my daily work, and I have been quite happy with it over the past year.  Here are the main components that I used […]

AMD EPYC 7371 Processor in Q1 2019

At the Supercomputing 2018 Conference, AMD announced a special high-frequency SKU in their first-generation 14nm AMD EPYC “Naples” line of server processors that will be the AMD EPYC 7371 processor. This upcoming processor will have 16 cores and 32 threads, with a base clock speed of 3.1 GHz, boosting up to 3.6 GHz on all […]

Building a Modern AMD Desktop Development Workstation

Over the past 12-18 months, it has become relatively easy to build an extremely powerful AMD desktop development workstation, with plenty of compute, memory and storage performance and capacity to support some pretty serious workloads. You can also build a system for a relatively affordable cost, compared to what you had to spend in years […]

AMD Ryzen Threadripper 2990X CPU-Z Leaks?

On June 5, 2018, during the Computex show in Taiwan, AMD revealed some details about its upcoming 12nm 2nd generation Ryzen Threadripper processor family that will have up to 32 physical cores (and 64 threads with SMT) that will work on existing X399 motherboards. These processors will also have the 2nd generation Ryzen features like […]

Checking Your Meltdown and Spectre Mitigation Status in Windows

As I have previously discussed, there has been an explosion of information and speculation about the Spectre and Meltdown vulnerabilities. Here is the official information about all three vulnerabilities. Spectre CVE-2017-5753 (Bounds Check Bypass) CVE-2017-5715 (Branch Target Injection) Meltdown CVE-2017-5754 (Rogue Data Cache Load) Checking Your Meltdown and Spectre Mitigation Status in Windows Microsoft has […]

AMD Ryzen Threadripper HEDT on August 10, 2017

If you have been thinking about buying/building a new desktop development/testing machine that has enough resources to run multiple concurrent large virtual machines or a large SQL Server workload, you might want to consider an AMD Ryzen Threadripper-based machine. AMD is doing a hard launch of this processor family on August 10, 2017. The two […]

CPU-Z 1.80 is Available

CPU-Z 1.80 was released on July 10, 2017. It adds support for the new Intel Skylake-X and Kabylake-X high-end desktop processors (HEDT). It also adds information about your preferred core(s) in the Clocks dialog on the About tab. In case you are wondering what that means, some of the latest Intel processors have a new […]

SQL101: AMD EYPC 7000 Series Processors

As Kimberly blogged about earlier this year, SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see done incorrectly, technologies used the wrong way, or where there are many misunderstandings that lead to serious problems. If you want to find all of […]

SQLskills SQL101: SQL Server Core Factor Table

Over the past couple of months, SQLskills has embarked on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that we often see done incorrectly, technologies used the wrong way, or where there are many misunderstandings that lead to serious problems. If you want to find […]

SQL Server 2014 Hardware Analysis Case Study

Imagine that you have been given the go-ahead to upgrade your entire data platform stack from SQL Server 2008 Enterprise Edition to SQL Server 2014 Enterprise Edition. You need to come up with a recommendation for your new database server hardware, looking to maximize performance while controlling your SQL Server 2014 license costs. To help […]

New AMD-based TPC-E Benchmark Result

HP recently submitted a TPC-E benchmark result for a two-socket HP ProLiant DL385p Gen 8 system that is using two 2.8GHz AMD Opteron 6386SE, 16-core processors. This system had a score of 1416.37 TpsE, which does not sound too bad until you compare it to a very similar two-socket HP ProLiant DL380p Gen 8 system […]

A SQL Server Hardware Tidbit a Day – Day 29

For Day 29 of the series, I will talk about AMD Turbo CORE technology. AMD Turbo CORE is a technology that was first introduced in the AMD Phenom II X4 desktop processor, but the way AMD implemented it in the Bulldozer family and Piledriver family of processors is greatly enhanced. AMD Turbo CORE is similar […]

A SQL Server Hardware Tidbit a Day – Day 27

For Day 27 of this series, I am going to talk about Power Management and its effect on processor performance. I have written about this subject a couple of times before, here and here. Other people, such as Paul Randal (blog|Twitter) and Brent Ozar (blog|Twitter) have written about this subject here and here. Power Management […]

What is the Difference Between Physical Sockets, Physical Cores, and Logical Cores?

I witnessed an interesting conversation on Twitter today where someone was talking about how he uses the terms sockets and cores interchangeably, since everyone else does, or words to that effect. This made me think that there may still be some confusion about how these terms are used and what they mean in relation to […]

Hardware 101 Presentation in Bellevue, WA – August 14, 2012

I recently had the opportunity to give a one hour presentation called Hardware 101: An Introduction to Database Hardware during the evening, after a full day of SQLskills Immersion Event 2 (IE2) training. Even though it was an evening event, after almost 10 hours of intense training that day, nearly all of the students stayed […]