SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. The Back Story.

Servers 90

Servers Media Cache Storage 90

Percona

JULY 7, 2023

HA in PostgreSQL databases delivers virtually continuous availability, fault tolerance, and disaster recovery. In general terms, to achieve HA in PostgreSQL, there must be: Redundancy: To ensure data redundancy and provide continuous performance when a primary server fails, multiple copies of the database reside in replica servers.

Availability 85

Availability Open Source Architecture Database 85

Percona

AUGUST 15, 2023

In this blog post, I provide an in-depth introduction to MySQL Replication, answering what it is, how it works , its benefits and challenges, as well as reviewing some of the MySQL replication concepts that are part of the MySQL environment (and Percona Server for MySQL specifically). Set the server-id to a unique value.

Servers 52

Servers Database Availability Traffic 52

HammerDB

OCTOBER 23, 2023

With a simple example such as this, it would not necessarily be expected for the additional network traffic to be significant between the 2 approaches. The data shows a scripted automated workload running a number of back to back tests each time with an increasing number of virtual users. On MySQL, we saw a 1.5X performance advantage.

Benchmarking 62

Benchmarking Database Network C++ 62

Dotcom-Montior

NOVEMBER 24, 2021

Do you have a web server? Is the web server running? The last item to check was if the web server was able to talk to the database? These systems can include physical servers, containers, virtual machines, or even a device, or node, that connects and communicates with the network. Do you have a database?

Systems 74

Systems Monitoring Hardware Network 74

All Things Distributed

MARCH 11, 2016

This is a given, whether you are using the highest quality hardware or lowest cost components. When customers left the constraining, old world of IT hardware and datacenters behind, they started to develop systems with new and interesting usage patterns that no one had ever seen before. Primitives not frameworks. APIs are forever.

AWS 144

AWS Hardware Retail Virtualization 144

Brendan Gregg

SEPTEMBER 25, 2021

CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. 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!

Speed 126

Speed Java AWS Virtualization 126

Dotcom-Montior

NOVEMBER 11, 2020

Well, to start, serverless, or serverless computing , doesn’t really mean there aren’t servers involved, because there are, rather it refers to the fact that the responsibility of having to manage, scale, provision, maintain, etc., Applications that are running continuously on a dedicated server aren’t as impacted by latency issues.

Serverless 57

Serverless Monitoring Lambda Latency 57

Dotcom-Montior

NOVEMBER 27, 2018

It helps assess how a site, web application, or API will respond to various traffic, without adding any additional infrastructure. Executing an internal test can tell you how well your application or site handles an increase in traffic, but it will never reflect real-world conditions. Identifying performance bottlenecks.

Performance Testing 40

Performance Testing Strategy Testing Performance 40

Dotcom-Montior

JUNE 19, 2017

Let’s face it – the ideal load test emulates real world traffic, yet most load testing software doesn’t come close. A series of GET requests from an in-house server can’t possibly replicate what actually happens when a website sees a sudden increase in users from all over the world. First up is a summary. Conclusion.

Performance Testing 40

Performance Testing Testing Performance Virtualization 40

Adrian Cockcroft

NOVEMBER 13, 2023

The carbon footprint of a large rack mounted server is order-of-magnitude a ton of carbon a year. A rough guide if you don’t have any better data is that with no traffic to a system it will be 10% utilization and use 30% of peak power, 25% utilization uses 50% of peak power, and at 50% utilization it uses 75% of peak power.

Energy 52

Energy Cloud Traffic Transportation 52

Percona

APRIL 17, 2023

Operating System (OS) settings Swappiness Swappiness is a Linux kernel setting that influences the behavior of the Virtual Memory manager when it needs to allocate a swap, ranging from 0-100. 20-30% is a good general default for “dirty_ratio,” but on large-memory database servers, this can be a lot of memory.

Best Practices 52

Best Practices Design Tuning Database 52

Particular Software

MARCH 11, 2019

Unfortunately it makes ordered delivery virtually impossible to support. Instead of scaling up, where you buy more powerful and expensive hardware, you scale out by having more servers processing messages. Every server basically competes for messages, doing their best to process as many as they can.

Virtualization 69

Virtualization Scalability Servers Processing 69

Brendan Gregg

SEPTEMBER 25, 2021

CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. 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!

Speed 52

Speed Java AWS Virtualization 52

Brendan Gregg

SEPTEMBER 25, 2021

CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. 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!

Speed 40

Speed Java AWS Virtualization 40

Dynatrace

AUGUST 5, 2019

Resource consumption & traffic analysis. Lift & Shift is where you basically just move physical or virtual hosts to the cloud – essentially you just run your host on somebody else’s hardware. What is the network traffic going to be between services we migrate and those that have to stay in the current data center?

Cloud 31

Cloud Traffic Database Network 31

Brendan Gregg

SEPTEMBER 5, 2017

Linux has been adding tracing technologies over the years: kprobes (kernel dynamic tracing), uprobes (user-level dynamic tracing), tracepoints (static tracing), and perf_events (profiling and hardware counters). Oracle VM Server is based on Xen. I also wrote and published an entertaining SMF manifest that played music.

Virtualization 76

Virtualization AWS Engineering Hardware 76

Percona

AUGUST 27, 2018

Essentially, you can assign a thread to a specific virtual CPU. 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.

Tuning 45

Tuning Virtualization Testing Servers 45

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

JANUARY 18, 2012

s web-based applications often encounter database scaling challenges when faced with growth in users, traffic, and data. Behind the scenes, Amazon DynamoDB automatically spreads the data and traffic for a table over a sufficient number of servers to meet the request capacity specified by the customer.

Scalability 167

Scalability Database Ecommerce Latency 167