THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Joe Chang

Asymmetric Processor Cores

Most Intel processors use one of two cores, the main-line core and the Atom core. Desktop processors might use the newer Kaby Lake or Coffee Lake micro-architecture cores, while the Xeon SP lines uses the previous generation Skylake micro-architecture. All of these are part of the main core line. The Atom core is used in Xeon Phi, Atom and some Pentium or Celeron processors. In simple terms, the main-line is a big core and the Atom is a small core.

The obvious question is which is better: very many small cores or not quite as many large cores? The answer, as always, is: it depends. Workloads that are highly amenable to multi-threading do better on more smaller cores. This has to do with the second aspect of Moore's Law. Workloads that do not scale well with multi-threading may do better on big cores. It would seem that all we have to do is match the workload to the processor with the desired core type. For example, database transaction processing should scale well with cores and threads. And if so, then it is a match to the processor with very many small cores.

Except that life and databases are not simple. The main workload might be transaction processing, but there are also many other important activities that occur on the system. Some do not scale well on many cores and heavily favors the big core. Is the answer to this conundrum a mix of small and big cores?

A processor could have an asymmetric arrangement of small and large cores. In a large die, the could be both very many small cores and a small number of big cores all in one processor. The number of small cores is larger than the number of big cores that can be placed on a single die. A workload that does not scale well to high thread counts still has access to the large cores. Because this workload does not scale, there is no point in having many of the large cores.

Skylake Xeon SP and Knights Landing Xeon Phi

Below left is the Intel Skylake-based Xeon SP, XCC die and below right is the Knights Landing based Xeon Phi x200. Both die are just under 700mm2.

Xeon SP (Skylake), 694mm2Xeon Phi 200 (Knights Landing) 683mm2
5 rows, 6 columns, 28 cores max.7 rows, 6 columns, 2 cores/tile

Below is a layout representation of the Skylake XCC die. The Skylake XCC die has 5 rows by 6 columns minus 2 spots for the memory controllers, and excluding the top row for PCI-E and UPI elements, for a maximum of 28 big cores.


My rendering

Below is the layout of Knights Landing (KNL), organized as 7 rows by 6 columns of tiles, excluding the top and bottom rows for the MCDRAM controllers.


Two tile spots are used by the DDR memory controller, and two are used for PCI-E and DMI. This leaves 38 tiles. There are 2 Atom cores in each tile. The Xeon Phi x200 series has a maximum of 72 cores. Two tiles are spares used to improve manufacturing yield.

Below is a functional representation of the KNL tile. The sub-units may not be to scale. There are 2 cores, two double-VPU units, 1MB L2 cache shared by the two cores, and the agent which handles connections to other tiles and functional units.


As far as I am aware, the SQL Server core engine code does not use the vector (SSE/AVX) instructions. It would be a shame to waste so much silicon real estate on unused units. Either new instructions should be added to be useful in b-tree navigation or page-row-column offset calculation or the VPU should be removed from the mix core product. I gave a brief discussion on this in Rethink System Architecture.

Below is a simpler representation of the big core Xeon SP and little core Xeon Phi processors.

Xeon SP (Skylake), 694mm2Xeon Phi 200 (Knights Landing) 683mm2

Based on an eye-ball estimate of the die images, a mixed core processor could have four large cores and 30 tiles for double small cores in a slightly smaller die of about 670mm2, or 4 large and 36 tiles in a larger 750mm2 die. A representation is shown below.

Mix1, ~670mm2Mix2 750mm2
4 big cores, 30 tiles4 big cores, 36 tiles

The smaller option might be better because both Skylake and KNL processors are thermally limited? Other mix options are possible. The assumption here is that the big cores are for workloads that do not scale well at high thread count and hence there is a need for only a limited number of large cores. It is further assumed that some mechanism will be implemented to determine which type of cores handle each particular function or workload.

One option in having very many small cores is in how cores are allocated. Polling might be a better mechanism to handle extreme IO than interrupts. One or more small cores could be dedicated (and customized?) to kernel tasks like polling.


Matt Gillespie paper, "Preparing for the Second Stage of Multi-Core Hardware: Asymmetric (Heterogeneous) Cores", 2008


Intel also has the Quark core, 32-bit only, no MMX/SSE/AVX. It is based on Pentium.

A colleague sent this: Dark Silicon and the End of Multicore Scaling

Published Tuesday, February 20, 2018 11:50 AM by jchang

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Hikari said:

Very interesting! This remembers me of the failured Sony's Cell, with its SPUs that were hardly used.

Having Atom cores solves this issue, because they are all AMD64 that use the same instructions set.

It'd not be hard for OS escalators to analyse the workload of threads and place the most demanding ones on the big cores. IDK about lixux/POSIX, but for WinAPI it'd not be hard to add a new CreateThread with a new parameter to express the expected behavior of that thread.

