Percona

OCTOBER 10, 2023

Databases are different from a lot of software. This is not a general rule, but as databases are responsible for a core layer of any IT system – data storage and processing — they require reliability. Why choose Percona Server for MongoDB? Why release Percona Server for MongoDB 7 now?

Availability 102

Availability Servers Database Open Source 102

Scalegrid

NOVEMBER 12, 2019

PostgreSQL is an amazing relational database. However, beyond just the features, there are other important aspects of a database that need to be considered. However, beyond just the features, there are other important aspects of a database that need to be considered. Why not have this built it into the server?

Database 184

Database Open Source Servers Storage 184

Percona

MAY 1, 2023

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. What is PostgreSQL performance tuning? Why is PostgreSQL performance tuning important?

Tuning 52

Tuning Efficiency Database Performance 52

Percona

SEPTEMBER 28, 2023

Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. This can negatively impact performance and cause delays.

Servers 114

Servers Best Practices Database Open Source 114

SQL Shack

APRIL 7, 2021

This article will explore the process to capture deadlock XML and deadlock graphs for AWS RDS SQL Server databases. Introduction As a database professional, you confront the performance issues with databases. It is essential to […].

AWS 74

AWS Database Servers Processing 74

SQL Shack

APRIL 19, 2021

In this article, we’ll show a process for SQL Server performance tuning, and several tools, tips and techniques you can use to monitor performance and take the necessary steps to improve it. SQL Server is a common platform for enterprise-grade database workloads.

Tuning 70

Tuning Servers Performance Database 70

SQL Shack

SEPTEMBER 29, 2020

In this article, we will learn the Delayed Durability feature that helps to improve transaction log file write throughput in SQL Server. OLTP (Online Transaction Processing) databases should process a huge number of transactions within the shortest time and concurrently.

Servers 98

Servers Performance Database Processing 98

Dynatrace

OCTOBER 23, 2023

Secondly, determining the correct allocation of resources (CPU, memory, storage) to each virtual machine to ensure optimal performance without over-provisioning can be difficult. This presents a challenge for IT operations teams, specifically in identifying and addressing performance issues or planning how to prevent future issues.

Efficiency 209

Efficiency Virtualization Hardware Performance 209

DZone

NOVEMBER 2, 2023

When a user logs on to this desktop/laptop or mobile, opens a browser, and types the name of a website, the browser displays the required information, and the user performs an action on the site. It’s an underlying web application architecture that makes this process possible.

Architecture 267

Architecture Mobile Website Servers 267

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

Performance 106

Performance Monitoring Traffic Database 106

Percona

APRIL 14, 2023

Below, we outline some proactive steps for achieving cost efficiency and maintaining performant database environments amid a turbulent economy: 1. Here are a few ways you can scale down and save: Audit your systems: Auditing your system for unused servers and eliminating those servers can reduce your cloud spend.

Database 84

Database Serverless Tuning Cloud 84

Percona

DECEMBER 15, 2022

JSON data and relational databases have traditionally been diametric opposites. So many folks were surprised when relational databases started adding a JSON data type to their products. In this multi-part blog series, we will start with an overview of using JSON in a relational database. JSON is popular. Very popular.

Database 91

Database Servers Processing Efficiency 91

SQL Shack

OCTOBER 14, 2021

Transparent Data Encryption (TDE) encrypts database files to secure your data. It also encrypts the tempdb database to secure your data in a temporary space. The process of encryption and decryption adds additional overhead to the database system.

Servers 79

Servers Performance Database Processing 79

Percona

JANUARY 25, 2023

Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users.

Database 99

Database C++ Servers Open Source 99

Percona

APRIL 3, 2024

One of the most common tasks for database administrators is checking logs; you can either work directly with the file or process it using another tool. Either way, regularly checking the logs remains essential.

Processing 78

Processing Database Servers Performance 78

Scalegrid

DECEMBER 9, 2019

However, discarding a server like this is expensive and inefficient. In this blog post, we will explain an approach to detect and fix transactions on the crashed MySQL master server in a semisynchronous replication setup, and how to re-slave it back into your master-slave setup. Default database: 'test'. Want to give it a try?

Servers 160

Servers Database Processing Availability 160

Percona

JANUARY 17, 2023

The definition of Percona Advisors by ChatGPT is the following: Percona Advisors can help organizations implement robust security measures to protect their databases and sensitive data. The process of registering PMM in the Platform is described in the documentation. Day-2 operations for databases are complex. Try PMM Now.

Database 106

Database Open Source Monitoring Innovation 106

Dynatrace

DECEMBER 9, 2020

Most applications communicate with databases to, for example, pull a catalog entry or submit a new record when an order is placed. To achieve this, there must be a healthy connection between the application and the database. Application servers use connection pools to maintain connections with the databases that they communicate with.

Traffic 137

Traffic Performance Database Metrics 137

Smashing Magazine

OCTOBER 29, 2018

Measuring Performance With Server Timing. Measuring Performance With Server Timing. When undertaking any sort of performance optimisation work, one of the very first things we learn is that before you can improve performance you must first measure it. Browsers now even have performance audits built right in.

Servers 88

Servers Performance Metrics Database 88

SQL Shack

OCTOBER 4, 2021

This article explores the MSDB SQL Database maintenance and cleanup process essential for every DBA. Introduction SQL Server system database – MSDB stores SQL Server agent jobs, History, schedules, database mail, service broker, backup, and restore History.

Database 97

Database Servers Processing Systems 97

Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. You might already use ScaleGrid hosting for Redis hosting to power your performance-sensitive applications.

Metrics 130

