SQL Shack

SEPTEMBER 9, 2019

In this article, we will study in detail about the how SQL Server Index Fill factor works. This option is available in index properties to manage data storage in the data pages. Index Fill factor SQL Server Index Fill Factor is a percentage value to be filled data page with data in SQL Server. It […].

Servers 56

Servers Benchmarking Performance Storage 56

Scalegrid

MARCH 28, 2024

This article will explore how they handle data storage and scalability, perform in different scenarios, and, most importantly, how these factors influence your choice. It uses a hash table to manage these pairs, divided into fixed-size buckets with linked lists for key-value storage.

Cache 130

Cache Storage Scalability Architecture 130

Particular Software

SEPTEMBER 20, 2021

Why RPC is “faster” It’s tempting to simply write a micro-benchmark test where we issue 1000 requests to a server over HTTP and then repeat the same test with asynchronous messages. If you did such a benchmark, here’s an incomplete picture you might end up with: Graph of microbenchmark showing RPC is faster than messaging.

Benchmarking 97

Benchmarking Latency Servers Systems 97

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

SQL Performance

DECEMBER 17, 2019

This removes the burden of purchasing and maintaining your hardware, storage and networking infrastructure, while still giving you a very familiar experience with Windows and SQL Server itself. There are also large differences in storage capacity and throughput between these extremes.

Azure 72

Azure Virtualization Servers Storage 72

Scalegrid

JANUARY 12, 2024

This article analyzes cloud workloads, delving into their forms, functions, and how they influence the cost and efficiency of your cloud infrastructure. Storage is a critical aspect to consider when working with cloud workloads. What is an example of a workload?

Cloud 130

Cloud Virtualization Storage Efficiency 130

Scalegrid

DECEMBER 6, 2023

Self-managed databases come with their own set of expenses that must be factored in – managing a database requires time and effort which often includes backup storage, patching software upgrades as well as other typical administration tasks. Make sure to read our extensive article on DBaaS Pros and Cons !

Database 130

Database Cloud Hardware Storage 130

Smashing Magazine

SEPTEMBER 28, 2022

On your first try, you can use it as a benchmark for optimizations later. Caching partially stores your data and is not used as permanent storage. Using the cache as permanent storage is an anti-pattern. I hope you found this article helpful. It is important to note how much data the client needs to download.

Cache 141

Cache Performance Servers Architecture 141

Abhishek Tiwari

DECEMBER 27, 2017

faster access to external storage and data locality (I/O, bandwidth). A recent performance benchmark completed by Intel and BlueData using the BigBench benchmarking kit has shown that the performance ratios for container-based Hadoop workloads on BlueData EPIC are equal to and in some cases, better than bare-metal Hadoop [7].

Big Data 63

Big Data Storage Benchmarking Hardware 63

All Things Distributed

NOVEMBER 19, 2010

There was an excellent first benchmarking report of the Cluster GPU Instances by the folks at Cycle Computing - " A Couple More Nails in the Coffin of the Private Compute Cluster " The Top500 supercomputer list. Driving Storage Costs Down for AWS Customers. Expanding the Cloud - The AWS Storage Gateway. At werner.ly

AWS 62

AWS Cloud Benchmarking Storage 62

HammerDB

NOVEMBER 5, 2018

This post at an entry-level discusses the options you have to improve log throughput in your benchmark environment. . For MySQL the dependency is at the storage engine level and in this case for the InnoDB storage engine the parameter is self-explanatory. innodb_flush_log_at_trx_commit=0. PostgreSQL.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

Percona

DECEMBER 20, 2018

We look forward to providing you with even better articles, news and information in 2019. As the MyRocks storage engine (based on the RocksDB key-value store [link] ) is now available as part of Percona Server for MySQL 5.7 , I wanted to take a look at how it performs on a relatively high-end server and SSD storage.

Database 50

Database Tuning Performance AWS 50

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. These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. Figure 1: CPU-Z Benchmark Results for LS16v2. Memory (GiB).

Azure 42

Azure Virtualization Storage Benchmarking 42

CSS - Tricks

JUNE 5, 2020