February 28, 2018 7:07 AM

jchang said:

My thinking is the asymmetric nature of the cores is exposed via the OS API. SQL Server in turn would expose it via Resource Governor. Transactions that involve few rows would use the Atom cores, the big cores would run queries involving many rows, index rebuilds etc.

February 28, 2018 9:43 AM

brendom gell said:

Quickbooks can help small businesses to grow faster.It has many more features that other accounting software don't have.So this is very helpful accounting software to know more about this visit

April 30, 2018 12:37 PM

dora said:

July 17, 2018 3:47 AM

Nicolas said:

July 17, 2018 4:04 AM

Michelangela Camilla said:

August 14, 2018 3:43 AM

crazymichael said:

August 15, 2018 9:21 AM said:"> Balenciaga Shoulder Bags,"> Nike Air Force 1 Shoes,"> Nike Air Max Excellerate, Golden Goose,"> Golden Goose Superstar, Supreme,"> Common Projects Man,"> Valentino Sandals,"> Golden Goose Starter, Off White Shoes,"> Spain World Cup Jerseys,"> Golden Goose Ball Star,"> Air Jordan 6,"> Golden Goose Mid Star,"> Nike Air Max 90 Shoes,"> Golden Goose Ball Star,"> Nike Lunar, Off White X Adidas,"> Adidas Yeezy Boost 750,"> Golden Goose Mid Star,"> Golden Goose Slide,"> Moncler Women Coats,"> Golden Goose V Star,"> Valentino Slingbacks,"> Balenciaga Men Sneakers,"> Golden Goose Tennis,"> Golden Goose Mid Star, Golden Goose Mid Star, Golden Goose Starter,"> Golden Goose Francy,"> Supreme Scarf,"> Golden Goose V Star,"> Valentino Pumps,"> Valentino Pumps,"> Adidas Yeezy Boost 350 V2,"> Golden Goose Super Star,"> Adidas Pure Boost Dpr,"> Nike Free Run, Giuseppe Zanotti,"> Golden Goose Superstar,"> Valentino Slides,"> Golden Goose Starter,"> Nike Vapormax Shoes, Golden Goose May,"> Yeezy Boost 750,"> Adidas Yeezy Boost 350, Balenciaga, Giuseppe Zanotti Sneakers,"> Nike Flyknit Air Max, Common Projects,"> Valentino Sneakers,"> Valentino Slides,"> Adidas Eqt Support,"> Brazil World Cup Jerseys,"> Golden Goose V Star,"> Golden Goose Mid Star, Balenciaga Women Sneakers,"> Moncler Men Jackets,"> Balenciaga Backpacks,"> Balenciaga Caps,"> Nike Air Max,"> Golden Goose May,"> Golden Goose Tennis,"> Golden Goose Ball star,"> Golden Goose Starter,"> Nike Flyknit Racer,"> Valentino Pumps, Supreme Package Deals, Jimmy Choo,"> Golden Goose Ball Star,"> Golden Goose Mid Star,"> Golden Goose Ball Star,"> Golden Goose Slide,"> Moncler Women Jackets, Supreme Jackets,"> Golden Goose Francy, Jimmy Choo Heels,"> Air Jordan 3,"> Nike Free 3.0, Supreme Pants,"> Air Jordan Womens,"> Portugal World Cup Jerseys,"> Golden Goose V Star,"> Golden Goose Superstar,"> Moncler Men Coats,"> Golden Goose May,"> Valentino Sneakers,"> Balenciaga Tote Bags,"> Golden Goose May,"> Golden Goose Superstar,"> Valentino Flats, Common Projects Woman, Jimmy Choo Flats,"> Nike Air Max Shoes,"> Golden Goose Slide,"> Golden Goose May,"> Supreme Pant,"> Alexander Mcqueen Woman, Off White X Nike,"> Golden Goose Starter, World Cup Jersey,"> Valentino Pumps,"> Air Jordan Fusion, Adidas Yeezy Boost, Fashion Shoes,"> Valentino Ballerinas,"> Supreme Crewneck,"> Air Jordan 1,"> Nike Air Max TN Shoes,"> Nike Air Max 2017, Golden Goose Starter,"> Balenciaga City Bags, Yeezy Boost 350 V 2,"> Valentino Sandals,"> Nike Air Zoom,"> Nike Lunar Shoes,"> Supreme Long Tshirts,"> Nike Air Max 95 Shoes,"> Nike Air Huarache,"> Nike Free Run Shoes,"> Air Jordan DMP, Supreme,"> Moncler Men Vests, Yeezy Boost 350,"> Nike Air Max Thea Print,"> Nike Air Zoom Shoes,"> Air Jordan 13, Argentina World Cup Jerseys,"> Adidas Harden Vol 1,"> Adidas Shoes,"> Balenciaga Shoes,"> Nike Free 5.0,"> Air Jordan 9,"> Valentino Pumps,"> Moncler Scarves Hats, Golden Goose,"> Golden Goose Francy,"> Air Jordan 11,"> Adidas NMD Human Race,"> Nike Air Max 2017 Shoes,"> Nike Air Max 90, Supreme Shoes, Golden Goose, Golden Goose, Alexander McQueen Sneakers,"> Valentino Ballerinas, Golden Goose, Golden Goose 2.12, Balenciaga,"> Nike Roshe Run Shoes, adidas Yeezy, Golden Goose Superstar,"> Valentino Sandals,"> Nike Air Force 1, Golden Goose Woman, Supreme Package Deals, Golden Goose Superstar, Golden Goose Slide, Supreme Crewnecks,"> Golden Goose 2.12,"> Nike Free 4.0, Germany World Cup Jerseys, Golden Goose Francy,"> Air Jordan Shoes,"> Adidas NMD Shoes, Golden Goose,"> Nike Air Max 90 Sneakerboot,"> Valentino Slingbacks, Sport Shoes, Nike SB Shoes, Valentino Sneakers, Alexander Mcqueen, Nike Zoom Speed Trainer 3, Golden Goose Francy, Golden Goose 2.12, Nike Roshe Run , Air Jordan 6 Rings, Air Jordan 2,"> Valentino Slides, Golden Goose May,"> Golden Goose Francy, Air Jordan 4, Adidas Ultra Boost, Supreme Sweatshirts, Nike X Fragment,"> Moncler Kids Coats, Nike Air Max Dynasty Shoes, Nike Air Max Dynasty, Golden Goose Starter, Adidas Yeezy Boost 700, Golden Goose, Adidas Crazy Explosive, Golden Goose V Star, Golden Goose V Star, Moncler,"> Valentino Ballerina Flats, Air Jordan Spizike, Golden Goose Starter, Supreme Tshirt, Balenciaga Crossbody Bags, Yeezy Boost Infant, Moncler Women Vests, Supreme Shorts, Golden Goose Superstar, Valentino, Valentino, Alexander McQueen, Air Jordan 12, Nike Flyknit Air Max Shoes, Adidas Iniki Runner Boost, Golden Goose V Star, Supreme Hoodies,"> Valentino Pumps, Golden Goose Slide,"> Golden Goose Superstar,"> Valentino Boots, Supreme Bag, Golden Goose Starter, Off White X Vans, Nike Shoes, Air Jordan 8, Supreme T Shirts, Golden Goose Mid Star, Valentino, Off White Shoes, Adidas Yeezy Boost Infant, Golden Goose Francy, Balenciaga Clutch Bags, Golden Goose Ball Star, Moncler Kids Jackets, Nike Basketball Shoes, Golden Goose Ball Star, France World Cup Jerseys, England World Cup Jerseys, Valentino Flats, Nike Air Max 1, Valentino, Golden Goose V Star,"> Valentino Slides, Golden Goose Slide, Valentino Flats, Supreme Hoodie, Nike Air Max 1 Shoes, Adidas Yeezy Boost 350 V2, Nike Air Huarache Shoes, Nike SB,"> Golden Goose Francy, Nike Air Max Thea Print Shoes, Air Jordan 5, Moncler Kids Vests, Valentino Sneakers, Off White Accessories, Valentino Sneakers,"> Valentino Sneakers, Adidas Yeezy Boost 750, Valentino Flats, Golden Goose Man, Air Jordan 10, Nike Vapormax, Adidas Y3 Pure Boost, Valentino, Valentino Sandals, Nike Air Max 87 Shoes, Valentino Slingbacks, Supreme Shirt, Air Jordan 7, Valentino,"> Golden Goose V Star, Golden Goose Slide, Alexander Mcqueen Man, Valentino Sandals, Golden Goose Ball Star, Valentino Ballerinas, Golden Goose Mid Star, Valentino Sandals, Golden Goose Francy, Air Jordan CDP, Valentino Slides, Golden Goose, Golden Goose May, Supreme Jacket, Nike X Fragment Shoes, Adidas Harden Vol 2, Valentino Ballerinas, Adidas Dame 4, Golden Goose Slide, Nike Air Max 87, Golden Goose, Golden Goose Slide, Golden Goose May, Valentino Flats, Nike Air Max 95, Golden Goose

September 5, 2018 6:55 AM

happy wheels said:

The information you give about this asymmetric processor is very detailed, I see many effects.

September 14, 2018 2:57 AM

Leave a Comment


About jchang

Reverse engineering the SQL Server Cost Based Optimizer (Query Optimizer), NUMA System Architecture, performance tools developer - SQL ExecStats, mucking with the data distribution statistics histogram - decoding STATS_STREAM, Parallel Execution plans, microprocessors, SSD, HDD, SAN, storage performance, performance modeling and prediction, database architecture, SQL Server engine

This Blog


Privacy Statement