SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS. Statistics.

Servers 49

Servers Azure Hardware Database 49

Alex Russell

MARCH 6, 2021

Back in 2016, I gave a talk outlining the causes and effects of the terrible performance of web apps built using popular tools on the fastest-growing device segment: low-end to mid-range Android phones. In 2016, Jio swept over the subcontinent like a monsoon dropping a torrent of 4G infrastructure and free data rather than rain.

Performance 127

Performance Network Mobile Metrics 127

Percona

JANUARY 24, 2023

Some of the built-in features ( wal_compression ) have been there since 2016, and almost all backup tools do the WAL compression before taking it to the backup repository. Zstd can be chosen if the server load is not CPU bound because it can give us better compression at the expense of more CPU utilization.

Database 142

Database Benchmarking Open Source Latency 142

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. Despite all of this, Intel is not going to lose their entire server processor business any time soon. So, what has changed my mind?

Servers 46

Servers Hardware Architecture Retail 46

SQL Server According to Bob

JULY 13, 2016

20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here is SQL Server. So I proceeded to install SQL Server 4.20 There was a GUI as part of setup but within just a few clicks, SQL Server was installed and ready for use. So now there are more choices to make when installing SQL Server.

Servers 40

Servers Media Engineering Virtualization 40

MachMetrics

JUNE 30, 2021

Website performance & speed plays a major role in the success of an online business. Many people often confuse site speed with page speed grades of performance testing tools, which are actually calculated based on multiple factors of a page including its loading speed. How to get these matrics right and not mess up?

Cache 78

Cache Speed Google Website 78

Scalegrid

JANUARY 19, 2024

Recovering from a MongoDB rollback involves locating rollback files, using mongorestore to load data into a separate server, cleansing unneeded data, and importing the data back into the primary cluster, coupled with ongoing monitoring and maintenance of replica sets to maintain system health.

Database 130

Database Network Servers Monitoring 130

SQL Server According to Bob

NOVEMBER 8, 2016

SQL Server 2016 Service Pack 1 (all SKUs) , in combination with Windows Server 2016 (All SKUs) or Windows 10 Client introduces non-volatile memory support for the tail of the log file (LDF) which can significantly increase transaction throughput. As the following diagram shows the SQL Server Log Cache is in memory.

Cache 40

Cache Servers Media Storage 40

Rigor

JANUARY 13, 2020

Yet, we wanted to put together our list of the top web performance books for anyone who cares about speed of the web and would like to explore the timeline of web performance engineering milestones over nearly two decades through the lens of published books. Site speed & SEO go hand in hand. Speed Up Your Site. Still good.

Performance 75

Performance Social Media Website Website Performance 75

KeyCDN

JANUARY 31, 2019

Today we’re excited to announce that we’ve launched yet another POP location to help further supercharge our network’s content delivery speeds. With Bucharest being the capital and largest city of Romania, it makes for a great edge server location. As of 2016, Bucharest alone had a population of over 1.83

Internet 48

Internet Internet Ecommerce Speed 48

CSS - Tricks

APRIL 1, 2021

Speed is also something Google considers when ranking your website placement on mobile. With all of this in mind, I thought improving the speed of my own version of a slow site would be a fun exercise. It begins with retrieving the HTML from the server and converting this into the Document Object Model (DOM).

Cache 94

Cache Social Media Media Website 94

KeyCDN

OCTOBER 24, 2018

Today we’re excited to announce that we’ve launched yet another POP location to help further supercharge our network’s content delivery speeds. With Helsinki being the capital and most populous municipality of Finland, it makes for a great edge server location. As of 2016, there were just over 5.1

Internet 48

Internet Internet Speed Network 48

Brendan Gregg

JULY 4, 2021

I summarized these topics and more as a plenary conference talk, including my own predictions (as a senior performance engineer) for the future of computing performance, with a focus on back-end servers. Ford, et al., “TCP

Performance 52

Performance Latency Hardware Storage 52

