Scalegrid

JANUARY 12, 2024

Simply put, it’s the set of computational tasks that cloud systems perform, such as hosting databases, enabling collaboration tools, or running compute-intensive algorithms. Such demanding use cases place a great value on systems capable of fast and reliable execution, a need that spans across various industry segments.

Cloud 130

Cloud Virtualization Storage Efficiency 130

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

Dotcom-Montior

NOVEMBER 24, 2021

Web developers or administrators did not have to worry or even consider the complexity of distributed systems of today. Do you have a database? Do you have a web server? Great, your system was ready to be deployed. Was the database running? Is the web server running? Is the web server running?

Systems 74

Systems Monitoring Hardware Network 74

Dynatrace

JANUARY 26, 2021

Traditional computing models rely on virtual or physical machines, where each instance includes a complete operating system, CPU cycles, and memory. VMware commercialized the idea of virtual machines, and cloud providers embraced the same concept with services like Amazon EC2, Google Compute, and Azure virtual machines.

Serverless 245

Serverless Efficiency Lambda Azure 245

Dynatrace

NOVEMBER 2, 2020

IT infrastructure is the heart of your digital business and connects every area – physical and virtual servers, storage, databases, networks, cloud services. AI-assistance: Use AI to detect anomalies and benchmark your system. We’ve seen the IT infrastructure landscape evolve rapidly over the past few years.

Infrastructure 209

Infrastructure Monitoring Virtualization Serverless 209

Scalegrid

APRIL 16, 2020

Where you decide to host your cloud databases is a huge decision. But, if you’re considering leveraging a managed databases provider, you have another decision to make – are you able to host in your own cloud account or are you required to host through your managed service provider? Where to host your cloud database?

Cloud 242

Cloud Azure AWS Database 242

Brendan Gregg

NOVEMBER 29, 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 111

Virtualization AWS Hardware Storage 111

Scalegrid

OCTOBER 17, 2019

In that environment, the first PostgreSQL developers decided forking a process for each connection to the database is the safest choice. It would be a shame if your database crashed, after all. On modern Linux systems, the difference in overhead between forking a process and creating a thread is much lesser than it used to be.

Architecture 200

Architecture Database Latency Servers 200

HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98

Dynatrace

JULY 7, 2022

Monolithic software systems employ one large codebase, which includes collections of tools, software development kits, and associated development dependencies. Because monolithic software systems employ one large codebase repository, the service becomes a massive piece of software that is labor-intensive to manage.

Architecture 209

Architecture Serverless Azure Programming 209

Scalegrid

JUNE 6, 2019

June 6, 2019 – ScaleGrid , the Database-as-a-Service (DBaaS) leader in the SQL and NoSQL space, has announced the expansion of their fully managed MySQL Hosting services to support Amazon Web Services (AWS) cloud. PALO ALTO, Calif.,

AWS 191

AWS Cloud Open Source Virtualization 191

Scalegrid

JANUARY 8, 2024

AI-driven cloud solutions like ScaleGrid offer a diverse range of database hosting options, robust infrastructure optimized for scalability and security, and enable significant cost reductions, supporting businesses in efficient growth and improved ROI. These services are tailored to meet various business requirements.

Artificial Intelligence 147

Artificial Intelligence Cloud Scalability Analytics 147

Percona

AUGUST 22, 2023

Estimates vary, but most reports put the average cost of unplanned database downtime at approximately $300,000 to $500,000 per hour, or $5,000 to $8,000 per minute. With so much at stake, database high availability and fault tolerance have become must-have items, but many companies just aren’t certain which one they must have.

Availability 79

Availability Hardware Open Source Database 79

Percona

OCTOBER 3, 2023

Transparent Huge Pages (THP) is a memory management feature in Linux operating systems that aims to enhance system performance. While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. The value that appears between square brackets is the current value.

Database 88

Database Servers Open Source C++ 88

Dynatrace

NOVEMBER 23, 2020

Nevertheless, there are related components and processes, for example, virtualization infrastructure and storage systems (see image below), that can lead to problems in your Kubernetes infrastructure. Configuring storage in Kubernetes is more complex than using a file system on your host. Kelsey Hightower via Twitter, 2020).

Virtualization 163

Virtualization Infrastructure Monitoring Cloud 163

Dynatrace

MAY 8, 2023

The process involves monitoring various components of the software delivery pipeline, including applications, infrastructure, networks, and databases. In addition, monitoring DevOps processes provide the following benefits: Improve system performance. Help systems meet SLAs. Increase system uptime. Lost efficiency.

DevOps 228

DevOps Efficiency Monitoring Infrastructure 228

Dynatrace

JANUARY 19, 2020

SAP estimates that 80% of all worldwide business transactions touch SAP systems in some form. As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. The Dynatrace ActiveGate extension queries SAP servers for key performance counters. Why SAP ABAP platform monitoring in Dynatrace?

