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. Both of these Intel processors are special bespoke models that are not in the Intel ARK database. The key specifications for the Lsv2 series virtual machines are shown in Table 1.

Azure 42

Azure Virtualization Storage Benchmarking 42

Dynatrace

SEPTEMBER 23, 2021

In 2019, Gartner reported that 30% of organizations worldwide were running containerized applications. Unfortunately, container security is much more difficult to achieve than security for more traditional compute platforms, such as virtual machines or bare metal hosts. Harden the host operating system. Source code tests.

Open Source 247

Open Source Benchmarking Best Practices Network 247

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 85

Availability Open Source Architecture Database 85

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. HammerDB has graphical and command line interfaces for the Windows and Linux operating systems. Why HammerDB was developed.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. top(1) showed that only the Cassandra database was consuming CPU. Microbenchmark os::javaTimeMillis() on both systems.

Speed 126

Speed Java AWS Virtualization 126

Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

Database 40

Database Tuning Performance AWS 40

Enprowess

SEPTEMBER 7, 2021

Real-time software system – Collaboration tools used for video/audio conferencing, document writing, Chat applications, etc. It helps isolated bugs quickly and reduces system downtime. React is an open-source front-end library based on JavaScript, created and maintained by Facebook, and is well known for its virtual DOM feature.

Open Source 52

Open Source Virtualization Programming Servers 52

Scalegrid

OCTOBER 2, 2019

October 2, 2019 – ScaleGrid, a rapidly growing leader in the Database-as-a-Service (DBaaS) space, has just launched their new fully managed Redis on Azure service. Redis, the #1 key-value store and top 10 database in the world, has grown by over 300% in popularity over that past 5 years, per the DB-Engines knowledge base.

Azure 37

Azure Cloud Open Source Virtualization 37

Percona

SEPTEMBER 1, 2023

This blog was originally published in February 2019 and was updated in September 2023. Web applications rely on databases to run the internet, powering everything from e-commerce platforms to social media networks to streaming services. This affects the type and range of characters that can be inserted into the column.

Performance 52

Performance Storage Social Media Database 52

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. rc3-custom #1 SMP Mon Aug 12 14:07:33 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux Welcome to Ubuntu 19.04 (GNU/Linux 5.3.0-rc3-custom So by default, the system boots into powersave.

Benchmarking 63

Benchmarking Performance Hardware C++ 63

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. For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes.” – [link]. The Back Story.

Servers 90

Servers Media Cache Storage 90

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. top(1) showed that only the Cassandra database was consuming CPU. Microbenchmark os::javaTimeMillis() on both systems.

Speed 52

Speed Java AWS Virtualization 52

HammerDB

JULY 8, 2019

HammerDB already has 2 interfaces with which to interface with the commands to build and test databases using the GUI interface or CLI. From HammerDB version 3.2 there is an additional interface that enables HammerDB to run as Web Service. hammerdbws HammerDB Web Service v3.2 Using a browser to navigate to that port will show the help screen.

Benchmarking 40

Benchmarking Virtualization C++ Database 40

SQL Performance

AUGUST 27, 2019

On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named "Rome" at the AMD EPYC Horizon Event in San Francisco. Single-Socket Database Servers. This system has one AMD EPYC 7502P 32-core processor and 512GB of RAM. The price per QphH for this system is 0.34

Servers 52

Servers Benchmarking Virtualization Architecture 52

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. top(1) showed that only the Cassandra database was consuming CPU. Microbenchmark os::javaTimeMillis() on both systems.

Speed 40

Speed Java AWS Virtualization 40

Apica

MAY 10, 2019

2019 will go down as the year when giants collided over who is streaming the right content to win the growing market demand and dollars. Disney announced they would have a streaming service, while Netflix subscribers reached an all-time high with 137.1 million Netflix users as of Q3 2018.

Testing 40

Testing Performance Social Media Wireless 40

HammerDB

OCTOBER 12, 2018

As with the previous guides as an Intel employee (#IAMINTEL) the examples are taken from a MySQL 8 on Linux on Intel system and the approach is the same for whatever system you are testing although some of the settings you see may be different. Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB.

Best Practices 40

Best Practices Scalability Performance C++ 40

High Scalability

OCTOBER 3, 2019

ScaleGrid, a rapidly growing leader in the Database-as-a-Service (DBaaS) space, has just launched their new fully managed Redis on Azure service. Redis, the #1 key-value store and top 10 database in the world, has grown by over 300% in popularity over that past 5 years, per the DB-Engines knowledge base.

Azure 23

Azure Cloud Open Source Cache 23

Dynatrace

JANUARY 15, 2020

Having released this functionality in an Preview Release back in September 2019, we’re now happy to announce the General Availability of our Citrix monitoring extension. Dynatrace Extension: database performance as experienced by the SAP ABAP server. Tie latency issues to host and virtualization infrastructure network quality.

Latency 36

Latency Performance Virtualization Infrastructure 36

Smashing Magazine

SEPTEMBER 26, 2019

2019-09-26T12:30:59+02:00. 2019-09-26T11:02:12+00:00. Since the integrated application (Vue in our case) is rendered in the main DOM tree, global scope in JavaScript is conflicts-prone: both systems might want to manipulate DOM nodes that do not belong to them. Frankenstein Migration: Framework-Agnostic Approach (Part 1).

Architecture 73

Architecture Virtualization Servers Technology 73

O'Reilly

FEBRUARY 18, 2020

Growth is still strong for such a large topic, but usage slowed in 2018 (+13%) and cooled significantly in 2019, growing by just 7%. But sustained interest in cloud migrations—usage was up almost 10% in 2019, on top of 30% in 2018—gets at another important emerging trend. Still cloud-y, but with a possibility of migration.

Software Architecture 134

Software Architecture DevOps Data Engineering Architecture 134

O'Reilly

JULY 15, 2020

Almost one-third (29%) of respondents say their employers are migrating or implementing a majority of their systems (over 50%) using microservices. software and systems architects, technical leads—architects represent almost 28% of the sample. Adopters are betting big on microservices. Figure 1: Respondent roles.

Database 135

Database Architecture Education Systems 135