Scalegrid

APRIL 16, 2020

Where you decide to host your cloud databases is a huge decision. But, if you’re considering leveraging a managed databases provider, you have another decision to make – are you able to host in your own cloud account or are you required to host through your managed service provider? Where to host your cloud database?

Cloud 242

Cloud Azure AWS Database 242

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. Instead, focus on understanding what the workloads exercise to help us determine how to best use them to aid our performance assessment. TB)) for storage of database tablespaces and logging. Database: MySQL 8.0.31

Performance 54

Performance Benchmarking Cache Storage 54

J. Paul Reed

AUGUST 7, 2023

Even though that remediation task was pretty minor — tweaking some low-level hardware settings on each physical server and rebooting — and could have been done quickly enough, there was intense debate on whether it should be done. In practice (and I’ve done this exercise with teams), this spectrum can provide useful insight.

Engineering 52

Engineering Hardware Games Infrastructure 52

SQL Performance

DECEMBER 27, 2019

ALTER DATABASE OCopy ADD FILE ( name = N'CCI_8' , size = 250000 , filename = 'K:Datao_cci_8.mdf' mdf' ) TO FILEGROUP FG_CCI ; ALTER DATABASE OCopy ADD FILE ( name = N'CCI_P_1' , size = 250000 , filename = 'K:Datao_p_1.mdf' ALTER DATABASE OCopy ADD FILE ( name = N'CCI_P_8' , size = 250000 , filename = 'K:Datao_p_8.mdf'

Database 70

Database Storage Hardware Efficiency 70

Percona

AUGUST 8, 2023

Hardware considerations The first thing we have to consider here is the resources that the underlying host provides to the database. Global memory caches are static in size as they are defined solely by the configuration of the database itself. Let’s take a look at each common resource.

Traffic 88

Traffic Cache Monitoring Database 88

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

Adrian Cockcroft

NOVEMBER 11, 2019

There are many possible failure modes, and each exercises a different aspect of resilience. This discussion focuses on hardware, software and operational failure modes. A resilient system continues to operate successfully in the presence of failures. that are used across multiple applications.

Latency 52

Latency Engineering Systems Hardware 52