SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. The L3 cache size is 64MB. The AMD EPYC 7551 processor has slightly lower single-threaded CPU performance when compared to the older 2.3 The L3 cache size is 64MB.

Azure 42

Azure Virtualization Storage Benchmarking 42

Scalegrid

APRIL 16, 2020

While this is a good way to get a rough estimate, your monthly cloud costs will indeed vary based on the amount of backups performed and your data transfer activity. A vast majority of the features are the same, outside of these advanced features available through the BYOC model: Virtual Private Clouds / Virtual Networks.

Cloud 242

Cloud Azure AWS Database 242

IO River

NOVEMBER 2, 2023

A CDN (Content Delivery Network) is a network of geographically distributed servers that brings web content closer to where end users are located, to ensure high availability, optimized performance and low latency. The result would be a performance drop in the end users’ experience, often causing the application to become unusable.

Best Practices 52

Best Practices Strategy Traffic Virtualization 52

ACM Sigarch

MAY 31, 2023

Heterogeneous and Composable Memory (HCM) offers a feasible solution for terabyte- or petabyte-scale systems, addressing the performance and efficiency demands of emerging big-data applications. CXL-based disaggregated memory provides a new opportunity with two orders of magnitude better performance than RDMA (as illustrated in Figure 2).

Latency 52

Latency Hardware Cache Architecture 52

Scalegrid

JULY 29, 2020

In our final post, we will put them head-to-head in a detailed feature comparison and compare the results of PgBouncer vs. Pgpool-II performance for your PostgreSQL hosting ! PgBouncer provides a virtual database that reports various useful statistics. Performance Testing. PostgreSQL Connection Pooling Series. Administration.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

IO River

NOVEMBER 2, 2023

A CDN (Content Delivery Network) is a network of geographically distributed servers that brings web content closer to where end users are located, to ensure high availability, optimized performance and low latency. The result would be a performance drop in the end users’ experience, often causing the application to become unusable.

Best Practices 40

Best Practices Strategy Traffic Virtualization 40

IO River

NOVEMBER 2, 2023

A low-cost CDN may not always be as reliable and high-performing as a high-cost one. Therefore, you need to make sure you have the right balance between costs and performance & reliability according to your business needs.Here are some questions to ask yourself before choosing a CDN:How important is the price to you?

Infrastructure 52

Infrastructure Traffic Cache Strategy 52

The Netflix TechBlog

NOVEMBER 9, 2022

While we understand it’s virtually impossible to achieve a linear increase in throughput as the number of vCPUs grow, a near-linear increase is attainable. What’s worse, average latency degraded by more than 50%, with both CPU and latency patterns becoming more “choppy.” This was our starting point for troubleshooting.

Hardware 363

Hardware Cache Performance Latency 363

Scalegrid

FEBRUARY 8, 2024

Durability Availability Fault tolerance These combined outcomes help minimize latency experienced by clients spread across different geographical regions. Opting for synchronous replication within distributed storage brings about reinforced consistency and integrity of data, but also bears higher expenses than other forms of replicating data.

Storage 130

Storage Systems Big Data Azure 130

ScaleOut Software

MAY 15, 2014

Likewise, object access paths must be heavily multi-threaded and avoid lock contention to minimize access latency and maximize throughput. Given all this, we thought it would be a good opportunity to see how we are doing relative to the competition, and in particular, relative to Microsoft’s AppFabric caching for Windows on-premise servers.

Cache 40

Cache Servers Network Design 40

IO River

NOVEMBER 2, 2023

A low-cost CDN may not always be as reliable and high-performing as a high-cost one. Therefore, you need to make sure you have the right balance between costs and performance & reliability according to your business needs.Here are some questions to ask yourself before choosing a CDN:How important is the price to you?

Infrastructure 52

Infrastructure Traffic Cache Strategy 52

Brendan Gregg

AUGUST 18, 2019

bpftrace is a new open source tracer for Linux for analyzing production performance problems and troubleshooting software. Linux already has many performance tools, but these are often counter-based and have limited visibility. Linux already has many performance tools, but these are often counter-based and have limited visibility.

Latency 68

Latency C++ Cache Programming 68

Smashing Magazine

OCTOBER 31, 2023

Answering Common Questions About Interpreting Page Speed Reports Answering Common Questions About Interpreting Page Speed Reports Geoff Graham 2023-10-31T16:00:00+00:00 2023-10-31T17:06:18+00:00 This article is sponsored by DebugBear Running a performance check on your site isn’t too terribly difficult. Can’t be perfect every time!

Speed 99

Speed Google Website Metrics 99

SQL Performance

APRIL 27, 2020

Fast forward a few years after Azure SQL Database was released to when Azure SQL Managed Instance was in public preview, and "vCores" (virtual cores) were announced for Azure SQL Database. Hyperscale achieves high performance from each compute node having SSD-based caches which helps minimize the network round trips to fetch data.

Azure 55

Azure Database Serverless Hardware 55

ScaleOut Software

JULY 21, 2020

For more than fifteen years, ScaleOut StateServer® has demonstrated technology leadership as an in-memory data grid (IMDG) and distributed cache. Designed to help scalable applications deliver high performance, it stores live, fast-changing data in memory (DRAM) for fast updates and retrieval. The Challenges with Parallel Queries.

Analytics 52

Analytics Airlines Cache Scalability 52

ScaleOut Software

