Infrastructure at your Service

Tag

Monitoring Archives - Blog dbi services

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
Daniel Westermann

The dbi services PostgreSQL reference architecture (1) – The commercial approach

By | Database Administration & Monitoring | No Comments

When it comes to designing a PostgreSQL architecture that fits your requirements there are a couple of things to think about: Do you need a HA setup? How shall backups and restores being done and how shall all of these components get monitored? Do you need vendor support for all the tools that make up the architecture? At dbi we have a reference architecture that we can apply to most of our projects. It is…

Read More
Daniel Westermann

Watching sql statements in PostgreSQL

By | Database Administration & Monitoring | No Comments

Back in 2012 I wrote a small blog post about watching the results of commands in Linux. Well, the same can be done in psql: ([email protected][local]:4448) [postgres] > create table t1 ( a int ); CREATE TABLE ([email protected][local]:4448) [postgres] > insert into t1 values ( generate_series ( 1, 10)); INSERT 0 10 ([email protected][local]:4448) [postgres] > select count(*) from t1; count ——- 10 (1 row) ([email protected][local]:4448) [postgres] > \watch Watch every 2s Mon Dec 21 07:34:35…

Read More
Daniel Westermann

Monitoring tools for PostgreSQL – POWA

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

The last posts introduced the logging system, pg_stat_statements, pg_activity and pgcluu. This post will look at POWA: PostgreSQL Workload Analyzer. For getting the most out of POWA the following extension should be installed in the PostgreSQL instance you want to monitor: pg_stat_statements (see last post) pg_stat_kcache: gathers statistics about reads and writes done by the file system layer pg_qualstats: gathers statistics of predicates found in where statements and join clauses btree_gist: provides GiST index operator…

Read More
Daniel Westermann

Monitoring tools for PostgreSQL – pgcluu

By | Database Administration & Monitoring | 3 Comments

The last posts introduced the logging system, pg_stat_statements and pg_activity. All of these can be used to monitor sql statements the PostgreSQL server is executing. In this post I’ll look into pgcluu: PostgreSQL Cluster utilization! This is a more complete monitoring solution as it is not only focused on sql statements but gives you information about the database cluster itself and other useful stuff. All you need to run pgcluu is a modern perl distribution…

Read More
Daniel Westermann

SQL Monitoring in PostgreSQL (3) – pg_activity

By | Database Administration & Monitoring | 8 Comments

The last posts looked at how the logging system and the pg_stat_statements extension can be used to monitor sql statements in PostgreSQL. This post will introduce pg_activity which is very similar to htop. There are some dependencies which need to be installed before we can start installing pg_activity. The first one is python. As I am on a redhat based distribution this is quite easy: [[email protected] ~] yum install -y python Then we need to…

Read More