THE SQL Server Blog Spot on the Web

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

Joe Chang

Quick performance check with latest patches

there is some degree of press hysteria, lawsuits etc. concerning the kernel vulnerabilities of Intel processors with out-of-order execution (which originates to Pentium Pro), so I did a quick check.

Earlier, I posted on testing with the TPC-H database and queries at scale factor 100 (in conditions that do not meet official TPC-H standards). The test system is a single socket Xeon E5 2630 v4, 10 core, 64GB memory, SQL Server limited to 32GB, 4 Intel P750 NVMe SSDs for storage. The baseline test was SQL Server 2016 SP1 (probably prior to SP1 cu1) The current test has latest Windows Server 2016 hotfixes and SQL Server 2016 SP1 cu7 build 4466

Sum run time of the 22 TPC-H queries at SF100 database, row-store, no compression was 0.7% longer than before, CPU was 0.2% higher. The total database size is 126GB, so there was considerable IO, mostly scans, but some key lookups.

Note TPC-H scoring is geometric mean, which means small queries need to scale as well

I use straight sum because I am more concerned about big queries, as I do not expect small queries to scale well at high DOP, if at all.

Individual query variation range from: Q2 43% longer, from 0.67 to 0.963 sec, there is a loop join, which would do 8K IO?

Q18 17.8% faster, from 51.5 to 42.3 sec, might be a different execution plan, could be due

There were 4 queries between 20-28% slower, but because Q18 was one of the big queries, its improvement washed out the high percentage impact of the smaller queries

From the description given of the fixes, my expectation is that performance impact will be seen in operations that involve kernel, which include disk and network IO. I would except loop joins and key lookups to be more impacted that scan IO because of the number of IO,

and also network round-trip intensive applications, i.e., the ones that people said not to do.

Edit (Jan 11)
never mind the above
I had recently set my test system to power save,
so in the proper configuration of power - performance (Edit Jan 12, this result was with turbo boost enabled, original was disabled)

linear sum, SQL Server 2016 sp1 cu 7 bld 4466 and OS patches vs sp1 base
9% faster, 12% more CPU efficiently
individual queries range from 24% faster to 0.3% slower.
there probably is a penalty in the recent fixes, but fixes since SP1 also made improvements?

Edit Jan 12
original test was done with turbo boost disable, above test was turbo boost enable, probably running at 2.4GHz versus 2.2 base
new test in (my best estimate) matching conditions except for hot fixes
latest SQL Server 2016 PS + cu about 1.7% faster, 7.6% lower CPU
some queries 5-9% slower, a few much faster - probably with better execution plan, hence not related to recent security issue

It does look like the ability to drive network round-trips is severely impacted. I seem to recall that a stored proc, 1 row index seek, from a 40GbE, 1 thread used to drive 11K round-trips per sec, now 7,900,
peak throughput used to be 270K/s, now 146K/s?
I need to find my old records to see if I can clear this up

Published Thursday, January 11, 2018 10:07 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



Vapor Max said: Women'S Nike Air Max Womens Nike Air Max Womens 2017 Nike Shoes Vapors Vapormax Pas Cher Vapormax Nike Vapormax Flyknit Vapormax 2018 Vapormax Vapor Max Nike Vapor Max Vapor Nikes Shoes Nikes Nike Vapour Max Nike Vapormax Triple Black Nike Vapormax Price Nike Vapormax Flyknit Nike Vapormax Nike Vapor Max Shoes Nike Vapor Max Nike Vapor Fly 4 Nike Vapor Air Vapormax Air Vapor Max Air Nike Air Maxvapor Air Max Zero Air Max Vapormax Air Max Vapor Max Air Max Vapor Nikes Nike Vapour Max Nike Vapormax Triple Black Nike Vapormax Price Nike Vapormax Flyknit Nike Vapormax Nike Vapor Max Shoes Nike Vapor Max Nike Vapor Fly 4 Nike Vapor Women'S Nike Air Max Womens Nike Air Max Womens 2017 Nike Shoes Vapors Vapormax Pas Cher Vapormax Nike Vapormax Flyknit Vapormax 2018 Vapormax Vapor Max Nike Vapor Max Vapor 2018 Vapor Max Yeezys Shoes Yeezy V2 Yeezy Shoes Zebra Yeezy Yeezys Boost 350 V2 New Yeezy V2 New Yeezy Yeezys Boost 350 V2 Yeezys Boost 350 Yeezy Boost 350 V2 Outlet Yeezy Zebra New Yeezys New Yeezy V2 New Yeezy Uk Moncler Coat Uk Moncler Moncler Uk Online Moncler Uk Moncler Uk Outlet Moncler Uk Moncler Jacket Outlets Moncler Jacket Moncler Uk Jackets Moncler Jackets Goose Down Jackets Canada Goose Uk Nfl Jerseys Nfl Jersey Cheap Nfl Jersey Nfl Jersey Cheap Nfl Jersey Nfl Cheap Jerseys Cheap Nfl Jerseys Cheap Nfl Jersey Nhl Jerseys 2018 Nfl Jerseys For Sale Nfl Jerseys Cheap Nba Jerseys Cheap Nba Jerseys 2018 Nba Jerseys Cheap Jerseys Cheap Jersey 2018 Us Cheap China Jerseys 2018 Worldcup 2018 World Cup Soccer 2018 World Cup Russia 2018 World Cup Russia World Cup Football 2018 World Cup Football World Cup 2018 Warriors Jersey Nba Warriors Golden State Warriors Michael Kors Factory Sale Michael Kors bags Michael Kors Jordan Air Cheap Jordan Shoes Air Jordan Shoes Air Jordan Asics Shoes Asics Yeezy Zebra Yeezy Yellow Yeezy V2 Boost Yeezy V2 Cheap Fitflop Fitflop Clearance Fitflop Sale Clearance Discount Fitflop Fitflop Outlet Fitflop Clearance Outlet Clearance Fitflop Yeezy 700 Yeezy 500 Yeezy 350 V2 Yeezy Yellow Yeezy V2 Boost Yeezy V2 Yeezy Uk Yeezy Cream Yeezy Boost V2 Zebra Yeezys Yeezy V2 Boost Yeezy V2 Yeezy 350 V2 Yeezy 2018 Cheap Pandora Charms Pandora Charms Sale Clearance Pandora Charms Wholesale Pandora Jewellery Pandora Wholesale Pandora Jewellery Wholesale Pandora Jewelry Pandora Outlet Pandora Charms Outlet Pandora Rings Pandora Bracelets Canada Goose Canada Goose UK Down Jackets For Women Canada Goose UK Jacket Canada Goose Jacket UK Canada Goose Jacket

