SQL Performance

JUNE 21, 2019

What I find is very similar to backups: No DBCC CHECKDBs performed at all DBCC CHECKDBs being performed only on select databases DBCC CHECKDBs last performed months or years ago. Performing index maintenance by removing fragmentation from your indexes is still important. 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. In this article, we will look at how this can improve the reporting/analytical query performance in MySQL. The second and third run used the cached data. With faster disks (i.e. MySQL on ec2.

Cache 48

Cache C++ AWS Airlines 48

Smashing Magazine

JANUARY 15, 2019

How Improving Website Performance Can Help Save The Planet. How Improving Website Performance Can Help Save The Planet. Perhaps the biggest win when it comes to making websites more sustainable is that performance, user experience and sustainability are all neatly intertwined. Jack Lenox. 2019-01-15T13:30:32+01:00.

Website Performance 73

Website Performance Website Energy Performance 73

Alex Russell

OCTOBER 22, 2017

TL;DR: performance budgets are an essential but under-appreciated part of product success and team health. Nobody is trying to do a poor job, and yet the results of a “completed” PWA project often require weeks or months of painstaking rework to deliver minimally acceptable performance. Partner meetings are illuminating.

Performance 68

Performance Benchmarking Network Mobile 68

Alex Russell

APRIL 29, 2021

Classics of the genre include: Apple's just focused on performance! The Performance Argument. As an engineer on a browser team, I'm privy to the blow-by-blow of various performance projects, benchmark fire drills, and the ways performance marketing (deeply) impacts engineering priorities. Steve & Tim's Close-up Magic.

Media 145

Media Games Education Engineering 145

SQL Server According to Bob

DECEMBER 18, 2018

Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. Device level flushing may have an impact on your I/O caching, read ahead or other behaviors of the storage system. Performance points of reference: The following charts highlight the increase in performance. The Back Story.

Servers 90

Servers Media Cache Storage 90

John McCalpin

NOVEMBER 5, 2016

In recent years the trend has been to increase core-level performance by the use of SIMD vector instructions, and to increase package-level performance by the addition of more and more cores. The core does not have enough load bandwidth to perform all of these extra load operations at full speed.

Cache 40

Cache C++ Latency Hardware 40

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. Or did we just get lucky or oblivious?

Programming 79

Programming Hardware Cache Code 79