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.

Azure 96

Azure Database Tuning Network 96

Scalegrid

AUGUST 22, 2019

On the first node, Patroni initializes the database, obtains the leader lock from DCS, and ensures the node is being run as the master. Once your cluster setup is complete, Patroni will actively monitor the cluster and ensure it’s in a healthy state. Standby Server Tests. Reboot the server. Reboot the server.

Availability 277

Availability Servers Network Open Source 277

Dynatrace

AUGUST 18, 2022

Such scans enable teams to detect SQL injection attacks that allow someone to maliciously inject code into a database query. For example, an attacker could exploit a misconfigured firewall rule to gain access to servers on your network. National Vulnerability Database (NVD) lists over 175,000 known vulnerabilities.

Traffic 162

Traffic Java Network DevOps 162

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

Dynatrace

MAY 19, 2022

Organizations have multiple stakeholders and almost always have different teams that set up monitoring, operate systems, and develop new functionality. The monitoring team set up the dashboard, so who owns violations? This refers to the load on your network and servers. A world of misunderstandings. Saturation.

Automotive 267

Automotive Latency Architecture Azure 267

Apica

JANUARY 18, 2023

While most monitoring providers consider the digital transformation to be complete, the majority of established businesses still have key functions that depend on technology from the analog days. You may have thousands of spreadsheets moving data between databases that are virtually invisible to the “latest” monitoring technology.

Monitoring 52

Monitoring Network Architecture Traffic 52

Dynatrace

SEPTEMBER 30, 2021

In case of a spike in traffic, you can automatically spin up more resources, often in a matter of seconds. Likewise, you can scale down when your application experiences decreased traffic. For example, as traffic increases, costs will too. Analyze your resource consumption and traffic patterns. Reduced cost.

Cloud 163

Cloud Traffic Best Practices Strategy 163

The Netflix TechBlog

JUNE 13, 2023

Migrating Critical Traffic At Scale with No Downtime — Part 2 Shyam Gala , Javier Fernandez-Ivern , Anup Rokkam Pratap , Devang Shah Picture yourself enthralled by the latest episode of your beloved Netflix series, delighting in an uninterrupted, high-definition streaming experience. This is where large-scale system migrations come into play.

Traffic 279

Traffic Metrics Systems Strategy 279

Dynatrace

JULY 6, 2020

In addition to providing AI-powered full-stack monitoring capabilities , Dynatrace has long featured broad support for Azure Services and intuitive, native integration with extensions for using OneAgent on Azure. Azure Traffic Manager. Effortlessly optimize Azure database performance. Azure DB for PostgreSQL. Azure HDInsight.

Azure 146

Azure Cloud Big Data Virtualization 146

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

DECEMBER 13, 2023

Error logging is a critical aspect of database administration, providing insights into issues, warnings, and errors that may affect the system’s stability and performance. This is particularly beneficial in high-traffic environments where minimizing log noise is crucial for efficient log analysis.

Database 100

Database Open Source Tuning Traffic 100

Percona

SEPTEMBER 12, 2023

If the changes are not made considering the necessary precautions, you may face unwanted outages on the database that can cause serious problems to your business. Another important fact to consider is that having a metadata lock on a highly concurrent table can cause major locking issues in the database and can cause outages.

Database 92

Database Traffic Open Source Monitoring 92

Dynatrace

SEPTEMBER 17, 2019

Kubernetes (k8s) provides basic monitoring through the Kubernetes API and you can find instructions like Top 9 Open Source Tools for Monitoring Kubernetes as a “do it yourself guide”. End-user monitoring. Dynatrace news. For EKS – Amazon’s Kubernetes Service – you can get a preview of CloudWatch Container Insights.

AWS 127

AWS Monitoring Ecommerce Lambda 127

Dynatrace

SEPTEMBER 7, 2019

Database tracing using Couchbase Node.js TL9 SP9 as well as massive improvements in OneAgent deployment and automatic instrumentation of technologies with deep code monitoring modules. TL9 SP9 as well as massive improvements in OneAgent deployment and automatic instrumentation of technologies with deep code monitoring modules.

Java 101

Java Traffic AWS Monitoring 101

SQL Server According to Bob

JULY 17, 2018

When starting SQL Server on Linux why are there two (2) sqlservr processes? systemctl status mssql-server mssql-server.service – Microsoft SQL Server Database Engine … CGroup: /system.slice/mssql-server.service ??85829 85829 /opt/mssql/bin/sqlservr <——— WATCHDOG | MONITOR ??85844

Servers 40

Servers Processing Software Engineering Traffic 40

Dynatrace

AUGUST 9, 2023

Likewise, operation specialists can prioritize their efforts on monitoring the highest-risk tactics, and executives can better communicate the business risk. First, Dynatrace OneAgent  will automatically monitor and trace our infrastructure and communicate with Dynatrace. It also generates  OpenTelemetry  traces.

Analytics 192

Analytics AWS Strategy Infrastructure 192

High Scalability

JUNE 4, 2019

Leverage this data across your monitoring efforts and integrate with PerfOps’ other tools such as Alerts, Health Monitors and FlexBalancer – a smart approach to load balancing. InMemory.Net provides a Dot Net native in memory database for analysing large amounts of data. Learn more today.

Java 116

Java Metrics Software Engineering Traffic 116

Percona

JANUARY 5, 2023

In this blog, I will share a solution to remove this space and remove rows from tables in a few seconds regardless of the size of a table without causing any additional load on the database using table partitions. The first approach that comes to anyone’s mind for deleting the row is using a DELETE query in SQL. What is partitioning?

Traffic 61

Traffic Engineering Speed Storage 61

Dynatrace

JANUARY 11, 2023

