SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

SQL Performance

JULY 16, 2019

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile.

Servers 46

Servers Hardware Architecture Retail 46

SQL Performance

JUNE 21, 2019

I wrote a blog about it years ago too, however as time has marched on, guidance has changed a bit. Jonathan Kehayias has written an blog post How much memory does my SQL Server actually need , with a formula that helps establish the baseline for the maximum memory value. SQL Server 2016 introduced soft-NUMA nodes.

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

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

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