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. The basic tier provides up to 5 DTUs with standard storage. HyperScale Database. DTU Pricing Tier.

Azure 55

Azure Database Serverless Hardware 55

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 84

Speed Virtualization Storage Open Source 84

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. This processor has a base clock speed of 2.0GHz, with an all-core boost speed of 2.55GHz, and a max boost clock speed of 3.0GHz. The L3 cache size is 64MB.

Azure 42

Azure Virtualization Storage Benchmarking 42

KeyCDN

FEBRUARY 22, 2023

Chatbots and virtual assistants Chatbots and virtual assistants are becoming more common on websites and web applications as they provide an efficient and convenient way for users to interact with a business. If you have a large database of user information stored on your servers, consider introducing multi-factor identification.

Artificial Intelligence 111

Artificial Intelligence Development Serverless Website 111

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 78

Virtualization Speed Database Efficiency 78

Dynatrace

AUGUST 5, 2022

In a distributed processing environment, message queuing is similar, although the speed and volume of messages are much greater. Consumers store messages in a queue — usually in a buffer or on a storage medium — until they can process and delete them. Queued messages are typically small and specific.

Monitoring 196

Monitoring Serverless Programming Speed 196

Dynatrace

AUGUST 5, 2022

In a distributed processing environment, message queuing is similar, although the speed and volume of messages are much greater. Consumers store messages in a queue — usually in a buffer or on a storage medium — until they can process and delete them. Queued messages are typically small and specific.

Monitoring 195

Monitoring Serverless Programming Speed 195

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. Configuring storage in Kubernetes is more complex than using a file system on your host.

Virtualization 160

Virtualization Infrastructure Monitoring Cloud 160

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 216

DevOps Efficiency Monitoring Infrastructure 216

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

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. For storage, FIO is generally used.

Performance 54

Performance Benchmarking Cache Storage 54

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. mongos --configdb <configReplSetName>/<cfg1.example.net:27019>,<cfg2.example.net:27019>,<cfg3.example.net:27019>

Best Practices 73

Best Practices Traffic Database Servers 73

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

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

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

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

All Things Distributed

JULY 19, 2012

With PV virtualization we are seeing between 10,000 and 85,000 IOPS for 4k random writes and with HVM between 9,000 and 75,000. While disk density is still increasing the access speeds are not and as such they will provide good sequential access, however random access is not improving at all. s can be very demanding.

Cloud 129

Cloud Performance AWS Virtualization 129

HammerDB

MAY 5, 2019

Note that the main developer of HammerDB is Intel employee (#IAMINTEL) however HammerDB is a personal open source project and HammerDB has no optimization whatsoever for a database running on any particular architecture. in the directory storage/innobase/ut the following section has UT_RELAX_CPU defined to call the PAUSE instruction on x86.

Testing 48

Testing Tuning Latency Storage 48

VoltDB

JULY 10, 2018

In these scenarios, having the system as a monolithic one inhibits the development team from being able to move forward at speed. But that fully self sufficient nature means that each of these services have their own end-to-end full stack of technology, including database. Problem solved, right? Where does VoltDB come in?

Architecture 40

Architecture Scalability Ecommerce Latency 40

VoltDB

JULY 10, 2018

In these scenarios, having the system as a monolithic one inhibits the development team from being able to move forward at speed. But that fully self sufficient nature means that each of these services have their own end-to-end full stack of technology, including database. Problem solved, right? Where does VoltDB come in?

Architecture 40

Architecture Scalability Ecommerce Latency 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. InnoDB is the storage engine that will deliver the best OLTP throughput and should be chosen for this test. .

Best Practices 40

Best Practices Scalability Performance C++ 40

SQL Performance

AUGUST 27, 2019

Single-Socket Database Servers. Higher memory speed and bandwidth. Better security , with Secure Memory Encryption and Secure Encrypted Virtualization. Because of this, I think they will be a great choice for virtualization hosts and for Storage Spaces Direct nodes. I/O lanes. Higher memory density/capacity.

Servers 52

Servers Benchmarking Virtualization Architecture 52

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. Step 4: Smart Database Migration. Which applications and services are depending on a database that might be impacted by a migration?

Cloud 31

Cloud Traffic Database Network 31

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

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

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. Stable Media Stable media is often confused with physical storage.

Servers 40

Servers Cache Media Hardware 40

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. ‍It 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 40

Open Source DevOps AWS Azure 40

Smashing Magazine

SEPTEMBER 26, 2019

Technically, we have to split our existing application into microservices virtually. By “virtually” I mean that in general, you don’t need to change your existing application physically: it’s enough to have structure settled in any form even if only on paper. So we should dive more in-depth here. Allow Host-to-Alien Access.

Architecture 73

Architecture Virtualization Servers Technology 73

Testsigma

NOVEMBER 16, 2021

This includes the design principles, server communications or data transfers and storage. Even my data is synced over to different platforms quickly which means I am working on the same database for each of my applications. A platform can be online, local, virtual machine, cloud-based setup, hybrid, anything. A platform.

Testing 52

Testing Website Small Business Internet 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