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. This server is spending about a third of its CPU cycles just checking the time!

Speed 52

Speed Java AWS Virtualization 52

SQL Performance

APRIL 27, 2020

Azure SQL Database is Microsoft's database-as-a-service offering that provides a tremendous amount of flexibility. Microsoft is continually working on improving their products and Azure SQL Database is no different. HyperScale Database. Hyperscale databases are provisioned using vCores. DTU Pricing Tier.

Azure 55

Azure Database Serverless Hardware 55

Percona

OCTOBER 2, 2023

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. virtual = 2.2G virtual = 2.2G

Cache 99

Cache Database Virtualization Servers 99

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. Since then, Microsoft has changed the naming of this series to Lsv2.

Azure 42

Azure Virtualization Storage Benchmarking 42

Percona

JULY 15, 2023

One very common problem when trying to optimize a database environment is index usage. Introduction to MySQL Indexes Indexes in MySQL are database structures used to optimize data retrieval speed and efficiency. They are a roadmap that speeds up the process of finding specific rows in a large table. What is an Index?

Virtualization 77

Virtualization Speed Database Efficiency 77

Percona

SEPTEMBER 6, 2023

Functional indexes are found in both of Percona’s relational databases, MySQL and PostgreSQL, but they are probably the least used and most understood index type, aside from geospatial. Thus, indexes on expressions are useful when retrieval speed is more important than insertion and update speed.

Speed 82

Speed Virtualization Storage Open Source 82

Dynatrace

MAY 8, 2023

The process involves monitoring various components of the software delivery pipeline, including applications, infrastructure, networks, and databases. Infrastructure monitoring Infrastructure monitoring reviews servers, storage, network connections, virtual machines, and other data center elements that support applications.

DevOps 228

DevOps Efficiency Monitoring Infrastructure 228

Dynatrace

NOVEMBER 23, 2020

While speeding up development processes and reducing complexity does make the lives of Kubernetes operators easier, the inherent abstraction and automation can lead to new types of errors that are difficult to find, troubleshoot, and prevent. Logs are easy to produce and provide data in plain-text, structured (JSON, XML), or binary format.

Virtualization 163

Virtualization Infrastructure Monitoring Cloud 163

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. This server is spending about a third of its CPU cycles just checking the time!

Speed 40

Speed Java AWS Virtualization 40

Percona

SEPTEMBER 1, 2023

Database architects working with MongoDB encounter specific challenges related to database systems and system growth. Scalability is a significant concern, as databases must handle growing data volumes and user demands while maintaining peak performance.

Best Practices 72

Best Practices Traffic Database Servers 72

HammerDB

APRIL 27, 2021

As the workflow in the CLI and GUI are the same we will show equivalent commands side by side to help you quickly get up to speed on using the CLI in both interactive and scripted scenarios. One of the first things you will want to do is make sure that we can access the 3rd party driver libraries for the database that we want to use.

Virtualization 73

Virtualization Benchmarking Database Operating System 73

Brendan Gregg

NOVEMBER 28, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. It's an exciting development in cloud computing: hardware virtualization is now fast. Virtualized in Hardware**: Hardware support for virtualization, and near bare-metal speeds.

Virtualization 40

Virtualization AWS Hardware Storage 40

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. 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. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS.

Servers 49

Servers Azure Hardware Database 49

Dynatrace

APRIL 21, 2022

Getting precise root cause analysis when dealing with several layers of virtualization in a containerized world. Too much data requested from a database. The concept of “ shift-left SRE ” introduces SLOs earlier in the lifecycle to improve the quality and speed of your software releases. Missing caching layers.

Azure 197

Azure Monitoring Virtualization Metrics 197

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. This is the second generation EPYC server processor that uses the same Zen 2 architecture as the AMD Ryzen 3000 Series desktop processors.

Servers 52

Servers Benchmarking Virtualization Architecture 52

HammerDB

JUNE 27, 2022

This post is targeted towards the questions most often asked by non-technical management who want to get up to speed on what HammerDB is (what it isn’t) and how it can benefit their organization. HammerDB is a software application for database benchmarking. What is HammerDB? Why HammerDB was developed. The HammerDB name.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

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

Dynatrace

MAY 28, 2020

If you have a distributed environment with multiple servers hosting your webservers, app servers, and database, I suggest you install the OneAgent on all these servers to get full end-to-end visibility. This will enable deep monitoring of those Java,NET, Node, processes as well as your web servers.

Engineering 198

Engineering Performance Metrics Best Practices 198

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

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. Regardless of whether the computing platform to be evaluated is on-prem, containerized, virtualized, or in the cloud, it is crucial to consider several essential factors. TB)) for storage of database tablespaces and logging.

Performance 54

Performance Benchmarking Cache Storage 54

SQL Server According to Bob

