SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. Implementing the current requirement using that technique is quite straightforward, though the code is necessarily longer than anything we have seen up to this point: WITH R AS. ( The code may be easier to read and understand than the recursive CTE.

Servers 86

Servers Tuning Database Efficiency 86

Adrian Cockcroft

JUNE 2, 2023

FSD has a sense of purpose, a planning capability, has real time agency and responds to its environment via an ego model, predicting the behavior of pedestrians and other road users, and is being tuned to drive in a very human way, so that other road users interact with it as a predicable normal driver.

Social Media 98

Social Media Innovation Open Source Entertainment 98

Dotcom-Montior

NOVEMBER 11, 2020

Serverless computing can be a huge benefit to organizations that don’t have the necessary resources or teams to manage physical resources, like servers/hardware, and all the maintenance and licensing that goes along with that, allowing them to focus on developing their code and applications. Benefits of a Serverless Model. Scalability.

Serverless 57

Serverless Monitoring Lambda Latency 57

The Agile Manager

JUNE 30, 2015

Operations and execution matter to the bottom line, but ultimately dance to the tune called by finance. Virtual data centers, real-time algorithmic pricing, and new media are simply larger versions of that same phenomenon. Production isn't what it used to be.

Software 40

Software Software Innovation Hardware 40

KeyCDN

SEPTEMBER 20, 2018

Not all back-end errors affect the user experience, but keeping track of them can prove helpful when tuning your app. Source: Google Keep in mind that not all code errors are noticeable to users. Back-end error tracking is relatively straightforward since all server-side code runs in the same place.

Strategy 67

Strategy Monitoring Website Google 67

Dynatrace

OCTOBER 2, 2023

Limits of a lift-and-shift approach A traditional lift-and-shift approach, where teams migrate a monolithic application directly onto hardware hosted in the cloud, may seem like the logical first step toward application transformation. Likewise, refactoring and rewriting code takes a lot of time and effort.

Architecture 225

Architecture Artificial Intelligence Cloud Open Source 225

Sutter's Mill

MAY 28, 2012

Mainstream hardware – many kinds of parallelism: What’s the relationship among multi-core CPUs, hardware threads , SIMD vector units (Intel SSE and AVX , ARM Neon ), and GPGPU (general-purpose computation on GPUs, which I covered at C++ and Beyond 2011 )? This isn’t just cool stuff – it’s important and useful in production code today.

C++ 40

C++ Hardware Best Practices Tuning 40

Percona

AUGUST 29, 2018

In this post, we will discuss some important kernel parameters that can affect database server performance and how these should be tuned. child process exited with exit code 1 Similarly, you can get an error when starting the PostgreSQL server using the pg_ctl command. SHMMAX / SHMALL. Until version 9.2, vm.dirty_ratio / dirty_bytes.

Tuning 54

Tuning Database Servers Processing 54

Percona

OCTOBER 18, 2023

You can tailor the database to meet your precise requirements by modifying the source code, adding extensions, or customizing configurations. Resource allocation: Personnel, hardware, time, and money The migration to open source requires careful allocation (and knowledge) of the resources available to you. And finally… budgets.

Open Source 90

Open Source Database Hardware Strategy 90

Abhishek Tiwari

JULY 12, 2018

A data pipeline is a software which runs on hardware. The software is error-prone and hardware failures are inevitable. If tuned for performance, there is a good change reliability is compromised - and vice versa. A data pipeline can process data in a different order than they were received.

Latency 63

Latency Analytics Scalability Engineering 63

Dynatrace

JANUARY 26, 2021

This allows teams to sidestep much of the cost and time associated with managing hardware, platforms, and operating systems on-premises, while also gaining the flexibility to scale rapidly and efficiently. Performing updates, installing software, and resolving hardware issues requires up to 17 hours of developer time every week.

Serverless 241

Serverless Efficiency Lambda Azure 241

Dynatrace

APRIL 21, 2023

The agencies resisted adopting the tool because it required significant time to configure and tune collected metrics into valuable information. The obvious costs of tool sprawl can quickly add up, including licensing, support, maintenance, training, hardware, and often additional headcount. Ultimately, Zbojniewicz has saved $1.4M

Government 157

Government Infrastructure Innovation Monitoring 157

Dynatrace

MAY 1, 2020

This is especially the case with microservices and applications created around multiple tiers, where cheaper hardware alternatives play a significant role in the infrastructure footprint. Here are details of the capabilities included in this release of OneAgent for Linux on the ARM platform: Deep-code monitoring.

Java 132

Java Hardware Tuning Metrics 132

Dynatrace

SEPTEMBER 29, 2021

Container technology is very powerful as small teams can develop and package their application on laptops and then deploy it anywhere into staging or production environments without having to worry about dependencies, configurations, OS, hardware, and so on. The time and effort saved with testing and deployment are a game-changer for DevOps.

Open Source 295

Open Source Traffic DevOps Cloud 295

O'Reilly

NOVEMBER 28, 2023

Even with cloud-based foundation models like GPT-4, which eliminate the need to develop your own model or provide your own infrastructure, fine-tuning a model for any particular use case is still a major undertaking. That pricing won’t be sustainable, particularly as hardware shortages drive up the cost of building infrastructure.

Open Source 111

Open Source Artificial Intelligence Google Infrastructure 111

Dynatrace

AUGUST 12, 2020

This gives you deep visibility into your code running in Azure Functions, and, as a result, an understanding of its impact on overall application performance and user experience. Code-level visibility continues to be supported for.NET-based functions running in an App Service plan. Optimize your code with code-level visibility.

Serverless 232

Serverless Azure Monitoring Lambda 232

Percona

AUGUST 27, 2018

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. Then we need to see IF implementing the tuning will work or not. It is possible to do more tuning in the case that ETL is too compromised.

Tuning 44

Tuning Virtualization Testing Servers 44

The Netflix TechBlog

APRIL 29, 2019

Such applications track the inventory of our network gear: what devices, of which models, with which hardware components, located in which sites. One example is the Spectator Python client library, a library for instrumenting code to record dimensional time series metrics. We use Python to help generate TLS certificates using Lemur.

Open Source 279

Open Source Network Infrastructure Big Data 279

O'Reilly

SEPTEMBER 19, 2023

” Each step has been a twist on “what if we could write code to interact with a tamper-resistant ledger in real-time?” Doubly so as hardware improved, eating away at the lower end of Hadoop-worthy work. Mental contortions led to code contortions led to frustration. And, often, to giving up.

Hardware 101

Hardware Storage Big Data Blockchain 101

Dynatrace

NOVEMBER 15, 2021

Logs can include data about user inputs, system processes, and hardware states. Log analysis can reveal potential bottlenecks and inefficient configurations so teams can fine-tune system performance. “Logging” is the practice of generating and storing logs for later analysis. Optimized system performance.

Analytics 202

Analytics Monitoring Artificial Intelligence DevOps 202

Dynatrace

AUGUST 12, 2020

This gives you deep visibility into your code running in Azure Functions, and, as a result, an understanding of its impact on overall application performance and user experience. Code-level visibility continues to be supported for.NET-based functions running in an App Service plan. Optimize your code with code-level visibility.

Serverless 140

Serverless Azure Monitoring Lambda 140

The Morning Paper

JUNE 27, 2019

The thrust of the argument is that there’s a chain of inter-linked assumptions / dependencies from the hardware all the way to the programming model, and any time you step outside of the mainstream it’s sufficiently hard to get acceptable performance that researchers are discouraged from doing so. a research paper.

Systems 87

Systems Tuning Programming Innovation 87

All Things Distributed

MARCH 19, 2018

Amazon SageMaker training supports powerful container management mechanisms that include spinning up large numbers of containers on different hardware with fast networking and access to the underlying hardware, such as GPUs. This can all be done without touching a single line of code. Post-training model tuning and rich states.

Scalability 159

Scalability Hardware AWS Tuning 159

Brendan Gregg

SEPTEMBER 25, 2021

The broken Java stacks turned out to be beneficial: They helped group together the os::javaTimeMillis() calls which otherwise might have have been scattered on top of different Java code paths, appearing as thin stacks everywhere. Without NMI, some kernel code paths (interrupts disabled) can't be profiled. But I'm not completely sure.

Speed 126

Speed Java AWS Virtualization 126

Dynatrace

OCTOBER 22, 2019

Thread dumps allow Java developers to understand which threads execute which code and whether or not certain threads are waiting or locked. Ideally, all CPUs would execute code all the time and never be idle. More work means more coordination and more locks, which in turn means less code executed at any given time.

Java 102

Java Scalability Hardware Architecture 102

The Morning Paper

NOVEMBER 10, 2019

Once the whole fleet has turned over, the code for the now unused version(s) can be removed. The ability to rapidly deploy new versions of Pony Express significantly aided development and tuning of congestion control. The little engine that could.

Network 92

Network Transportation Latency Entertainment 92

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. Stay tuned for more announcements on this topic.

Availability 30

Availability Hardware Java Tuning 30

Adrian Cockcroft

NOVEMBER 13, 2023

In the simplest case, you have a growing workload, and you optimize it to run more efficiently so that you don’t need to buy or rent additional hardware, so your carbon footprint stays the same, but the carbon per transaction or operation is going down. I’ve written before about how to tune out retry storms.

Energy 52

Energy Cloud Traffic Transportation 52

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. Stay tuned for more announcements on this topic.

Availability 25

Availability Hardware Java Tuning 25

Brendan Gregg

SEPTEMBER 5, 2017

It uses a Solaris Porting Layer (SPL) to provide a Solaris-kernel interface on Linux, so that unmodified ZFS code can execute. There's also a ZFS send/recv code path that should try to use the TASK_INTERRUPTIBLE flag (as suggested by a coworker), to avoid a kernel hang (can't kill -9 the process). LTS (April 2016).

