Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

Troubleshooting PostgreSQL: How to Use Logs and Metrics to Fix Slow Queries

Imagine some users complaining that querying PostgreSQL is slow (this never happened right?), and we have to troubleshoot this problem. It could be one of two things: I would normally first check on the environment, specifically PostgreSQL metrics over time. Such monitoring shows if the CPU is too high or how many disk reads were buffer reads. PostgreSQL logs also give information about the environment, such as how many statements were run and if any errors occurred.

The Best MySQL Monitoring Tools & Software of 2020

Evolving MySQL operations requires understanding how MySQL works. A good monitoring tool alerts on issues before they impact end users and helps reduce the MTTR of incidents when they do occur. But choosing a database monitoring solution can be tough due to the vast number of solutions available, each with their own pros and cons. In this blog post, I’ll review some of the best MySQL monitoring tools available that can help measure and improve database performance.

Monitor MarkLogic with Datadog

MarkLogic is a multi-model NoSQL database with support for queries across XML and JSON documents (including geospatial data), binary data, and semantic triples—as well as full-text searches—plus a variety of interfaces and storage layers. Customers include large organizations like Airbus, the BBC, and the U.S. Department of Defense. Because MarkLogic can process terabytes of data across hundreds of clustered nodes, maintaining a deployment is a complex business.

Community Highlight: How to Build an InfluxDB Template

For the last few months, I have been actively contributing to the InfluxDB community by building InfluxDB Templates for InfluxDB 2.0. InfluxDB is the purpose-built time series database used for metric collection and storage. Let’s build an InfluxDB Template to monitor PostgreSQL together! 👏

Upcoming PostgreSQL Support for Icinga Certificate Monitoring

Our goal is to support both MySQL and PostgreSQL as a backend wherever we need a database. Our latest addition in this area was PostgreSQL support for reporting, which will be released in the next few weeks. We don’t have PostgreSQL support for Icinga Certificate Monitoring yet. But it has already been worked on and the pull request for it is waiting to be tried. We would be happy to receive feedback in this regard so that we can fully merge PostgreSQL support as soon as possible.

VMware Tanzu SQL, Now GA for Kubernetes: A Consistent Postgres Experience Everywhere

Data services—such as caches, messaging queues, and relational databases—are the backbone of applications. And when it comes to relational databases, Postgres is a pretty popular option. Its killer feature is its versatility. Natively and through plugins, Postgres supports a wide variety of data types, formats, and programming languages, which makes it useful for all kinds of applications, including text, geospatial, graph, and more.

Reduce monitoring silos with SquaredUp WebAPI and SQL tiles

SCOM is a great solution to monitor your infrastructure. Everything you need for in-depth monitoring is provided out-of-box or with a dedicated management pack. If your organization is genuinely invested with SCOM, you probably also know that you can get in-depth monitoring with SCOM’s Application Performance Monitoring (APM) functionality, and collect events across your servers with SCOM’s Audit Collection Services (ACS).

Elevate your Oracle Monitoring and Service Management now and get 20% off!

Get above and beyond Oracle monitoring on SCOM by creating actionable ServiceNow incidents from your SCOM alerts with real-time, two-way synchronization. Cookdown and NiCE have joined forces to help you leverage your SCOM and Oracle monitoring investment while increasing your IT Service Management quality, in the best possible way.