SQL Performance

APRIL 27, 2020

Gen 5 is the primary hardware option now for most regions since Gen 4 is aging out. I highly recommend that you take a look at the diagram that breaks down the architecture and how it all works in this article. New Hardware Configuration for Provisioned Compute Tier. GB per vCore. Serverless Database. Conclusion.

Azure 55

Azure Database Serverless Hardware 55

Dynatrace

AUGUST 8, 2019

We’re happy to announce the Early Adopter Release of OneAgent full-stack monitoring for Linux on the IBM Z platform, sometimes informally referred to as Z/Linux (available with OneAgent version 1.173 and Dynatrace version 1.174). For details on available metrics, see our help page on host performance monitoring.

Availability 25

Availability Hardware Java Tuning 25

Percona

APRIL 17, 2023

The main objective of this post is to share my experience over the past years tuning MongoDB and centralize the diverse sources that I crossed in this journey in a unique place. There is an issue with this, which causes the OS to swap even with memory available. Spoiler alert: This post focuses on MongoDB 3.6.X 25.84 - Total 21.04

Best Practices 52

Best Practices Design Tuning Database 52

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. For deep technical details and undocumented options, see Dmitry Pilugin's excellent article on the subject. Test Environment. Final Thoughts.

Servers 86

Servers Tuning Database Efficiency 86

Brendan Gregg

SEPTEMBER 25, 2021

As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. Checking those available: $ cat /sys/devices/system/clocksource/clocksource0/available_clocksource. Theory (A) is most likely based on the frame widths in the flame graph. But I'm not completely sure.

Speed 126

Speed Java AWS Virtualization 126

HammerDB

JANUARY 5, 2019

As the chart shows because we know that both HammerDB and the implementation of the TPC-C workload scales then we can determine that with this particular database engine both the software and hardware scales as well. If you only test your own application (and if you have more than one application which one will you use for benchmarking?)

Benchmarking 40

Benchmarking Database Social Media Scalability 40

SQL Server According to Bob

JANUARY 11, 2020

Important When planning, deploying, and maintaining a Microsoft SQL Server installation, ensure that the I/O system supports all the factors outlined in this article. Example 1: ​​ Hardware failure (CPU board) Battery backup on the caching controller maintained the data.

Servers 40

Servers Cache Media Hardware 40

Sutter's Mill

MAY 28, 2012

Here’s what’s different about these talks: Brand new: This material goes beyond what I’ve written and taught about before in my Effective Concurrency articles and courses. Which are most interesting, what technologies are available now, and what’s being considered for near-term standardization? Stay tuned, and fasten your seat belts.

C++ 40

C++ Hardware Best Practices Tuning 40

SQL Performance

MARCH 8, 2021

This can make it difficult to draw sound performance-tuning conclusions. This article aims to help you understand where the timings come from in each case, and how they can be best interpreted in context. See the linked very detailed article if you are interested in all of the finer detail. The scope of cumulative times.

Servers 95

Servers Tuning Architecture Performance 95

Brendan Gregg

SEPTEMBER 25, 2021

As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. Over the years, more and more articles have been published about clocksource in virtual machines, and it's now a well-known issue. Theory (A) is most likely based on the frame widths in the flame graph.

Speed 40

Speed Java AWS Virtualization 40

Brendan Gregg

SEPTEMBER 5, 2017

What follows are topics that may be of interest to anyone looking to migrate their systems and skillset: scan these to find topics that interest you. ## ZFS ZFS is available for Linux via the [zfsonlinux] and [OpenZFS] projects, and more recently was included in Canonical's Ubuntu Linux distribution: Ubuntu Xenial 16.04 LTS (April 2016).

Virtualization 76

Virtualization AWS Engineering Hardware 76

O'Reilly

NOVEMBER 28, 2023

A year after the first web servers became available, how many companies had websites or were experimenting with building them? That pricing won’t be sustainable, particularly as hardware shortages drive up the cost of building infrastructure. Certainly not two-thirds of them. We’ll say more about this later.) AI will be the same.

Open Source 112

Open Source Artificial Intelligence Google Infrastructure 112

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. With faster disks (i.e. AWS Aurora (based on MySQL 5.6) AWS Aurora (based on MySQL 5.6)

Cache 46

Cache C++ AWS Airlines 46

SQL Server According to Bob

JANUARY 11, 2020

​​ Various defragmentation ​​ utilities ​​ are ​​ available ​​ on the market today. ​​ Remote mirroring captures writes and duplicates them ​​ remotely. scid=kb ; en-us;828339 ) on the Microsoft Web site.

Servers 40

Servers Cache Database Media 40

High Scalability

NOVEMBER 25, 2019

In this article, I will share the current architecture and some of the lessons we learned scaling it along with some of the things we are looking to improve upon in the near future. Always be available: Have a service level circuit breaker and a circuit breaker by customer. Egnyte Connect Platform. How Do You Manage Your System?

Architecture 52

Architecture Cache Azure Storage 52

Smashing Magazine

AUGUST 22, 2021

HTTP/3 performance features ( current article ). Additionally, even if we knew the available physical bandwidth, that wouldn’t mean we could use all of it ourselves. Several users are typically active on a network concurrently, each of whom need a fair share of the available bandwidth. This is more in depth and technical.

Performance 107

Performance Network Latency Servers 107

O'Reilly

OCTOBER 11, 2022

Andrew Ng , Christopher Ré , and others have pointed out that in the past decade, we’ve made a lot of progress with algorithms and hardware for running AI. Our current set of AI algorithms are good enough, as is our hardware; the hard problems are all about data. The data available to our retail business is much more limited.

Games 120

Games Healthcare Processing Retail 120