June 24, 2018 3:44 PM

dongdong8 said:



June 29, 2018 3:26 AM

dongdong8 said:



July 23, 2018 11:36 PM

shenyuhang said:


July 23, 2018 11:42 PM

Yeezy Supply said: Jordan 11 Win Like 82 Nike Outlet Store Nike Outlet Store Yeezy Yeezy Moncler UK Yeezy Boost 350 Yeezy Boost 350 V2 Birkenstock Oakley Outlet Nike Outlet Online"> nike clearance Off White Jordan 1 Nike Air Max Yeezy Boost 350 Air Max 97 jordan 12 bordeaux Yeezys Nike Shoes Nike Outlet Air Max 2017 Moncler Jackets Yeezy Boost 350 V2 Jordan 12 Win Like 82 Jordan 11 Win Like 82 jordan 4 Nike Clearance Moncler UK Yeezy Nike Outlet Store Online Shoping Birkenstock Shoes jordan 12 ovo Nike Air Max 2017

August 5, 2018 7:34 PM

yaoxuemei said:


August 15, 2018 2:03 AM

qqq said:

August 16, 2018 12:06 AM

Rkman tiwari said:

August 19, 2018 11:56 PM

Rkman tiwari said:

Our pro variety of experts can help take appropriate proper such issues providing feasible solutions within a very brief duration of your time and effort of your as well as, depending on the dimensions of the big mistake.

August 20, 2018 12:03 AM

Rkman tiwari said:

Quicken is a cost-effective store planned by intuit company. It is controlled on ms windows and MAC (Macintosh) os.

August 20, 2018 12:10 AM

Rkman tiwari said:

The same alternatives as well as are available through Sage that was available through Peachtree.

August 20, 2018 12:13 AM

Rkman tiwari said:

Well.. usually that's it! That's what you have to do to be able to analyze your home/office e-mail while on the go, on your mobile mobile phone.

August 20, 2018 12:15 AM

Rkman tiwari said: "There was awesome development globally in the M&A arena last season, with record-setting variety of $474.3 billion money money money from the Asian-Pacific area, up 46% from $324.5 billion money money money

August 20, 2018 12:17 AM

Rkman tiwari said:

launch the app and your AD credentials will be sent to the Return. So, you don't have to kind your credentials again.

August 20, 2018 12:20 AM

Mausam Roy said:

Furniture needs careful packaging to avoid any sort of damage. Exercise types of equipment also need proper wrapping etc. so that it reaches safely. Your precious crockery is another item that can easily break if not properly packed More information:

August 20, 2018 4:35 AM

Mausam Roy said:

The Movers And Packers should be able to provide timely services. They should start the work on time and complete it within the stipulated time. There should be no complaints about delay in work More information:

August 20, 2018 4:35 AM

Mausam Roy said:

The Packers and Movers should be professional and not work in a lazy and inefficient manner. They should be well aware of the way packaging is done and ensure no damage or loss to property. Further, they should also be co-operative and friendly so that the customers have a pleasant experience of taking their services

More information:

August 20, 2018 4:35 AM

Mausam Roy said:

There are many Movers And Packers but you should choose the one that is most reliable. has handpicked the packers and movers who are reliable and efficient More information:

August 20, 2018 4:35 AM

Mausam Roy said:

Packers and movers is an ever-growing industry. More and more people are shifting to new places for better jobs, better lifestyle, better opportunities, etc. is the ‘Industrial capital of India’ and so many people shift to and from this city every day More information:

August 20, 2018 4:36 AM

chenjinyan said:


August 22, 2018 11:04 PM

shenyuhang said:


August 23, 2018 10:16 PM

happy wheels said:

Great article. I would love to read your post. Hope you have more posts.

September 18, 2018 2:02 AM

chenlixiang said:



September 18, 2018 9:53 PM

kakakaoo said:

October 8, 2018 2:29 AM

chenjinyan said:


October 9, 2018 6:41 PM

chenqiuying said:


October 10, 2018 5:57 PM

Kiaan Roy said:

October 22, 2018 5:30 AM

kakakaoo said:

November 8, 2018 2:12 AM

abbas said:

tes saja lah

html code

<a href="">undangan">">undangan pernikahan</a>

<a href="">undangan">">undangan pernikahan unik</a>

<a href="">undangan">">undangan pernikahan unik</a>

ini cuma pake ling

bb code

[url=]undangan pernikahan[/url]

[url=]undangan pernikahan simple[/url]

[url=]undangan pernikahan unik[/url]


November 30, 2018 2:04 AM

faiz said:

a. Tidak dapat mentoleransi ketidakpeduliannya yang ini ke 20"> Supplier plat besi hitam Toko besi wf Toko besi wf Toko stainless steel"> Agen besi cnp undangan pernikahan akrilik Supplier Wiremesh Jual Plat Kapal Besi baja"> Toko plat besi hitam Pabrik besi beton Sni Ulir Polos polos ulir Agen besi wf Agen besi wf Toko atap spandek undangan pernikahan bentuk tas Supplier Besi Pipa Baja Schedule 80 Harga Plat Kapal Besi baja"> Agen plat besi hitam Pabrik besi beton sii Pabrik besi wf Pabrik besi wf Toko baja ringan

http://www./harga-besi-hollow-hitam-baja-toko-distributor-agen-supplier-pabrik-produsen-jual Pabrik besi hollow Toko besi Wf Baja undangan pernikahan online Supplier Besi Pipa Baja Schedule 40 Pabrik Plat Kapal Besi baja"> Pabrik plat besi hitam Pabrik besi beton psi Ulir Polos Distributor besi hollow Distributor besi hollow Toko bondek Toko bondek undangan pernikahan modern Supplier Pipa Besi Hitam Medium Distributor Wiremesh Besi baja Distributor plat kapal besi baja Pabrik besi beton perwira Harga besi hollow Harga besi hollow Toko Plat kapal besi baja bki krakatau steel Toko wiremesh undangan pernikahan unik dan murah Supplier Besi Wf Supplier Wiremesh Besi baja Harga plat kapal besi baja Pabrik besi beton PAS Jual Jaket Parka Jaket Parka undangan pernikahan kalender undangan pernikahan bahasa inggris islam undangan pernikahan islami undangan pernikahan unik dan murah undangan pernikahan modern undangan pernikahan online undangan pernikahan undangan pernikahan amplop surat undangan pernikahan simple undangan pernikahan murah undangan pernikahan unik undangan pernikahan artis undangan pernikahan modern undangan pernikahan artis undangan pernikahan arab undangan pernikahan undangan pernikahan Pabrik Welded Beam Pabrik Welded Beam Jual atap spandek

November 30, 2018 10:29 PM

Rkman said:

and interface. Even the navigational sources are reminiscent of its predecessors and other basic

January 13, 2019 10:58 PM

Rkman said:

whenever you need it. We promise our customers to deliver efficient & savvy support on Quicken program or relevant alternatives, all you need is to link with us at Quicken Support Help Variety 1-

January 13, 2019 10:58 PM

Rkman said:

Batch posting in Sage 50 programs are an efficient genuine there are allows the Sage 50 individuals

January 13, 2019 10:58 PM

Rkman said:

In 2019, Ryan predicts that we'll see maturation of customer accessibility to wellness data—supported by initiatives like the My Health Data initiative, which aims to empower patients by ensuring that they control their proper care information and can decide how their information are going to be used, all while keeping that information safe.

January 13, 2019 10:59 PM

Rkman said:

Oath may process details associated with individuals in the EU/EEA and may transfer that details from the EU/EEA through various compliance mechanisms, including information systems

January 13, 2019 10:59 PM

lana said:

I'm happy about everything you bring it very interesting and helpful, thanks

March 3, 2019 8:06 PM

alice said:

Very good post. I certainly love this website. Keep writing!

March 3, 2019 8:07 PM

qqq said:


March 27, 2019 12:52 AM

Inyang said:

June 4, 2020 5:02 AM

yanmaneee said:">">

June 29, 2020 11:02 PM

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