Percona

AUGUST 22, 2023

Estimates vary, but most reports put the average cost of unplanned database downtime at approximately $300,000 to $500,000 per hour, or $5,000 to $8,000 per minute. With so much at stake, database high availability and fault tolerance have become must-have items, but many companies just aren’t certain which one they must have.

Availability 78

Availability Hardware Open Source Database 78

Scalegrid

JANUARY 5, 2024

If you’re considering a database management system, understanding these benefits is crucial. This article cuts through the complexity to showcase the tangible benefits of DBMS, equipping you with the knowledge to make informed decisions about your data management strategies.

Efficiency 147

Efficiency Storage Database Scalability 147

Percona

JULY 1, 2023

Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? What we should really compare is the MySQL and Aurora database engines provided by Amazon RDS.

AWS 52

AWS Database Serverless Storage 52

Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013. Not available.

Open Source 244

Open Source Tuning C++ Database 244

Testlodge

APRIL 14, 2021

These systems are a combination of different hardware and software which have been configured to perform the desired task. Configuration testing is performed to discover the optimum combinations of software and hardware specifications that allow the system to work without flaws. Types of Configuration Testing.

Testing 89

Testing Hardware Virtualization Operating System 89

Highly Scalable

SEPTEMBER 18, 2012

These developments gradually highlight a system of relevant database building blocks with proven practical efficiency. In this article I’m trying to provide more or less systematic description of techniques related to distributed operations in NoSQL databases. Data Placement. System Coordination. Read/Write latency.

Database 213

Database Latency C++ Scalability 213

Scalegrid

JANUARY 8, 2024

Discover key insights and strategic advice in our article, designed to steer you toward the best cloud solution that fits your company’s priorities. For example, an application could use on-premises databases while also having access to ‘cloud bursting’ capabilities during times of high demand. But what do these entail?

Strategy 147

Strategy Cloud Scalability Artificial Intelligence 147

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

DZone

MAY 14, 2020

The performance claims made and the hype surrounding the Graviton2 had us itching to see how our high-performance database would perform. This article compares KeyDB running on several different M5 & M6g EC2 instances to get some insight into cost, performance, and use case benefits.

AWS 130

AWS Benchmarking Database Performance 130

Percona

JUNE 20, 2023

I tried to search for details related to segmentation fault on the internet and found many articles; however, it failed to quench my thirst as none of them had the answer I was looking for. In this section, I will focus on a scenario in the PostgreSQL database that causes segmentation fault.

Programming 82

Programming C++ Database Virtualization 82

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. You will still have to maintain your operating system, SQL Server and databases just like you would in an on-premises scenario. Esv3-series.

Azure 72

Azure Virtualization Servers Storage 72

Smashing Magazine

OCTOBER 11, 2022

In this article, we’ll explore some of the ways that we as individuals can use our skills to have a positive environmental impact within a digital organization. For example, changing our database architecture to be more efficient could save on server costs. Hardware And E-Waste. Image credit: BBC.com ) ( Large preview ).

Strategy 126

Strategy Development Energy Website 126

SQL Performance

JANUARY 23, 2020

Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006. Recently, a SentryOne customer contacted me about performance concerns with their SentryOne database. The Top Queries That Weren't.

Tuning 115

Tuning Servers Monitoring Hardware 115

SQL Performance

JUNE 21, 2019

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. When looking at backups, I check for recovery model and the current history of backups for each database. Azure SQL Database and Azure Managed Instance have managed backups.

Servers 49

Servers Azure Hardware Database 49

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Stack Overflow 2013 database comes without nonclustered indexes to minimize download time. Test Environment. BountyAmount.

Servers 86

Servers Tuning Database Efficiency 86

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. But I'm not completely sure.

Speed 126

Speed Java AWS Virtualization 126

Testsigma

FEBRUARY 3, 2021

Mobiles have different models, screen resolutions, operating systems, network types, hardware configurations, etc. Also, how to test the hardware of the mobile phone itself, is it supporting all the software as it should? Let us have a look at the most popular types of mobile testing for applications and hardware.

Mobile 82

Mobile Testing Hardware C++ 82

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

All Things Distributed

JANUARY 29, 2017

This article titled " Überlebensstrategie für die digitale Transformation " appeared in German last week in the "Die Zukunft beginnt heute (the future starts today)" section of Wirtschaftwoche. Smaller companies have a lot to gain in the digital era – provided they adopt the right mindset.

Strategy 109

Strategy Innovation Entertainment Hardware 109

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 Linux default is usually 60 , which is not ideal for database usage. Spoiler alert: This post focuses on MongoDB 3.6.X

Best Practices 52