JANUARY 11, 2020

Microsoft, ​​ Windows, ​​ Windows NT, ​​ and Windows Server ​​ are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40

Servers Cache Database Media 40

MachMetrics

OCTOBER 12, 2020

Everyone should just use a static site generator and experience incredible speed increases? It can, of course, be changed by the developer, but after it is built and stored on a server, it gets sent to your visitors exactly the same way until it’s updated. So is that the magic bullet? Take a WordPress blog page for example.

Website 52

Website Speed Traffic Database 52

All Things Distributed

OCTOBER 2, 2017

Today marks the 10 year anniversary of Amazon's Dynamo whitepaper , a milestone that made me reflect on how much innovation has occurred in the area of databases over the last decade and a good reminder on why taking a customer obsessed approach to solving hard problems can have lasting impact beyond your original expectations.

Internet 128

Internet Internet AWS Performance 128

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. Then follow the instructions to either download the BOL or browse online.

Servers 40

Servers Cache Media Hardware 40

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

ScaleOut Software

JULY 19, 2021

Incoming data is saved into data storage (historian database or log store) for query by operational managers who must attempt to find the highest priority issues that require their attention. The best they can usually do in real-time using general purpose tools is to filter and look for patterns of interest.

IoT 78

IoT Analytics Big Data Architecture 78

SQL Server According to Bob

JULY 13, 2016

20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here is SQL Server. So I proceeded to install SQL Server 4.20 There was a GUI as part of setup but within just a few clicks, SQL Server was installed and ready for use. So now there are more choices to make when installing SQL Server.

Servers 40

Servers Media Engineering Virtualization 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

O'Reilly

NOVEMBER 21, 2019

It enlists software “robots” to automate the rote, repetitive, or tedious tasks that bridge virtual gaps, or facilitate virtual transfers or exchanges, in and between common business processes. Virtual automation has a long history. Virtually anything can be scripted—including keyboard, mouse, and GUI actions.

Processing 83

Processing Programming Virtualization Technology 83

O'Reilly Software

FEBRUARY 28, 2018

I suggested the radical modular breakdown of applications in a 2002 article , saying that: "the application , once the central fixture of computer use, would dissolve into a soup of servers, application fragments, and user interfaces." A programmer can then fill in the stub. The deployment stage. There are ways to automate these processes.

Development 69

Development Retail Traffic Virtualization 69

Dotcom-Montior

NOVEMBER 27, 2018

Additionally, end users can access your site or applications from anywhere in the world using different browsers, operating systems, and mobile devices, all with varying connection speeds. Analyzing server performance (CPU, memory, bandwidth, disk I/O) and database response times. LoadView – Best Practices and Process.

Performance Testing 40

Performance Testing Strategy Testing Performance 40

HammerDB

OCTOBER 12, 2018

Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. As is exactly the same with PostgreSQL for system choice a 2 socket system is optimal for MySQL OLTP performance.

Best Practices 40

Best Practices Scalability Performance C++ 40

Testsigma

JUNE 15, 2021

We need more than just an automation tool for performing in-sprint testing, as in-sprint testing requires speed, accuracy, flexibility, and ease of adaptability. To speed up your maintenance efforts, Testsigma can quickly detect bugs and errors, including bottlenecks based on former error patterns. Very affordable. Supports Shift-Left.

Testing 52

Testing DevOps Mobile Testing Tools 52

MachMetrics

SEPTEMBER 5, 2019

Are you building an e-commerce store with thousands of products and a huge database? . The owner of the website also benefits in the form of lower bounce rates and reduced server loads (resulting in lower hosting costs). The post The 7 Habits of Highly Performing Websites appeared first on MachMetrics Speed Blog.

Website 48

Website Performance Speed Design 48

IO River

NOVEMBER 2, 2023

Real-time monitoring can help detect any anomalies as soon as they happen, thereby increasing the speed at which problems can be diagnosed and solved. When you codify infrastructure, you can integrate it with DevOps pipelines to automate various tasks like server provisioning, database scale, and security audits.

Open Source 52

Open Source DevOps AWS Azure 52

Testsigma

FEBRUARY 3, 2021

Parameters that are measured during performance testing ( for mobile ) include – speed, memory consumption, battery life, data transfer, etc. This includes- database, memory, CPU usage etc. Because it is difficult to have so many real users to test, we use automated tools to create virtual users. Security Testing.

Mobile 82

Mobile Testing Hardware C++ 82

Dynatrace

AUGUST 5, 2019

Database & functional migration. Lift & Shift is where you basically just move physical or virtual hosts to the cloud – essentially you just run your host on somebody else’s hardware. The following shows one of the slides I use to answer the question: What happens if I move this group of servers? What’s in your stack?”.

Cloud 31

Cloud Traffic Database Network 31