The HBO sitcom Silicon Valley hilariously followed Pied Piper, a team of developers with startup dreams to create a compression algorithm so powerful that high-quality streaming and file storage concerns would become a thing of the past. This article is about my experience using Brotli at production scale.

Cache 83

Cache Website Servers Open Source 83

O'Reilly

JULY 25, 2023

This article summarizes what I learned from that experience. The inspiration (and title) for it comes from Mike Loukides’ Radar article on Real World Programming with ChatGPT , which shares a similar spirit of digging into the potential and limits of AI tools for more realistic end-to-end programming tasks.

Programming 98

Programming Code Design Benchmarking 98

Alex Russell

MARCH 6, 2021

A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. Using a global ASP as a benchmark can further mislead thanks to the distorting effect of ultra-high-end prices rising while shipment volumes stagnate. The Moto G4 , for example.

Performance 127

Performance Network Mobile Metrics 127

Alex Russell

OCTOBER 22, 2017

Budgets are scaled to a benchmark network & device. Deciding what benchmark to use for a performance budget is crucial. Simulated packet loss and variable latency, however, can make benchmarking extremely difficult and slow. Previous versions of this article discussed slow-start, bdp, tcp window scaling, and the like.

Performance 74

Performance Network Benchmarking Mobile 74

Percona

JULY 1, 2023

Multi-Availability Zone (AZ) Deployment Aurora’s Multi-Availability Zone (AZ) deployment offers remarkably high availability and fault tolerance by automatically replicating data across multiple availability zones using its distributed storage architecture to eliminate single points of failure. RDS MySQL is 5.5,

AWS 52

AWS Database Serverless Storage 52

Percona

MAY 1, 2023

Hardware optimization : You need to ensure that the CPU, memory, and storage components meet the performance requirements of the database workload. PostgreSQL performance optimization is an ongoing process involving monitoring, benchmarking, and adjustments to maintain high-performing PostgreSQL databases.

Tuning 52

Tuning Database Efficiency Performance 52

Percona

AUGUST 22, 2023

This blog article will examine shared attributes of high availability (HA) and fault tolerance (FT). Error detection and correction: Techniques such as checksums, parity bits, and error-correcting codes are used to detect and correct errors that might occur during data transmission or storage.

Availability 98

Availability Hardware Open Source Database 98

Percona

SEPTEMBER 1, 2023

Inadequate CPU, memory, or storage can lead to bottlenecks and performance degradation, so remedying these issues involves upgrading hardware or optimizing resource utilization through query and server configuration adjustments. Avoid over-indexing, which can bloat storage and slow writes.

Tuning 52

Tuning Database Performance Hardware 52

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. Stable Media Stable media is often confused with physical storage. SQL Server defines stable media as storage that can survive system restart or common failure.

Servers 40

Servers Cache Media Hardware 40

Smashing Magazine

JANUARY 6, 2020

Geekbench CPU performance benchmarks for the highest selling smartphones globally in 2019. From Addy’s article “ Loading Web Pages Fast On A $20 Feature Phone ”. Will you be using AMP or Instant Articles? On a middle-class mobile device, that accounts for 15–25 seconds for Time-To-Interactive. Large preview ).

Performance 112

Performance Cache Servers Network 112

Smashing Magazine

JANUARY 11, 2021

It’s worth noting that you will end up with better Core Web Vitals scores by following a general advice in this article.). Geekbench CPU performance benchmarks for the highest selling smartphones globally in 2019. From Addy’s article “ Loading Web Pages Fast On A $20 Feature Phone ”. Largest Contentful Paint ( LCP ) < 2.5

Performance 145

Performance Cache Media Metrics 145

SQL Server According to Bob

JANUARY 11, 2020

​​ The storage ​​ space that is required ​​ for the sparse file is only that of the actual bytes written to the file and not the ​​ maximum ​​ file ​​ size.

Servers 40

Servers Cache Database Media 40

High Scalability

NOVEMBER 25, 2019

It is limited by the disk space; it can’t expand storage elastically; it chokes if you run few I/O intensive processes or try collaborating with 100 other users. Over time, costs for S3 and GCS became reasonable and with Egnyte’s storage plugin architecture, our customers can now bring in any storage backend of their choice.

Architecture 52

Architecture Cache Azure Storage 52