Infrastructure at your Service

Tag

Monitoring Archives - Blog dbi services

Elisa Usai

What I really like about Percona PMM

By | Cloud, Database Administration & Monitoring, MariaDB, MySQL, Oracle, Postgres, SQL Server | No Comments

Percona Monitoring and Management tool (PMM) is an Open Source product which was developed to help DBAs and developers to monitor and manage MySQL, PostgreSQL and MongoDB performances. In this blog post, we will see that we can do much more with it! I discovered this tool 2 years ago when I started a monitoring study for a customer, and ever since, I’ve been in love with it. I will explain you why.

Read More
Nabil Laabid

Monitoring – first steps with Prometheus

By | Application integration & Middleware, Database Administration & Monitoring | No Comments

Monitoring is a crucial element of DevOps automation that has to be proactive, meaning it must find ways to improve applications quality before bugs appear. Therefore, we have to quickly and easily understand what is happening in our infrastructure, which is often more and more complex and constantly evolving. In this context, one tool stands out: Prometheus. Prometheus is an open-source, metrics-based monitoring system and alerting tool. It collects data about applications and systems in…

Read More
Daniel Westermann

Open source monitoring solutions (2) – Zabbix agents and PostgreSQL monitoring

By | Database Administration & Monitoring | No Comments

By the end of the last post we finished with a running Zabbix server which uses PostgreSQL as it’s back-end database. In addition a Zabbix agent is running on the same host, so the monitoring host itself is present in the Zabbix console. In this post will deploy the Zabbix agent on three PostgreSQL Patroni nodes and later on configure Zabbix to monitor the PostgreSQL instances.

Read More
Daniel Westermann

Open source monitoring solutions (1) – Zabbix server setup

By | Database Administration & Monitoring | No Comments

We are often asked which monitoring solution we recommend for PostgreSQL, by people attending our PostgreSQL workshops. We usually answer: What do you have in place already? If a solution already is in place, the most obvious way is trying to integrate into the existing solution. If nothing is there already, you have plenty of choices. You can find some of them on this blog, but the list is quite old. Usually, PostgreSQL is not…

Read More
Stéphane Haby

SQL Server: Analysis of SCOM Warning on the Health Check

By | Database Administration & Monitoring, Database management, SQL Server | No Comments

Sometimes, it’s hard to find how to analyze a Warning in the SCOM Interface and correct the problem. By a customer, we install new instances in SQL Server 2019 and change the version of SCOM. All new servers have a warning on the Health. The first step in the SCOM interface is to go to the SQL Server Roles: On this step, the most important is to open the Health Explorer and not double-click or…

Read More
Daniel Westermann

temBoard on SLES15 – 2 – The agent

By | Database Administration & Monitoring | No Comments

In the last post we’ve installed the temBoard repository and the UI. As this alone is not so much fun, we’ll be installing the temBoard agent on another SLES 15 machine in this post. We’ll end up with one PostgreSQL instance registered in the temBoard repository and this instance is constantly monitored. With the repository and the UI we had the requirement to use Python 2.7, but this is not anymore required for the temBoard…

Read More
Daniel Westermann

temBoard on SLES15 – 1 – The WebUI

By | Database Administration & Monitoring | No Comments

During our last SwissPUG online meeting there was a presentation about monitoring PostgreSQL with temBoard. A question that came up afterwards was: How to install that on SLES 15 as there are only packages for Debian and CentOS/RHEL. As temBoard is written in Python you can also install it using pip. That requires a bit more work compared to the package method, but it is perfectly fine. The only downside (but this is true for…

Read More
Ali Asghari

Install & configure a Nagios Server

By | Database Administration & Monitoring, Oracle, SQL Server | No Comments

What is Nagios ? “Nagios is a powerful monitoring system that enables organizations to identify and resolve IT infrastructure problems before they affect critical business processes.” https://www.nagios.org/ In simple words, you can monitor your servers (linux, MSSSQL, etc …) and databases (Oracle, SQL Server, Postgres, MySQL, MariaDB, etc …) with nagios.   We use the free version !!! 😀   VM configuration : OS : CentOS Linux 7 CPU : Intel(R) Xeon(R) CPU E5-2620 v4…

Read More
Morgan Patou

WebLogic – Update on the WLST monitoring

By | Application integration & Middleware | No Comments

A few years ago, I wrote this blog about a WLST script to monitor a WebLogic Server. At that time, we were managing a Documentum Platform with 115 servers and now, it’s more than 700 servers so I wanted to come back in this blog with an update on the WLST script. 1. Update of the WLST script needed Over the past two years, we installed a lot of new servers with a lot of…

Read More
Morgan Patou

Documentum story – Monitoring of WebLogic Servers

By | Database Administration & Monitoring, Enterprise content management | No Comments

As you already know if you are following our Documentum Story, we are building, working and managing, for some time now, a huge Documentum Platform with more than 115 servers so far (still growing). To be able to manage properly this platform, we need an efficient monitoring tool. In this blog, I will not talk about Documentum but rather I will talk a little bit about the monitoring solution we integrated with Nagios to be…

Read More