In fact, according to a Dynatrace global survey of 1,300 CIOs , 99% of enterprises utilize a multicloud environment and seven cloud monitoring solutions on average. What is cloud monitoring? Cloud monitoring is a set of solutions and practices used to observe, measure, analyze, and manage the health of cloud-based IT infrastructure.

Cloud 220

Cloud Monitoring Best Practices Infrastructure 220

All Things Distributed

NOVEMBER 26, 2013

and enable you to maintain a nearly up-to-date copy of your master database in a different AWS Region. Cross Region Read Replicas also enable you to serve read traffic for your global customer base from regions that are nearest to them. Amazon RDS offers a monthly uptime percentage SLA of 99.95% per Multi-AZ database instance.

Cloud 145

Cloud AWS Traffic Latency 145

Dynatrace

MAY 8, 2023

With the world’s increased reliance on digital services and the organizational pressure on IT teams to innovate faster, the need for DevOps monitoring tools has grown exponentially. But when and how does DevOps monitoring fit into the process? And how do DevOps monitoring tools help teams achieve DevOps efficiency?

DevOps 216

DevOps Efficiency Monitoring Infrastructure 216

Percona

AUGUST 30, 2023

Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. In this blog, we’ll focus on the elements of database backup and disaster recovery, and we’ll introduce proven solutions for maintaining business continuity, even amid otherwise dire circumstances.

Database 93

Database Hardware Open Source Strategy 93

Dotcom-Montior

NOVEMBER 27, 2018

It helps assess how a site, web application, or API will respond to various traffic, without adding any additional infrastructure. Executing an internal test can tell you how well your application or site handles an increase in traffic, but it will never reflect real-world conditions. Identifying performance bottlenecks.

Performance Testing 40

Performance Testing Strategy Testing Performance 40

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 97

Open Source Database Hardware Strategy 97

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

Percona

DECEMBER 21, 2023

Percona Monitoring and Management (PMM) is a state-of-the-art piece of software that exists in part thanks to great open source projects like VictoriaMetrics, PostgreSQL, and ClickHouse. For this example, the PMM SERVER endpoint will be where the HAProxy frontend is listening, and that’s the one used when registering a new PMM CLIENT.

Availability 106

Availability Monitoring Open Source Traffic 106

Dynatrace

MAY 17, 2023

With that, we could make use of the full set of OpenTelemetry’s features to instrument and monitor our applications in the Dynatrace back end, including traces with spans and metrics. OneAgent is the native telemetry data collector and monitoring solution of Dynatrace. And that’s where Dynatrace OneAgent comes in.

Metrics 168

Metrics Monitoring Database Network 168

Percona

MARCH 7, 2019

I’ll show you how we approached the resolution of a MySQL performance issue and used Percona Monitoring and Management PMM to support troubleshooting. The customer had noticed a linear high CPU usage in one of their MySQL instances and was not able to figure out why as there was no much traffic hitting the app.

C++ 102

C++ Traffic Servers Monitoring 102

Dynatrace

JULY 21, 2020

Dynatrace OneAgent is great for monitoring the full stack. While this will give you a lot of information about the health of these components, sometimes a simple synthetic monitor is sufficient. Third-party synthetic monitors. Visualize your synthetic monitor data. Easy and flexible infrastructure monitoring.

Infrastructure 152

Infrastructure Monitoring Open Source Traffic 152

Percona

MARCH 23, 2023

When it comes to enterprise-level databases, there are several options available in the market, but PostgreSQL stands out as one of the most popular and reliable choices. PostgreSQL is a free and open source object-relational database management system (ORDBMS) that has existed since the mid-1990s.

Database 120

Database Open Source Traffic Small Business 120

Scalegrid

MAY 2, 2019

It comes as no surprise that Python developers commonly leverage MongoDB hosting , the most popular NoSQL database , for their deployments due to its flexible nature and lack of schema requirements. It is also recommended that SSL connections be enabled to encrypt the client-database traffic. Testing Failover Behavior.

Testing 55

Testing Network Database Servers 55

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

Availability 112

Availability Database Open Source Hardware 112

Percona

AUGUST 8, 2023

Or worse yet, sometimes I get questions about regaining normal operations after a traffic increase caused performance destabilization. Unfortunately, this topic is more of an art than a science, given that there is really no foolproof algorithm or approach that can tell you exactly where you might hit a bottleneck with server performance.

Traffic 92

Traffic Cache Monitoring Database 92

Jos

JUNE 2, 2018

When they dug into the data, they found that the reason load times had increased was that they got a lot more traffic from Africa after doing the optimizations. How would you architecture a non-trivial size web project (client, server, databases, caching layer)? How do you scale it through different servers? Aim for that.

Performance 237

Performance Speed Google Media 237

Scalegrid

FEBRUARY 8, 2024

A distributed storage system is foundational in today’s data-driven landscape, ensuring data spread over multiple servers is reliable, accessible, and manageable. These storage nodes collaborate to manage and disseminate the data across numerous servers spanning multiple data centers.

Storage 130

Storage Systems Big Data Azure 130

Dynatrace

SEPTEMBER 29, 2021

A standard Docker container can run anywhere, on a personal computer (for example, PC, Mac, Linux), in the cloud, on local servers, and even on edge devices. This opens the door to auto-scalable applications, which effortlessly matches the demands of rapidly growing and varying user traffic. Built-in monitoring. What is Docker?

Open Source 298

Open Source Traffic DevOps Cloud 298

Percona

FEBRUARY 24, 2023

Let’s take a look at how to get the benefits you need while spending less, based on the recommendations presented by Dani Guzmán Burgos, our Percona Monitoring and Management (PMM) Tech Lead, on this webinar (now available on demand) hosted in November last year. Marked in red in Figure 1 is a server with less than 30% of CPU usage.

Cloud 124

Cloud Serverless AWS Storage 124