Alex Russell

FEBRUARY 3, 2023

In time, these misapprehensions would become cursed articles of faith: CPUs get faster every year [ narrator: they do not ] Organisations can manage these complex stacks [ narrator: they cannot ] All of this was falsified by 2016 , but nobody wanted to turn on the house lights while the JS party was in full swing.

Social Media 130

Social Media Website Technology Technology 130

SQL Performance

SEPTEMBER 5, 2019

I briefly mentioned that batch mode data is normalized in my last article Batch Mode Bitmaps in SQL Server. You will need SQL Server 2016 (or later) and Developer Edition (or equivalent) to reproduce the results shown here. You can skip the WHERE clauses if you are running SQL Server 2017. s = SUM ( T.

Performance 81

Performance C++ Storage Servers 81

Brendan Gregg

SEPTEMBER 5, 2017

LTS (April 2016). I wrote about it in a previous post, [DTrace for Linux 2016]. I wrote a page on it: [perf]. - **eBPF**: tracing features completed in 2016, this provides efficient programmatic tracing to existing kernel frameworks. Oracle VM Server is based on Xen. The hardest part on Linux is now done: kernel support.

Virtualization 75

Virtualization AWS Engineering Hardware 75

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory. Ford, et al., “TCP

Performance 52

Performance Latency Cache Virtualization 52

SQL Performance

APRIL 8, 2019

These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. This 14nm first-generation AMD EPYC 7551 processor has 32 cores and 64 threads, and it works in one or two-socket servers. This makes it a good choice for many SQL Server workloads, especially DW workloads.

Azure 42

Azure Virtualization Storage Benchmarking 42

Smashing Magazine

JULY 6, 2021

With Luminary’s 21 years of experience in the digital space, my experience of 17 years in the CMS space as well as our focus on Headless since 2016, here are my two cents on what you should look out for. This speeds up the retrieval process and brings in performance improvements to your application. Microservices architecture.

Cache 145

Cache Website Mobile Google 145

Alex Russell

MARCH 31, 2022

Late in the drafting of this post, it was pointed out to me by Frederik Braun that Brad Hill had considered the downsides of a site-populated SRI addressable cache back in 2016. That is unlikely given the need for SRI annotations or the unbecoming practice of speeding up high-traffic sites, but not others.

Cache 89

Cache Government Traffic Network 89

Alex Russell

OCTOBER 22, 2017

Late-loading JavaScript can cause “server-side rendered” pages to fail in infuriating ways. The server sends it as a stream of bytes and when the browser encounters each of the sub-resources referenced in the document, it requests them. The true median device from 2016 sold at about ~$200 unlocked.

Performance 74

Performance Network Benchmarking Mobile 74

Alex Russell

MAY 9, 2022

Teams achieving this level of discipline about performance begin to eliminate variance from their lab data by running tests in "less noisy" environments than somewhere like a developer's laptop, a shared server, or a VM with underlying system variance. miAi3020A9G #perfmatters 1 10:04 AM · Jul 7, 2016.

Performance 99

Performance Latency Metrics Engineering 99

Rigor

JULY 17, 2019

By reducing the size of the HTML files used to build your webpage, you can speed up your site’s page load times and make the download less expensive (in terms of data usage and browser work) for your user. Developers can work with the larger, more human-readable form of the file, while the minified version is the one deployed to the server.

Speed 40

Speed Internet Internet Processing 40

Randon ASCII

FEBRUARY 25, 2018

In September of 2016 we started noticing random failures when building Chrome – 3 out of 200 builds of Chrome failed when protoc.exe, one of the executables that is part of the build, crashed with an access violation. Yes, there was a linker bug, but we were also lucky enough to have hit a Windows kernel bug which is triggered by linkers!

Programming 79

Programming Hardware Cache Code 79

Rigor

JULY 2, 2019

You can find more information about modifying this file within your server’s documentation. When setting up server-side redirection, be sure to keep the redirect URL consistent with the alternate URL specified in the page’s link rel=”alternate” tag or in the sitemap. Originally published September 2016, updated July 2019.

Mobile 60

Mobile Traffic Google Latency 60

Rigor

MARCH 20, 2018

I recently was asked the following question by an online retailer: “Why should I invest in monitoring the user experience when I already have monitoring for our database, infrastructure, app server, and network?”. I wrote a blog in 2016 that discussed the need for businesses to flip the traditional monitoring investment pyramid on its head.

Monitoring 40

Monitoring Retail Ecommerce Infrastructure 40

Enprowess

SEPTEMBER 28, 2021

React developers introduced Inferno in 2016 as an experiment to examine whether or not a library can improve the battery, performance, and UX of mobile apps. Inferno JS would be your best option, if you would like to build client and server-side interfaces with faster speeds, better performance, and isomorphic rendering. .

Open Source 52

Open Source Mobile Development Entertainment 52

Smashing Magazine

JANUARY 21, 2019

An API is the communication channel for an application to load data from the server. This relationship can be expressed through an associative array (an array of key => property) on the server-side, in which each module states its name as the key attribute and its inner modules under the property modules. Large preview ).

