SQL Performance

JANUARY 22, 2020

Table-valued parameters have been around since SQL Server 2008 and provide a useful mechanism for sending multiple rows of data to SQL Server, brought together as a single parameterized call. } ; We now have correct lengths for the column definitions, and we won't be passing them as LOBs over TDS to SQL Server.

Servers 55

Servers Azure Hardware Network 55

Smashing Magazine

JANUARY 11, 2021

CrUX generates an overview of performance distributions over time, with traffic collected from Google Chrome users. But account for the different types and usage behaviors of your customers (which Tobias Baldauf called cadence and cohorts ), along with bot traffic and seasonality effects. You can create your own on Chrome UX Dashboard.

Performance 145

Performance Cache Media Metrics 145

All Things Distributed

JUNE 28, 2017

This article titled " Wartet nicht auf Perfektion – lernt aus euren Fehlern! The body and hardware still reflect HARTING's standard of perfection. The web servers reported timeouts. Because our web services are overloaded and couldn't cope with the high traffic. Why were the web servers overloaded?

Innovation 113

Innovation Website Servers Technology 113

The Morning Paper

JULY 4, 2019

degraded hardware, transient networking problem) or, more often, because of some change deployed by Netflix engineers that did not have the intended effect. Monocle grabs data from the Atlas telemetry system, the tracing system, and by querying runtime servers for configuration information such as time values.

Latency 77

Latency Engineering Metrics Traffic 77

Percona

JULY 1, 2023

Understanding DBaaS DBaaS cloud services allow users to use databases without configuring physical hardware and infrastructure or installing software. If you need to enable Amazon RDS remote access, this article will help you do so. Considering a Fully Managed DBaaS Offering For Your Business?

AWS 52

AWS Database Serverless Storage 52

Smashing Magazine

JANUARY 6, 2020

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? It used to provide an insight into how quickly the server outputs any data. What does it mean? Large preview ).

Performance 145

Performance Cache Network Metrics 145

Percona

APRIL 17, 2023

It is common to see a value of “ 0″ ( or sometimes “10” ) on database servers, telling the kernel to prefer to swap to memory for better response times. The swap issue is explained in the excellent article by Jeremy Cole at the Swap Insanity and NUMA Architecture.

Best Practices 52

Best Practices Design Tuning Database 52

Dynatrace

NOVEMBER 20, 2019

The IBM Z platform is a range of mainframe hardware solutions that are quite frequently used in large computing shops. Typically, these shops run the z/OS operating system, but more recently, it’s not uncommon to see the Z hardware running special versions of Linux distributions. running on the 64-bit OS/390x platform.

Availability 31

Availability Hardware Java Tuning 31

Smashing Magazine

JANUARY 7, 2019

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? Long FMP usually indicates JavaScript blocking the main thread, but could be related to back-end/server issues as well.

Performance 104

Performance Cache Metrics Network 104

Alex Russell

MARCH 6, 2021

Hardware Past As Performance Prologue. Regardless, the overall story for hardware progress remains grim, particularly when we recall how long device replacement cycles are: Tap for a larger version. But the hardware future is not evenly distributed, and web workloads aren't heavily parallel. Mind The Gap.

Performance 124

Performance Network Cache Metrics 124

Smashing Magazine

MAY 20, 2020

This article will help you with exactly that. The metrics selection is outside of the scope of this article and depends highly on the project context, but I recommend that you start by reading User-centric Performance Metrics by Philip Walton. This metric shows how much time it takes for the server to respond with something.

Performance 99

Performance Metrics Best Practices Code 99

Dynatrace

AUGUST 8, 2019

The IBM Z platform is a range of mainframe hardware solutions that are quite frequently used in large computing shops. Typically, these shops run the z/OS operating system, but more recently, it’s not uncommon to see the Z hardware running special versions of Linux distributions. running on the 64-bit OS/390x platform.

Availability 25

Availability Hardware Java Tuning 25

Brendan Gregg

SEPTEMBER 25, 2021

Since instances of both CentOS and Ubuntu were running in parallel, I could collect flame graphs at the same time (same time-of-day traffic mix) and compare them side by side. This server is spending about a third of its CPU cycles just checking the time! The CentOS flame graph: The Ubuntu flame graph: Darn, they didn't work.

Speed 52

Speed Java AWS Virtualization 52

Brendan Gregg

SEPTEMBER 25, 2021

Since instances of both CentOS and Ubuntu were running in parallel, I could collect flame graphs at the same time (same time-of-day traffic mix) and compare them side by side. This server is spending about a third of its CPU cycles just checking the time! The CentOS flame graph: The Ubuntu flame graph: Darn, they didn't work.

Speed 40

Speed Java AWS Virtualization 40

Brendan Gregg

SEPTEMBER 5, 2017

I wrote an ftrace toolkit, [perf-tools], and the article [Ftrace: the hidden light switch]. - **perf**: since 2009, this started as a PMC profiler but can do tracing now as well, usually in a dump-and-post-process style. Oracle VM Server is based on Xen. It's the official profiler. amazon").

Virtualization 76

Virtualization AWS Engineering Hardware 76

Percona

AUGUST 27, 2018

It is well hidden in the Optimization: Optimizing the MySQL Server chapter. assigning to a specific CPU) is a manageable resource, represented by the concept of “virtual CPU” as a term that includes CPU cores, hyperthreads, hardware threads, and so forth. I am talking about resource groups. Currently, CPU affinity (i.e., Conclusion.

Tuning 44

Tuning Virtualization Testing Servers 44

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. For a timely introduction, I recommended Kevin Schaaf’s recent talk.

Performance 68

Performance Benchmarking Network Mobile 68

Smashing Magazine

AUGUST 22, 2021

HTTP/3 performance features ( current article ). Latency can be roughly defined as the time it takes to send a packet from point A (say, the client) to point B (the server). These handshakes exchange initial parameters that both client and server need to know in order to, for example, encrypt the data. and prior (a)).

Performance 106

Performance Network Latency Servers 106