JULY 21, 2020

For more than fifteen years, ScaleOut StateServer® has demonstrated technology leadership as an in-memory data grid (IMDG) and distributed cache. Designed to help scalable applications deliver high performance, it stores live, fast-changing data in memory (DRAM) for fast updates and retrieval. The Challenges with Parallel Queries.

Analytics 52

Analytics Airlines Cache Scalability 52

Percona

APRIL 17, 2023

Note that the intent of tuning the settings is not exclusively about improving performance but also enhancing the high availability and resilience of the MongoDB database. The CFQ works well for many general use cases but lacks latency guarantees. The goal is to reduce memory usage without impacting query performance negatively.

Best Practices 52

Best Practices Design Tuning Database 52

The Morning Paper

APRIL 14, 2019

When a side-channel is based on observing improved performance, a solution that removes the improved performance can work, but is clearly undesirable. Microarchitectural state of interest includes data and instruction caches, TLBs, branch predictors, instruction- and data-prefetcher state machines, and DRAM row buffers.

Hardware 44

Hardware Cache Latency Speed 44

Enprowess

SEPTEMBER 7, 2021

Enhanced performance: It has an Asynchronous or Non-blocking nature. Developers can perform non-blocking operations, which boosts web app performance. can be scaled vertically and horizontally to improve their performance. with its low latency I/O operations, gives the benefit of ‘No buffering’ to developers.

Open Source 52

Open Source Virtualization Programming Servers 52

The Morning Paper

DECEMBER 8, 2019

At the start of November I was privileged to attend HPTS (the High Performance Transaction Systems) conference in Asilomar. Therefore any programming abstraction must be low latency and the kernel needs to be kept off the path of persistent data access as much as possible. Early performance results. PLOS’19.

Hardware 56

Hardware Programming Media Storage 56

Brendan Gregg

JANUARY 17, 2018

OSes usually show you virtual memory and resident memory, shown as the "VIRT" and "RES" columns in top. Short durations can be useful for understanding how well a WSS will fit into the CPU caches (L1/L2/L3, TLB L1/L2, etc). That's the working set size. It is used for capacity planning and scalability analysis. Consider these overheads.

Cache 71

Cache Latency C++ Programming 71

Percona

MAY 15, 2023

In both cases, when using virtually-synchronous replication, the process will require certification from each node and local (by node) write; as such, the number of writes is NOT distributed across multiple nodes but duplicated. On the contrary, also with a small load increase, we can see how the sharded solution performs better.

Traffic 122

Traffic Scalability Database Servers 122

The Netflix TechBlog

SEPTEMBER 24, 2021

The ProRes codec family provides great editing performance and image quality. Uploading and downloading data always come with a penalty, namely latency. Virtual Assembly Figure 3 describes how a virtual assembly of the encoded chunks replaces the physical assembly used in our previous architecture.

Cloud 237

Cloud Media Storage Cache 237

Alex Russell

APRIL 29, 2021

Classics of the genre include: Apple's just focused on performance! The Performance Argument. As an engineer on a browser team, I'm privy to the blow-by-blow of various performance projects, benchmark fire drills, and the ways performance marketing (deeply) impacts engineering priorities. Web Performance APIs.

Media 145

Media Games Education Engineering 145

Brendan Gregg

JANUARY 16, 2018

OSes usually show you virtual memory and resident memory, shown as the "VIRT" and "RES" columns in top. Short durations can be useful for understanding how well a WSS will fit into the CPU caches (L1/L2/L3, TLB L1/L2, etc). That's the working set size. It is used for capacity planning and scalability analysis. Consider these overheads.

Cache 40

Cache Latency C++ Programming 40

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing. Logging Waits. so what are your options?

Benchmarking 40

Benchmarking Database C++ Virtualization 40

SQL Server According to Bob

JANUARY 11, 2020

This will help you increase system performance and avoid I/O environment errors. Atomicity A transaction must be an atomic unit of work; either all of its data modifications are performed or none of them are performed. This cache is often supported by a battery-powered backup facility.

Servers 40

Servers Cache Media Hardware 40

SQL Server According to Bob

JANUARY 11, 2020

Time of Last Access The time of last access is a caching ​​ algorithm ​​ that enables ​​ cache ​​ entries to be ordered by their ​​ access times.

Servers 40

Servers Cache Database Media 40

All Things Distributed

SEPTEMBER 3, 2013

Today, we added two important choices for customers running high performance apps in the cloud: support for Redis in Amazon ElastiCache and a new high memory database instance (db.cr1.8xlarge) for Amazon RDS. Today, we are further expanding the choices available for designing and developing highly scalable and high performance apps.

Cache 129

Cache Cloud Performance Retail 129

All Things Distributed

OCTOBER 2, 2017

We were pushing the limits of what was a leading commercial database at the time and were unable to sustain the availability, scalability and performance needs that our growing Amazon business demanded. Performant – The service would need to be able to maintain consistent performance in the face of diverse customer workloads.

Internet 128

Internet Internet AWS Performance 128

All Things Distributed

JANUARY 18, 2012

Amazon DynamoDB is a fully managed NoSQL database service that provides fast performance at any scale. Amazon DynamoDB offers low, predictable latencies at any scale. It is very gratifying to see all of our learning and experience become available to our customers in the form of an easy-to-use managed service.

Scalability 167

Scalability Database Ecommerce Latency 167