DZone

JANUARY 2, 2025

When we are working with a database, optimization is crucial and key in terms of application performance and efficiency. Below are some of the best practices with coding examples to optimize performance in Azure Cosmos DB. Below are some of the best practices with coding examples to optimize performance in Azure Cosmos DB.

Best Practices 245

Best Practices Azure Performance Efficiency 245

DZone

OCTOBER 21, 2024

In this blog, I'll describe a couple of new performance features that you'll find in Postgres 17 as well as another important logical replication feature that I didn't cover in my earlier blog of this series.

Performance 281

Performance Open Source Google Database 281

Scalegrid

AUGUST 26, 2020

Microsoft Azure is one of the most popular cloud providers in the world, and a natural fit for database hosting on applications leveraging Microsoft across their infrastructure. MySQL is the number one open source database that’s commonly hosted through Azure instances. MySQL Azure Performance Benchmark. Balanced Workloads.

Azure 299

Azure Benchmarking Database Latency 299

Scalegrid

MAY 13, 2020

Greenplum Database is a massively parallel processing (MPP) SQL database that is built and based on PostgreSQL. Greenplum Database is an open-source , hardware-agnostic MPP database for analytics, based on PostgreSQL and developed by Pivotal who was later acquired by VMware. What is an MPP Database?

Big Data 321

Big Data Database Artificial Intelligence Open Source 321

DZone

JULY 10, 2023

In today's fast-paced digital landscape, performance optimization plays a pivotal role in ensuring the success of applications that rely on the integration of APIs and databases. Efficient and responsive API and database integration is vital for achieving high-performing applications.

Database 250

Database Strategy Performance Scalability 250

DZone

SEPTEMBER 16, 2024

As applications grow in complexity and user base, the demands on their underlying databases increase significantly. Efficient database scaling becomes crucial to maintain performance, ensure reliability, and manage large volumes of data. This cheatsheet provides an overview of essential techniques for database scaling.

Strategy 263

Strategy Database Scalability Performance 263

DZone

FEBRUARY 4, 2025

Understanding Teradata Data Distribution and Performance Optimization Teradata performance optimization and database tuning are crucial for modern enterprise data warehouses.

Performance 173

Performance Tuning Analytics Strategy 173

DZone

NOVEMBER 15, 2023

These are measurements of search speed by key and data types for the key on the database side. I will use a PostgreSQL database and a demo Java service to compare query speeds. In this article, I want to share my knowledge and opinion about the data types that are often used as an identifier. Today we will touch on two topics at once.

Database 298

Database Java Performance Speed 298

Scalegrid

APRIL 28, 2020

If you’re hosting your databases in the cloud, choosing the right cloud service provider is a significant decision to make for your long-term hosting costs. Over the last few weeks, we have been inundated with requests from SMB customers looking to improve the ROI on their database hosting. MongoDB® Database. EC2 instances.

Azure 344

Azure AWS Database Latency 344

DZone

AUGUST 28, 2024

Teams often consider external caches when the existing database cannot meet the required service-level agreement (SLA). This is a clear performance-oriented decision. However, external caches are not as simple as they are often made out to be.

Cache 278

Cache Database Latency Traffic 278

Dynatrace

FEBRUARY 1, 2024

Maintaining optimal application performance is crucial for businesses, and fast databases are vital in achieving this goal. For an effective approach to database performance, it’s crucial to have a comprehensive overview of all databases, including server-side DBs.

Database 246

Database Monitoring Games Metrics 246

Dynatrace

NOVEMBER 1, 2021

As cloud applications have become the norm, the databases that power these applications are now typically run as managed services by cloud providers. Optimize database performance. Small changes in a database can have an enormous impact on overall application performance. One place to rule them all.

Azure 246

Azure Database Performance Monitoring 246

DZone

OCTOBER 2, 2024

In this article, we’ll dive deep into the concept of database sharding, a critical technique for scaling databases to handle large volumes of data and high levels of traffic. We’ll start by defining what sharding is and why it’s essential for modern, high-performance databases.

