Operations | Monitoring | ITSM | DevOps | Cloud

October 2022

NiCE DB2 Management Pack 5.2 released

The database market has seen a tremendous boost over the past years. Although database environments have become much more reliable and performant, there is still good reason to monitor dedicated IBM Db2 on-premise or cloud deployments. The NiCE DB2 Management Pack complements highly advanced availability and performance monitoring based on Microsoft System Center Operations Manager, freeing up valuable admin time while keeping crucial deployments safely up and running.

Redgate upgrades SQL Monitor query tuning capability to help development teams move faster and smarter

As part of its ongoing program to continuously release improvements for its SQL Server performance monitoring tool, Redgate announced today a new feature to ease the problems DBAs and developers face with query tuning and optimization.

Top 3 SQL Recovery & Repair Tools

Data collected by you is a valuable asset, however, mere collection or accumulation of data may not be enough to result in a positive and noticeable change within your firm. According to Forbes, besides collecting data it is critical to make intelligent and appropriate use of data. Data is not supposed to be a visible asset. As such data collection may not be up to the mark, particularly while manually handling the process.

How Do MySQL Indexes Work? An In-Depth Tutorial on Creating Clustered and Secondary Indexes and The Effect on Database Performance

MySQL is the most used database in the world. And as it continues to grow in popularity as an open-source database system for developers, understanding how these indexes work is an important step for database developers and administrators. This tutorial is going to explore clustered indexes and secondary indexes in MySQL. MySQL also has other types of indexes besides the B-tree indexes I’ll be discussing, such as fulltext indexes and hash indexes.

Never too late for database performance monitoring

A reliable database system is necessary in the IT operations of an organization to ensure unhindered delivery of information. This is especially true when it comes to business-critical applications, as disruptions in a database system directly impact the end-user experience, ultimately harming your revenue and reputation. Learn about the difficulties inherent to database systems and how monitoring helps resolve these problems.

A Deep-dive into VictoriaMetrics - The Open Source Time Series Database & Monitoring Solution

This video walks you through the inner workings of VictoriaMetrics: All combined and in a nutshell, VictoriaMetrics boasts: Enjoy the video and let us know if you have any questions via the comments section.

7 types of Redis latency and how to fix it

Redis is designed to be fast. In most cases, it is. However, there are times when Redis may be slow, due to network issues, disk latency, or other factors. When this happens, it is important to be able to detect the slow down and investigate the cause. Latency is the maximum delay between the time a client issues a command and the time the reply to the command is received by the client. Redis has strict requirements on average and worst case latency.

A Simplified Introduction to Azure Database for PostgreSQL Flexible Server

I find it amazing how much opportunity and flexibility cloud environments are creating for organizations of all sizes. I’m seeing more and more companies experimenting with open-source software (OSS) relational database systems, which years ago would’ve been too complicated for the customer to set up. With Azure, you can spin up OSS systems like MySQL or PostgreSQL quickly to determine if the engine fits their needs. If it does, you can continue development on it.

Redis Monitoring: What Metrics Should You Measure to Ensure Performance

Redis is an open-sourced, BSD 3 licensed, highly efficient in-memory data store. It is used widely in the industry because of its incredible performance and ease of use. It can easily be used as a distributed, in-memory key-value store, cache, or message broker. It can hold virtually any data structure, making it highly versatile. Redis was architectured and developed with speed in mind and designed to keep all the data in memory.

Three Years in the Making: Redgate Launches Enterprise Version of Popular Open Source Migrations Tool, Flyway

Redgate Software announced today the launch of Flyway Enterprise, a feature-rich version of Flyway which standardizes and automates database deployments across teams and database technologies, increasing both their frequency and reliability.

Monitor Azure Cosmos DB for PosgreSQL with Datadog

Azure Cosmos DB for PostgreSQL is a fully managed relational database service for PostgreSQL that is powered by the open source Citus extension. With remote query execution and support for JSON-B, geospatial data, rich indexing, and high-performance scale-out, Cosmos DB for PostgreSQL enables users to build applications on single- or multi-node clusters.

What To Know About Microsoft Azure PostgreSQL Hyperscale

As organizations adopt cloud technologies and modernize their applications, the data they generate and ingest often grows exponentially, leaving them with difficult choices for storing and using this data. Customers are beginning to explore moving away from traditional relational database management systems (RDBMS) because of the data volume to be ingested, as these RDBMS often cannot handle workloads.

Why Use a Purpose-Built Time Series Database?

For many workloads, using a time series database is a smart choice that saves time and storage space. Developers and companies have more database choices than ever. Choosing the right database for a project saves time when writing and querying data. As companies work with larger datasets to make increasingly intelligent and automated systems, efficiency is key. For many workloads, using a time series database is a smart choice that saves time and storage space.

Comprehensive Guide on Partitioning and Sharding in Azure Database for PostgreSQL

One of the biggest mistakes I’ve had to repeatedly help companies fix has been poor partitioning design. I’ve seen many database architectures designed in an attempt to make queries faster. While faster queries can be a product of implementing partitioning correctly for a given design, I’ve often seen query response times get much slower from implementing partitioning incorrectly for the database design.

Common SQL Server challenges and how Applications Manager's SQL Performance Monitor helps you overcome them

Database management systems are an essential component of business applications. Over the years, MS SQL has earned its place in the hearts of database administrators (DBAs) as the most trusted relational database management system. It is still the go-to choice for many DBAs as it helps them leverage its extensive capabilities across various dimensions such as security, portability, transaction processing and analytics.

Platform.sh partners with MongoDB to help customers build modern applications faster

Today, we are excited to announce that Platform.sh now offers the latest version of MongoDB to our Enterprise and Elite customers. Clients can now enjoy improved visibility via one source of control, the ability to track multiple applications and users, and native, at-rest encryption that meets the latest security compliance standards. There are more details about the benefits of MongoDB below.

How to monitor Oracle DB with Google Cloud Platform

Monitor Oracle DB in Google Cloud Platform with the Google Ops Agent. The Ops Agent is available on GitHub, and makes it easy to collect and ship telemetry from dozens of sources directly to your Google Cloud Platform. You can check it out here! Below are steps to get up and running quickly with observIQ’s Google Cloud Platform integrations, and monitor metrics and logs from Oracle DB in your Google Cloud Platform.

RDS Pricing Explained: A 2022 Beginner-Friendly Guide

The Amazon Relational Database Service (RDS) enables Amazon Web Services (AWS) customers to manage, operate, and scale their databases. A managed service, RDS provides seven database engines and multiple instance sizes and types for working with relational databases. AWS also claims RDS can match the performance, scalability, and availability of commercial databases for a tenth of the price. Is this true, and how much does Amazon RDS cost really? This guide explains how Amazon RDS pricing works.

Missing indexes in PostgreSQL? How to quickly identify it

While working on improving the Netdata PostgreSQL collector, we were monitoring our production PostgreSQL instance and something caught our attention immediately. The rows fetched ratio seemed really, really low for one particular database… there were missing indexes in PostgreSQL! Rows fetched ratio is the percentage of rows that contain data needed to execute the query (rows fetched), out of the total number of rows scanned (rows returned).

Featured Post

Fixing Slow Databases: Improving App Performance Overnight

There's no denying database applications have come a long way over the past few years. Despite all the improvements, however, they're still far from perfect-sometimes, they even feel painfully slow. A seemingly quick and easy task can end up taking hours for no good reason. The result? Angry users, suspicious managers, and a generally unhappy team.