Social Media 73

Social Media Database Media Website 73

The Symphonia

DECEMBER 6, 2017

That means that 3GB functions might not see a linear speed bump for primarily single threaded functions. without web app servers?—?to There have been some improvements since re:Invent 2016 but to see nothing announced at this re:Invent was very disappointing. We plan to test this out when we get the chance. But this year?

Serverless 40

Serverless Lambda AWS Traffic 40

CSS Wizardry

MARCH 3, 2019

This includes CDNs, proxy servers, and the like. Once the 60 seconds is up, the browser will head back to the server to revalidate the file. It means ‘do no t serve a copy from cache until you’ve revalidated it with the server and the server said you can use the cached copy’. public and private. Cache-Control: no-cache.

Cache 270

Cache Latency Strategy Servers 270

Dynatrace

OCTOBER 28, 2021

In 2010, Netflix introduced a technology to switch production software instances off at random — like setting a monkey loose in a server room — to test how the cloud handled its services. Speeds incident response. By learning what failure scenarios are possible, these teams can speed troubleshooting, repairs, and incident response.

Engineering 264

Engineering Entertainment Cloud Infrastructure 264

Brendan Gregg

NOVEMBER 29, 2017

Virtualized in Hardware**: Hardware support for virtualization, and near bare-metal speeds. This was initially used via the ixgbe driver for speeds up to 10 Gbps, then the ena driver for speeds up to 25 Gbps. This was extended to instance storage devices for the x1.32xlarge in 2016. I'd expect between 0.1%

Virtualization 110

Virtualization AWS Hardware Storage 110

Smashing Magazine

OCTOBER 26, 2018

In addition to MVC separation, we can (for security reasons or speed improvements) place the JS App on a separate server like in the schema below: Decoupled WordPress diagram. on December 6th, 2016. If you decide to use the method described in this article, be sure you know how to fortify your server security.

Cache 88

Cache Website Speed Testing 88

Brendan Gregg

NOVEMBER 28, 2017

Virtualized in Hardware**: Hardware support for virtualization, and near bare-metal speeds. This was initially used via the ixgbe driver for speeds up to 10 Gbps, then the ena driver for speeds up to 25 Gbps. This was extended to instance storage devices for the x1.32xlarge in 2016. I'd expect between 0.1%

Virtualization 40

Virtualization AWS Hardware Storage 40

Rigor

SEPTEMBER 11, 2019

list of those who are making a significant impact on speeding up the web today. Follow him on Twitter @ RickByers and be sure to watch the video of his conversation at Chrome Dev Summit 2016 , where he discussed the ways Chrome is “improving predictability for developers.” Here is our (ever-growing!) Rachel Andrew.

Performance 89

Performance Education Google Website 89