Virtualization 76

Virtualization AWS Engineering Hardware 76

Brendan Gregg

SEPTEMBER 25, 2021

The broken Java stacks turned out to be beneficial: They helped group together the os::javaTimeMillis() calls which otherwise might have have been scattered on top of different Java code paths, appearing as thin stacks everywhere. Without NMI, some kernel code paths (interrupts disabled) can't be profiled. But I'm not completely sure.

Speed 40

Speed Java AWS Virtualization 40

Dotcom-Montior

OCTOBER 12, 2017

Edit the load testing script and add the following code section after tab0 variable initialized: Tab.SetRequestHeader(“loadtest”,”x-dynatrace”); Execute the EveryStep Script load test script several times (single user). Verify hardware sizing. Make application tuning much easier. Replay the Browser based script.

AWS 40

AWS Tuning Monitoring Servers 40

SQL Server According to Bob

JANUARY 11, 2020

Example 1: ​​ Hardware failure (CPU board) Battery backup on the caching controller maintained the data. Important Always consult with your hardware manufacturer for proper stable media strategies. For specific information on I/O tuning and balancing, you will find more details in the following document.

Servers 40

Servers Cache Media Hardware 40

HammerDB

FEBRUARY 25, 2021

This is possible because the Tcl interpreter is exceptionally compact and lightweight (Also for this reason Tcl is often used as an embedded language in hardware such as Cisco Routers). Running a performance profiling tool such as perf in Linux we can see that the top event is TEBCresume standing for Tcl Execute Byte Code.

Programming 67

Programming Benchmarking Virtualization C++ 67

John McCalpin

JANUARY 22, 2018

Introduction: In December 2017, my colleague Damon McDougall (now at AMD) asked for help in porting the fused multiply-add example code from a Colfax report ( [link] ) to the Xeon Phi x200 (Knights Landing) processors here at TACC. of the “adjusted peak performance”, there is no longer a significant upside to performance tuning.

Latency 40

Latency Hardware Code Testing 40

All Things Distributed

OCTOBER 8, 2014

We built DynamoDB as a fully-managed service because we wanted to enable our customers, both internal and external, to focus on their application rather than being distracted by undifferentiated heavy lifting like dealing with hardware and software maintenance. Expanding the freedom to invent.

Availability 145

Availability Performance Scalability AWS 145

HammerDB

OCTOBER 12, 2018

As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. driver: intel_pstate CPUs which run at the same hardware frequency: 0 . hardware limits: 1000 MHz - 3.80 hardware limits: 1000 MHz - 3.80 current CPU frequency: Unable to call hardware .

Best Practices 40

Best Practices Scalability Performance C++ 40