SQL Performance

JUNE 21, 2019

While hardware such as intelligent SANs, Solid State Disk, and other advancements have helped speed things up, wasted space in index can translate to wasted space in the buffer pool as well as wasting more I/O. SQL Server Database Maintenance plans prior to SQL Server 2016 only allowed to rebuild or reorganize all indexes.

Servers 49

Servers Azure Hardware Database 49

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. Aurora Parallel Query response time (for queries which can not use indexes) can be 5x-10x better compared to the non-parallel fully cached operations. The second and third run used the cached data.

Cache 46

Cache C++ AWS Airlines 46

SQL Server According to Bob

DECEMBER 18, 2018

Device level flushing may have an impact on your I/O caching, read ahead or other behaviors of the storage system. FILE_FLAG_NO_BUFFERING is the Win32, CreateFile API flags and attributes setting to bypass file system cache. FILE_FLAG_NO_BUFFERING is the Win32, CreateFile API flags and attributes setting to bypass file system cache.

Servers 90

Servers Media Cache Storage 90

John McCalpin

NOVEMBER 5, 2016

In the latest (October 2016) revision of Intel’s Instruction Extensions Programming Reference , Intel has disclosed a fairly dramatic departure from these “traditional” approaches. E.g., on Haswell you can execute two loads per cycle of any size or alignment as long as neither crosses a cache-line boundary.

Cache 40

Cache C++ Latency Hardware 40

Alex Russell

APRIL 29, 2021

At the time of the last Confluence run, the gap had stretched to nearly 1000 APIs, doubling since 2016. An extension to Service Workers that enables browsers to present users with cached content when offline. is access to hardware devices. Some commenters appear to confuse unlike hardware for differences in software.

Media 145

Media Games Education Engineering 145

Randon ASCII

FEBRUARY 25, 2018

In this particular investigation, which spanned twenty months, we suspected hardware failure, compiler bugs, linker bugs, and other possibilities. Jumping too quickly to blaming hardware or build tools is a classic mistake, but in this case the mistake was that we weren’t thinking big enough.

Programming 79

Programming Hardware Cache Code 79

Alex Russell

OCTOBER 22, 2017

Add onto that the yawning chasm between low-end and high-end device performance thanks to chip design factors like cache sizes, and it can be difficult to know where to set a device baseline. The true median device from 2016 sold at about ~$200 unlocked. — Monica Dinculescu (@notwaldorf) September 20, 2016.

Performance 68

Performance Benchmarking Network Mobile 68

Smashing Magazine

JANUARY 15, 2019

how much data does the browser have to download to display your website) and resource usage of the hardware serving and receiving the website. In 2016, O’Reilly published “ Designing For Sustainability ” by Tim Frick. A particular favorite in the WordPress space is WP Super Cache. These include data transfer (i.e.

Website Performance 73

Website Performance Website Energy Performance 73