Infrastructure at your Service

Monitoring Archives - Blog dbi services

Morgan Patou

Documentum story – Monitoring of WebLogic Servers

By | Database Administration & Monitoring, Entreprise 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: (postgres@[local]:4448) [postgres] > create table t1 ( a int ); CREATE TABLE (postgres@[local]:4448) [postgres] > insert into t1 values ( generate_series ( 1, 10)); INSERT 0 10 (postgres@[local]:4448) [postgres] > select count(*) from t1; count ——- 10 (1 row) (postgres@[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 | No 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 | No 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: [root@oel7 ~] yum install -y python Then we need to…

 
Read More
Daniel Westermann

SQL Monitoring in PostgreSQL (2) – pg_stat_statements

By | Database Administration & Monitoring | No Comments

The last post looked into how you can monitor queries using the logging system. This post will introduce pg_stat_statements. pg_stat_statements is a module that needs to be loaded and is not available in the default configuration. Loading it is quite easy. Create the extension as usual: postgres@oel7:/home/postgres/ [PG6] sqh Null display is “NULL”. Timing is on. psql (9.5alpha2) Type “help” for help. (postgres@[local]:4448) [postgres] > create extension pg_stat_statements; CREATE EXTENSION Time: 281.765 ms (postgres@[local]:4448) [postgres]…

 
Read More
Daniel Westermann

SQL Monitoring in PostgreSQL (1) – the logging system

By | Database Administration & Monitoring | No Comments

When developing an application as well as when the application is in production there is the need to identify long running queries. In Oracle one tool you might use for that is the SQL Monitor. In this post I’ll look into what PostgreSQL provides in this area. PostgreSQL has a very strong logging system. This system can be used to log many, many server messages as well as information about sql queries. To enable to…

 
Read More
David Schmitt

Oracle EM Cloud Control 12c (CC12c)- Repeat alert notification

By | Database Administration & Monitoring | No Comments

Oracle EM Cloud Control 12c (CC12c) – Repeat alert notification In your EM installation, CC12c will notify your different administrators when specific incidents, events, or problems occurs. But from standard configuration, you will receive only one warning or critical notification/alert … until the Clear or an Acknowledge of the alert. Some times and for different reasons (human error, email was deleted, Mail server issues, …) you can lost or forgot this alert. Hummm this is…

 
Read More
Daniel Westermann

using dbms_server_alert in combination with a custom monitoring solution

By | Database management | No Comments

Lot’s of companies do not use Grid- or Cloud Control for monitoring their Oracle databases for various reasons but rather use open source tools like nagios. And lot of those either implemented custom script frameworks or rely on plug-ins available for the monitoring solution of choice. This post shall show on how you can let Oracle check a lot of its own metrics and you only need one script for alerting various metrics. Oracle provides…

 
Read More