Operations | Monitoring | ITSM | DevOps | Cloud

February 2023

How to Monitor Redis with Prometheus

The current popularity of Redis is well deserved; it’s one of the best caching engines available and it addresses numerous use cases – including distributed locking, geospatial indexing, rate limiting, and more. Redis is so widely used today that many major cloud providers, including The Big 3 — offer it as one of their managed services. In this article, we’ll look at how to monitor Redis performance using Prometheus, the similarly popular open-source monitoring system.

The business value of frequent deployments: Faster time to market

In this series, we’ve been exploring the different layers of business value you can gain from deploying software more frequently. We’ve already looked at the hard costs you can save, and the valuable developer time you can recoup. But that’s not the end of the story. Not by far. Picture an iceberg. The top, the visible part, is those hard costs. Just beneath the surface is that time that can be gained by redeploying wasted time to projects that matter.

How Database Observability Increases Operational Reliability

Early on in my career as a DBA, I began to realize I wasn’t a Database Administrator as much as the Default Blame Acceptor for nearly any application problem. Let’s face it—the first thing blamed when there’s an issue is typically going to be the database, and it’s a “guilty until proven otherwise” situation.

Monitor any SQL metrics with Netdata (and Pandas )

We recently got this great feedback from a dear user in our Discord: This is great and exactly what we want, a clear problem or improvement we could make to help make that users monitoring life a little easier. This is also where the beauty of open source comes in and being able to build on the shoulders of giants - adding such a feature turned out to be pretty easy by just extending our existing Pandas collector to support SQL queries leveraging its read_sql() capabilities.

Next Level Oracle Monitoring Options Features DeepDive NiCE 2023Q1

Next Level Oracle Monitoring | Options, Features, Deep-Dive Performance, availability, and Oracle observability are the hot topics for the next decade. Get a guided tour on advanced Oracle monitoring based on Microsoft System Center Operations Manager, run by the NiCE Product Experts. The NiCE Oracle Management Pack, in conjunction with one of the big players in IT Operations Management, easily enables end-to-end Oracle observability and thus helps reduce risk and downtime.

Optimize SQL Server performance with Datadog Database Monitoring

Microsoft SQL Server is a popular relational database management system that provides a wide range of performance and reliability features (e.g., AlwaysOn availability groups) to support business-critical applications. As your SQL Server workloads scale and increase in complexity, it can be difficult to monitor all of their components and pinpoint the exact issues that are degrading your databases’ performance.

What Is SQL Performance Tuning?

As database administrators and developers, we need to know how to tune SQL queries and databases. Tuning SQL queries and databases is one of the most powerful tools in our arsenal for achieving the best possible performance results. This post will help you understand more about SQL tuning. I’ll start by explaining what SQL performance tuning is. Then, I’ll go over how to conduct SQL performance tuning in MySQL, Microsoft SQL Server, and Oracle.

VictoriaMetrics Long-Term Support (LTS): Commitment, Current and Next LTS Versions

Share: VictoriaMetrics is always improving, with frequent updates adding new features, performance improvements and bug fixes listed at the CHANGELOG page. We usually make at least a single release every month. All the new features and bug fixes go to the latest release. That’s why we recommend periodically upgrading VictoriaMetrics components to the latest available release. But the latest release may also contain bugs in the latest features.

Best Practices for MongoDB Monitoring with Prometheus

The MongoDB document-oriented database is one of the most popular database tools available today. Developed as an open-source project, MongoDB is highly scalable and can be set up in your environment in just a few simple steps. When running and managing databases, monitoring is a key requirement.

Caching Database Queries in SQLAlchemy - Part 1/2

The database is one of the most critical components here at Rollbar and its performance ripples across most of our SLOs. One of our goals last months has been to remove unnecessary or repetitive load from it as much as possible. Caching queries is the 101 solution whenever you need to keep scaling up while maintaining, or even reducing, database costs (very relevant these days). Here’s an example of how just one query has been drastically reduced thanks to caching.

What are the biggest challenges organizations face in their digital transformation efforts?

As part of a recent Redgate Summit which focused on digital transformation and data modernization, I was fortunate enough to be able to interview Pramod Sadalage, a Director at Thoughtworks. There, and I’m quoting here, he enjoys the rare role of bridging the divide between database professionals and application developers.

Redis Metrics: An Introduction

Redis is a widely used in-memory database in the industry. As a consequence of its in-memory database, it can concurrently serve data as a key-value-oriented NoSQL database. Due to the use of in-memory data storage in Redis, you can achieve performance that is challenging with conventional databases. It is crucial to monitor Redis' resource usage since it is an in-memory data store.

How SQL Toolbelt Essentials has proven invaluable at Rev.io

James Phillips, CIO at Rev.IO outlines explains how Redgate's SQL Toolbelt Essentials has proven to be invaluable for the managing the 230 separate databases within their organization. This suite of tools has made their developers lives easier by increasing consistency, reducing errors, and introducing controlled and verified releases.

Enforce Quotas on Data Ingestion with Redis

Recently, a customer brought me a challenging use case: They were looking to enforce quotas on their internal customers, i.e. other teams in the organization. The analytics team provides services such as searching and reporting capabilities to those other teams, which subscribe to the services through a chargeback model. Each team that subscribes is supposed to limit its ingestion of data to a quota: a maximum permitted ingest per 24-hour period.

The business value of frequent deployments: Recouped time

The first post in this series introduced the idea of the different layers of value that your business can gain from frequent deployments and focused on the hard costs you can save. We’re looking at the role the database plays here because it’s the most complicated part of the process and it’s difficult to hit aggressive KPIs and goals when your teams are burdened with process bloat due to mistake-prone, manual work.

Release 1.38.0 - DBENGINE v2, Functions, Events, Notifications, Role Based Access, and much more!

The Netdata team is very excited to introduce you to all the new features and improvements in the new version. HIGHLIGHTS: DBENGINE v2 The new open-source database engine for Netdata Agents, offering huge performance, scalability and stability improvements, with a fraction of memory footprint! FUNCTION: Processes Netdata beyond metrics! We added the ability for runtime functions, that can be implemented by any data collection plugin, to offer unlimited visibility to anything, even not-metrics, that can be valuable while troubleshooting.

What are Azure Tables and what are they used for?

Azure Tables is a NoSQL cloud-based data storage service provided by Microsoft. It allows users to store and retrieve structured data in the cloud, and it is designed to be highly scalable and cost-effective. Azure Tables are used for a variety of purposes, including: In summary, Azure Tables are a cost-effective, highly scalable, and flexible data storage service that is well suited for storing large amounts of structured and semi-structured data.