Metrics Monitoring Latency Cache 130

Scalegrid

JANUARY 19, 2024

Key Takeaways Rollbacks in MongoDB are triggered by disruptions in the replication process due to primary node crashes, network partitions, or other failures, which can lead to substantial data loss and inconsistencies. With direct, actionable insights, prepare to navigate the complexities of rollbacks with confidence.

Database 130

Database Network Servers Monitoring 130

Dynatrace

AUGUST 8, 2024

It’s also critical to have a strategy in place to address these outages, including both documented remediation processes and an observability platform to help you proactively identify and resolve issues to minimize customer and business impact. These attacks can be orchestrated by hackers, cybercriminals, or even state actors.

Software 242

Software Software Infrastructure Network 242

Scalegrid

DECEMBER 14, 2023

How the MongoDB timeout is set up can significantly affect your application’s performance, no matter if you are an experienced MongoDB user or just starting with NoSQL databases. Typical applications are interacting with different database servers based on the business logic.

Java 130

Java Network Servers Database 130

Percona

JULY 31, 2023

Open source database architects usually do not implement business logic in their databases. This is in stark contrast to many commercial databases where this is a common practice. In the first case, all the heuristics are kept at the application layer, and the database has little or no effect on the data quality.

Database 77

Database Open Source Servers Code 77

Dynatrace

MAY 27, 2022

At Dynatrace Perform 2022 , David Walker, a Lockheed Martin Fellow, and William Swofford, a full-stack engineer at Lockheed Martin, discuss how to create a self-diagnosing and self-healing IT server environment using this AIOps combination for auto-baselining, auto-remediation, monitoring as code, and more.

Artificial Intelligence 182

Artificial Intelligence Innovation Servers Database 182

HammerDB

OCTOBER 23, 2023

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. However, there can be a lack of understanding of the benefits that stored procedures bring or if you have a benchmarking tool or database that doesn’t support stored procedures, then you have nothing to compare against.

Benchmarking 62

Benchmarking Database Network C++ 62

SQL Shack

APRIL 5, 2021

This article intends to give some details about the query optimization process in SQL Server. Introduction The query optimization is very grinding work for the database professionals who desire to overcome performance issues of the queries. In this context, understanding […].

Servers 97

Servers Database Processing Performance 97

Smashing Magazine

SEPTEMBER 28, 2022

Five Data-Loading Patterns To Improve Frontend Performance. Five Data-Loading Patterns To Improve Frontend Performance. When it comes to performance, you shouldn’t be stingy. Every unnecessary bit of JavaScript code you bundle and serve will be more code the client has to load and process. Agustinus Theodorus.

Cache 127

Cache Performance Servers Architecture 127

Scalegrid

AUGUST 22, 2019

It enables users to perform any maintenance actions by providing pause/resume functionality. On the first node, Patroni initializes the database, obtains the leader lock from DCS, and ensures the node is being run as the master. Standby Server Tests. Kill the PostgreSQL process. Stop the PostgreSQL process.

Availability 277

Availability Servers Network Open Source 277

SQL Performance

APRIL 15, 2020

SQL Server has always provided the ability to capture actual queries in an easily-consumable rowset format – first with legacy SQL Server Profiler, later via Extended Events, and now with a combination of those two concepts in Azure SQL Database. Enter the New SQL Server Profiler. Legacy Profiler "Standard" trace events.

Azure 96

Azure Database Tuning Network 96

SQL Shack

DECEMBER 10, 2020

The SQL Server execution plan (query plan) is a set of instructions that describes which process steps are performed while a query is executed by the database engine. The query plans are generated by the query optimizer and its essential goal is to generate the most efficient (optimum) and economical query plan.

Servers 109

Servers Efficiency Database Engineering 109

Dynatrace

SEPTEMBER 5, 2024

Native support for Syslog messages Syslog messages are generated by default in Linux and Unix operating systems, security devices, network devices, and applications such as web servers and databases. A key advantage of this integration is its high throughput aligned with Grail, ensuring optimal performance.

Innovation 256

Innovation AWS Analytics Storage 256

Scalegrid

JUNE 21, 2024

outlines this progression for MongoDB Server and MongoDB Enterprise from initial release to retirement. MongoDB Server Lifecycle Schedule Release Release Date End of Life Date MongoDB 2.6 Aug-23 Aug-26 MongoDB provides documentation and support to assist users through the upgrade process. MongoDB Inc. Apr-14 Oct-18 MongoDB 3.0

Database 130

Database Efficiency Strategy Tuning 130

Speed Curve

FEBRUARY 5, 2024

That performance golden rule still holds true today. Server-timing headers are a key tool in understanding what's happening within that black box of Time to First Byte (TTFB). Cue server-timing headers Historically, when looking at page speed, we've had the tendency to ignore TTFB when trying to optimize the user experience.

Servers 57

Servers Cache Retail Benchmarking 57

Scalegrid

NOVEMBER 29, 2023

In today’s rapidly evolving digital landscape, the way we manage databases is undergoing a transformative shift. The rise of Database-as-a-Service (DBaaS) is not just a trend but a strategic response to the growing complexities of data management. However, using a database as a service is not without its set of challenges.

Healthcare 130

Healthcare Hardware Database Scalability 130

Scalegrid

NOVEMBER 23, 2023

Imagine a world where your PostgreSQL® database connections are seamless and secure. Key Takeaways Understanding PostgreSQL hostname is essential for successful database connections. Configure the PostgreSQL hostname by editing configuration files and restarting the server, with secure storage of connection details to enhance security.

Database 130

Database Servers Storage Network 130