Database 279

Database Systems Scalability Traffic 279

Dynatrace

FEBRUARY 27, 2025

Top takeaways: Key OpenTelemetry trends in 2025 Semantic Conventions ensure alignment: Semantic Conventions provide consistent telemetry data interpretation, correlation, and automation, with HTTP spans now stable and other domains like databases and messaging nearing stabilization. OpenTelemetry Collector 1.0

Tuning 310

Tuning Open Source Innovation Monitoring 310

Dynatrace

SEPTEMBER 5, 2023

Running Databases efficiently is crucial for business success Monitoring databases is essential in large IT environments to prevent potential issues from becoming major problems that result in data loss or downtime. However, horizontal scaling of these databases can take time and effort.

Database 246

Database Metrics Monitoring Servers 246

DZone

NOVEMBER 25, 2023

We often dwell on the technical aspects of database selection, focusing on performance metrics , storage capacity, and querying capabilities. Yet, the impact of choosing the right NoSQL database goes beyond these parameters; it affects your business outcomes.

Database 278

Database Latency Speed Metrics 278

Dynatrace

APRIL 21, 2022

While applications are built using a variety of technologies and frameworks, there is one thing they usually have in common: the data they work with must be stored in databases. Now, Dynatrace has gone a step further and expanded its coverage and intelligent observability into the next layer: database infrastructure.

Database 246

Database DevOps Analytics Servers 246

Dynatrace

SEPTEMBER 8, 2023

In part 2, we’ll show you how to retrieve business data from a database, analyze that data using dashboards and ad hoc queries, and then use a Davis analyzer to predict metric behavior and detect behavioral anomalies. Similar to the tutorial extension, we created an extension that performs queries against databases.

Database 290

Database Artificial Intelligence Metrics Monitoring 290

DZone

SEPTEMBER 28, 2023

Previously, our application was using one database; developers knew how it worked, and the deployment rarely happened. A single database administrator was capable of maintaining the database, optimizing the queries, and making sure things worked as expected. Fifteen years later, everything is different.

Database 288

Database Software Engineering Software Software 288

DZone

FEBRUARY 27, 2024

Understanding the structures within a Relational Database Management System (RDBMS) is critical to optimizing performance and managing data effectively. Here's a breakdown of the concepts with examples. RDBMS Structures 1.

Database 264

Database Tuning Systems Performance 264

DZone

OCTOBER 30, 2024

Log-Structured Merge Trees (LSM trees) are a powerful data structure widely used in modern databases to efficiently handle write-heavy workloads. They offer significant performance benefits through batching writes and optimizing reads with sorted data structures.

Strategy 244

Strategy Storage Efficiency Database 244

DZone

JUNE 28, 2023

Database sharding is a powerful technique employed to manage large databases more effectively. It involves partitioning a large database into smaller, more manageable parts, known as shards. The above diagram presents a visual representation of a sharded database.

Database 232

Database Scalability Servers Performance 232

Dynatrace

DECEMBER 9, 2020

If you’re running SAP, you’re likely already familiar with the HANA relational database management system. However, if you’re an operations engineer who’s been tasked with migrating to HANA from a legacy database system, you’ll need to get up to speed quickly. Avoid false positives with auto-adaptive baselining.

Infrastructure 246

Infrastructure Database Monitoring Metrics 246

Scalegrid

MARCH 10, 2025

A graphical user interface (GUI) helps simplify how you interact with your MySQL databases. Whether youre a developer, database administrator, or data analyst, a good GUI can make everyday tasks faster, clearer, and less error-prone. Thats where MySQL GUIs come in.

Open Source 162

Open Source Database Design Cloud 162

DZone

JUNE 28, 2023

When database problems arise, they can disrupt even the most well-crafted applications. That's why knowing how to debug mobile app database problems and optimize data storage performance is essential for developers seeking excellence. These are signs of database challenges. These are signs of database challenges.

Storage 203

Storage Mobile Database Performance 203