Monitoring 155

Monitoring Best Practices Infrastructure Servers 155

Dynatrace

APRIL 15, 2022

Organizations hit this cloud operations wall when replacing static virtual machines with dynamic container orchestration and expanding to multicloud environments. The agency executed one of the largest email migrations from on-premises Exchange servers to Microsoft Office 365 — moving almost 480,000 mailboxes to the cloud.

Cloud 185

Cloud Infrastructure Innovation Monitoring 185

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. “Be The Back Story.

Servers 90

Servers Media Cache Storage 90

Scalegrid

JANUARY 17, 2019

For our MongoDB Bring Your Own Cloud (BYOC) AWS deployments that are not open to the internet, this may mean selecting an instance that is allowed to connect to the Security Group and also has VPN connectivity to the Virtual Private Cloud (VPC). Database Specific Users. Server Name : SG-example-1234.servers.mongodirector.com.

Database 178

Database Servers Open Source AWS 178

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

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 84

Availability Open Source Architecture Database 84

Scalegrid

JULY 29, 2020

PgBouncer defines one pool per user+database combination. A client benefits from a pooled connection only if it connects to a child which has previously served a connection for this database+user combination. PgBouncer allows limiting connections per-pool, per-database, per-user or per-client. When are connections reused?

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

Percona

JUNE 2, 2023

While not the first open source content management system (CMS), WordPress caught on like nothing before and helped spread open source to millions. MySQL was the database for phpWebLog, for example, way back in 2000. The project signaled intent to support other databases as early as the 0.7.1 or later or MariaDB 10.3

Open Source 95

Open Source Traffic Tuning Database 95

Percona

JUNE 12, 2023

When it comes to access to their applications, users demand instant, reliable, and secure interactions — and that means databases must be highly available. With database high availability (HA), services are largely uninterrupted, and end users are largely satisfied. The obvious answer is this: To achieve high availability.

Architecture 96

Architecture Availability Open Source Healthcare 96

Percona

MARCH 17, 2023

These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.

Monitoring 99

Monitoring Scalability Cache Database 99

Dynatrace

MAY 31, 2019

SAP estimates that 80% of all worldwide business transactions touch SAP systems in some form. As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. The Dynatrace ActiveGate extension queries SAP servers for key performance counters. Why SAP ABAP platform monitoring in Dynatrace?

Monitoring 161

Monitoring Best Practices Programming Infrastructure 161

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 Hosting on Azure for Redis™ 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 100

Azure Availability Open Source Virtualization 100

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

APRIL 7, 2023

If we were to select the most important MySQL setting, if we were given a freshly installed MySQL or Percona Server for MySQL and could only tune a single MySQL variable, which one would it be? Sysbench ran on a third server, which I’ll refer to as the application server (APP).

Tuning 136

Tuning Cache Servers Benchmarking 136

Dynatrace

APRIL 5, 2021

Similar to AWS Lambda , Azure Functions is a serverless compute service by Microsoft that can run code in response to predetermined events or conditions (triggers), such as an order arriving on an IoT system, or a specific queue receiving a new message. Consider using virtual machines or specialized frameworks for these types of tasks.

Azure 138

Azure Serverless IoT Lambda 138

HammerDB

APRIL 27, 2021

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. In this example we are using SQL Server so the message shows that everything is in order and we can proceed with running tests. Selecting a database. Select a database.

Virtualization 73

Virtualization Benchmarking Database Operating System 73

Percona

NOVEMBER 2, 2023

Following the series of blogs started by Peter Zaitsev in Installing MySQL with Docker , on deploying Docker containers running open source databases, in this article, I’ll demonstrate how to install and run PostgreSQL using Docker. This blog was originally published in Sept 2021 and was updated in November 2023.

Database 70

Database Open Source Scalability Virtualization 70

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. Another benefit is cost savings associated with server and data center setup and maintenance.

Artificial Intelligence 111

Artificial Intelligence Development Serverless Website 111

Particular Software

JULY 18, 2017

I remember the first time I deployed a system into production. We built a custom content management website backed by a single SQL Server database. It was a typical two-tier application with a web application and a database. Yes/No) Is my web server up? (Yes/No) Yes/No) Is my web server up?

Systems 56

Systems Monitoring Website Virtualization 56

SQL Performance

AUGUST 2, 2019

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. I have SQL Server 2019 CTP 3.2 Now that 2019 CTP 3.2

Servers 95

Servers C++ Testing Systems 95

HammerDB

FEBRUARY 26, 2024

Many of the HammerDB TPROC-C workloads have included features to prevent the database doing maintenance tasks for the previous run whilst another run is taking place. This is particularly important when running automated workloads back-back to generate a performance profile for a progressively increasing number of virtual users.

C++ 62

C++ Cache Database Virtualization 62