Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

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.

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.

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.

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.