Dynatrace

AUGUST 10, 2023

There are also many cases where business data—transactional, inventory, or financial—is at rest or in use , stored in a database. Dynatrace extensions can easily query data from various databases and store the results in Grail™, the Dynatrace data lakehouse. This can be accomplished using Dynatrace extensions.

Database 246

Database Metrics Retail Analytics 246

DZone

OCTOBER 23, 2023

NoSQL databases emerge as ideal candidates to meet these requirements, and cloud platforms such as AWS offer managed and highly resilient data ecosystems. In this article, I am not going to determine which AWS NoSQL database is better: the concept of a better database only exists within a specific purposeful context.

AWS 275

AWS Performance Database Architecture 275

DZone

APRIL 15, 2022

Recently, I faced an issue related to a very high load on the database layer. The database was having too many connections in parallel. I had to review my application’s database connection pool (DBCP) properties very closely.

Database 245

Database Code Big Data Performance 245

DZone

JULY 6, 2023

Azure Cosmos DB is a highly scalable and globally distributed NoSQL database service offered by Microsoft. To ensure optimal performance and scalability of applications running on Cosmos DB, it's crucial to employ effective performance optimization techniques. The same is the case with Cosmos DB as well.

Azure 264

Azure Performance Best Practices Strategy 264

Dynatrace

SEPTEMBER 15, 2020

In my recent Performance Clinic with Stefano Doni , CTO & Co-Founder of Akamas , I made the statement, “Application development and release cycles today are measured in days, instead of months. Increase in environment complexity and increased frequency in delivery requires a novel approach to performance optimization.

Performance 260

Performance Java Metrics Cloud 260

Scalegrid

OCTOBER 18, 2024

Due to its versatility for storing information in both structured and unstructured formats, PostgreSQL is the fourth most used standard in modern database management systems (DBMS) worldwide 1. To conclude, GUIs are a vital addition to ease the lives of database users and developers.

Open Source 147

Open Source Database Cloud Operating System 147

DZone

APRIL 19, 2023

In this article, I will explain how we can move the system databases to different locations in Ubuntu Linux. SQL Server on Linux does not have SQL Server Configuration Manager, so we will use the mssql-config commands to perform administrative tasks. Please note that the operations which we are performing require elevated permissions.

Servers 246

Servers Database Systems Operating System 246

Dynatrace

MAY 28, 2020

In this blog, I will be going through a step-by-step guide on how to automate SRE-driven performance engineering. Step-by-step guide: SRE-driven performance analysis with Dynatrace. Please note – there is no need to restart your database servers. Dynatrace news. This is what this blog is all about.

Engineering 270

Engineering Performance Metrics Best Practices 270

Dynatrace

APRIL 10, 2023

Managing cloud performance is increasingly challenging for organizations that spread workloads across a greater variety of platforms. Moreover, organizations have to balance maintaining security, retaining cloud management expertise, and managing infrastructure performance. Rural lifestyle retail giant Tractor Supply Co.

Cloud 243

Cloud Ecommerce Performance Retail 243

DZone

JUNE 13, 2024

Relational Databases are the bedrock of any FinTech application, especially for OLTP (Online transaction Processing). So, it is imperative that all database activities are monitored closely in the production environment and issues like long-running queries are tracked and resolved.

FinTech 262

FinTech Tuning AWS Database 262

Speed Curve

JANUARY 19, 2025

Let's kick off the new year by celebrating someone who has not just had a huge impact on web performance over the past few years, but who has even more exciting stuff in the works for the future: Annie Sullivan! Annie and her team navigate this arduous task with true passion for web performance and for improving the user experience.

Performance 98

Performance Google Speed Metrics 98

DZone

AUGUST 21, 2021

This article describes 3 different tricks that I used in dealing with big data sets (order of 10 million records) and that proved to enhance performance dramatically. This trick enhanced the performance dramatically. Trick 1: CLOB Instead of Result Set.

Big Data 246

Big Data Performance Tuning Mobile 246