This site uses cookies to improve your experience. By viewing our content, you are accepting the use of cookies. To help us insure we adhere to various privacy regulations, please select your country/region of residence. If you do not select a country we will assume you are from the United States. View our privacy policy and terms of use.

Remove 2012 Remove Architecture Remove Cache Remove Retail
article thumbnail

Is Intel Doomed in the Server CPU Space?

SQL Performance

JULY 16, 2019

Intel officially moved on to what they call " Process- Architecture-Optimization (PAO) " in early 2016. This situation was so bad that Microsoft offered a 25% discount on the cost of SQL Server processor core licenses for SQL Server 2012 and SQL Server 2014, if you ran on qualifying AMD Opteron processors with six or more cores.

Servers 46
Servers Hardware Architecture Retail 46
article thumbnail

Batch Mode Bitmaps in SQL Server

SQL Performance

AUGUST 23, 2019

There have been major improvements since the first appearance of the batch mode execution engine in SQL Server 2012. 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. Bitmap Choice.

Servers 75
Servers Engineering Efficiency Retail 75
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

 

Stay Connected

Join 5,000+ Insiders by signing up for our newsletter

About
About
Editions
Editions
Topics
Powered by Aggregage | Terms and Conditions | Your California Rights and Privacy Policy
© Aggregage 2024