Best Practices Design Tuning Database 52

Dotcom-Montior

DECEMBER 8, 2021

In a different article, we talked about chaos engineering and how SRE teams proactively seek out and test for failures to prevent the worst from happening. The IT service catalog is typically a database or resource that an organization creates to provide users with information on their operational services and offerings.

Social Media 90

Social Media Monitoring Latency DevOps 90

Alex Podelko

SEPTEMBER 8, 2020

Otherwise we wouldn’t see so many commercial tools built on the top of open source including BlazeMeter (it is ironic that the article is posted on the BlazeMeter site), Flood, and OctoPerf. You do not need to trouble yourself with datasets, hardware, reporting or any of the usual pain points of JMeter, we’ll do it for you.

Open Source 223

Open Source Performance Testing Testing Performance 223

SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. Microsoft SQL Server Database Engine Input/Output Requirements. Linux may need similar utilities to control various hardware cache installations. The Back Story. Fua = Forced Unit Access.

Servers 90

Servers Media Cache Storage 90

SQL Performance

JANUARY 22, 2020

By their very definition, table-valued parameters are strongly-typed to a user-defined table type that must exist within the database where the call is being made. However, strongly-typed isn't really strictly "strongly-typed" as you would expect, as this article is going to demonstrate, and performance could be impacted as a result.

Servers 55

Servers Azure Hardware Network 55

Highly Scalable

AUGUST 20, 2013

This article is an effort to explore techniques used by developers of in-stream data processing systems, trace the connections of these techniques to massive batch processing and OLTP/OLAP databases, and discuss how one unified query engine can support in-stream, batch, and OLAP processing at the same time.

Big Data 154

Big Data Processing Lambda Database 154

Testsigma

DECEMBER 28, 2019

Let us discuss Regression Testing vs Retesting in detail in the article. Resource Requirement: Hardware Requirements: Any hardware requirements which will be required during testing are identified, such as laptops, desktops, smartphones, etc. Key Features: Supports database, object-driven, data-driven, keyword-driven testing.

Testing 53

Testing Hardware Testing Tools Strategy 53

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? SQL Server 2005 introduces the snapshot database feature for point-in-time databases ​​ and online DBCC operations.

Servers 40

Servers Cache Database Media 40

Highly Scalable

APRIL 2, 2012

In this article, I describe major architectural decisions we made and techniques we used. I can recommend this article by Peter Morville and Jeffrey Callender for further reading. Taking into account the previous considerations, performance requirements were set as 1000 faceted navigation requests/second per typical hardware blade.

Ecommerce 100

Ecommerce Cache Storage Architecture 100

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI.

Speed 52

Speed Java AWS Virtualization 52

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. But I'm not completely sure.

Speed 40

Speed Java AWS Virtualization 40

Alex Russell

MARCH 6, 2021

Hardware Past As Performance Prologue. Regardless, the overall story for hardware progress remains grim, particularly when we recall how long device replacement cycles are: Tap for a larger version. But the hardware future is not evenly distributed, and web workloads aren't heavily parallel. Mind The Gap.

Performance 124

Performance Network Cache Metrics 124

SQL Performance

MARCH 8, 2021

This article aims to help you understand where the timings come from in each case, and how they can be best interpreted in context. The following examples use the public Stack Overflow 2013 database ( download details ), with a single index added: CREATE INDEX PP ON dbo. The clock keeps running at the same rate even during sleep.

Servers 95

Servers Tuning Architecture Performance 95

Smashing Magazine

JANUARY 6, 2020

On the other hand, we have hardware constraints on memory and CPU due to JavaScript parsing times (we’ll talk about them in detail later). From Addy’s article “ Loading Web Pages Fast On A $20 Feature Phone ”. To achieve the goals stated in the first paragraph, we have to consider the critical file size budget for JavaScript.

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

JANUARY 15, 2019

The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral. how much data does the browser have to download to display your website) and resource usage of the hardware serving and receiving the website.

Website Performance 74

Website Performance Website Energy Performance 74

Smashing Magazine

JANUARY 7, 2019

On the other hand, we have hardware constraints on memory and CPU due to JavaScript parsing times (we’ll talk about them in detail later). awesome-webpack is a curated list of useful Webpack resources, libraries and tools, including articles, videos, courses, books and examples for Angular, React and framework-agnostic projects.

Performance 104

Performance Cache Metrics Network 104

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. Database administrators with appropriate privileges can associate virtual CPUs with resource groups and assign threads to these groups.

Tuning 44

Tuning Virtualization Testing Servers 44

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. SSD) we can’t utilize the full potential of IOPS with just one thread.

Cache 46

Cache C++ AWS Airlines 46