article thumbnail

Is Intel Doomed in the Server CPU Space?

SQL Performance

They will also have up to 256MB of L3 cache per processor. So far, we don't know the official base and turbo clock speeds, but there was a recent leak of partial specifications and pricing by a European retailer that listed max boost clock speeds of up to 3.4 There are many reasons!

Servers 46
article thumbnail

Batch Mode Bitmaps in SQL Server

SQL Performance

The details given here apply to SQL Server 2017 — the most recently released version at the time of writing. The SQL Server batch mode implementation of a Bloom filter is optimized for modern CPU cache architectures and is known internally as a complex bitmap. Features specific to earlier versions will mentioned inline as we go along.

Servers 75
article thumbnail

A Decade of Dynamo: Powering the next wave of high-performance, internet-scale applications

All Things Distributed

In support of Amazon Prime Day 2017, the biggest day in Amazon retail history, DynamoDB served over 12.9 In addition, DynamoDB Accelerator (DAX) a fully managed, highly available, in-memory cache further speeds up DynamoDB response times from milliseconds to microseconds and can continue to do so at millions of requests per second.

Internet 128