Infrastructure at your Service

Monitoring Archives - Page 2 of 3 - Blog dbi services

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
Stéphane Savorgnano

SQL Server monitoring with nagios: utilisation

By | Database management | No Comments

We saw in my last blog how to install the SQL Server plugin for Nagios. In this new blog, I will explain: how to create a wrapper to avoid the unset of the PERLLIB variable how to create and configure a configuration file by monitoring instance how to create an SQL Login for nagios How to subscribe to an alert As we saw in the first nagios blog, to be able to run the check…

Read More
Stéphane Savorgnano

SQL Server monitoring with nagios: installation

By | Database management | 2 Comments

Nagios is an IT Infrastructure monitoring solution which is able to monitor SQL Server instances with a specific plugin. I have installed this plugin to test those functionalities and I will explain here how to do it. Prerequisites installation FreeTDS installation FreeTDS is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft SQL Server and Sybase databases. First we will download this set of libraries, for that…

Read More
Morgan Patou

Alfresco Summit 2014 – Conferences, Day 2 – Best Practices & Monitoring

By | Application integration & Middleware | No Comments

As I said in my last blog, the Alfresco Summit 2014 took place in London from October 7 to 9. So yeah, unfortunately yesterday was the last day of this amazing event. It’s the first time I had the chance to participate in an Alfresco Summit but I’m quite sure it will not be the last! I can’t tell what moment I preferred during this event because the Keynote (presentation of Alfresco One 5.0) was very…

Read More
Oracle Team

Linux: how to monitor the nproc limit

By | Database Administration & Monitoring, Oracle | 16 Comments

By Franck Pachot . You probably know about ‘nproc’ limits in Linux which are set in /etc/limits.conf and checked with ‘ulimit -u’. But do you know how to handle the monitoring and be alerted when you’re close the fixed limit? Nproc and ps Nproc is defined at OS level to limit the number of processes per user. Oracle 11.2.0.4 documentation recommends the following: oracle soft nproc 2047 oracle hard nproc 16384 But that is often…

Read More
Oracle Team

Oracle SQL Monitoring reports in flash, html, text

By | Database management, Oracle | No Comments

By Franck Pachot . I have recently posted on the way I like to extract execution plans. When we have Tuning pack, I suggest to get them with SQL Real-Time Monitoring as an active report. However, Martin Preiss said in a comment that he prefers the text format – easier to search, copy, and paste. And that’s a very good remark. We still need plain text. My point is that if you send me the…

Read More
Gérard Wisson

WebLogic: Using a WLST script to find a specific word in an object

By | Application integration & Middleware | No Comments

On a WebLogic Server, I had to write a WLST script to find the current number of consumers accessing a specific JMS Queue destination as this is not monitored by Oracle Grid Control 11g or Oracle Cloud Control 12c. Knowing only the short name of the queue, I uses a regular expression in my WLST script to find the needed information. To find the correct queue destination I had to search the Queue Destination Name….

Read More
Stéphane Haby

SQL Server 2012: new perfmon counters

By | Development & Performance | One Comment

I have read some blog postings concerning the new perfmon counters, but I have not seen really extensive overviews yet. In this post, I would like to present not only what is new, but also what has changed (or not) and how to find it. The first step is to select all objects in SQL2008R2 and SQL2012 from the view sys.dm_os_performance_counters. Remarks: All object or counter definitions from this post come from msdn. Objects comparison The…

Read More
Arnaud Berbier

UKOUG 2012: Middleware

By | Application integration & Middleware | 2 Comments

I had the opportunity to spend two days in England (Birmingham) to participate in the UKOUG 2012. My first day was the Middleware sunday. This event is related to technical content and feedback for WebLogic administrators. It was an interesting day with useful feedback related to Oracle WebLogic. This Sunday middleware agenda event was as follows: WebLogic Sctripting Tool – Taking WLST to the Next Level (Simon Haslam, Veriton Limited) Node Manager under the Covers…

Read More
Gérard Wisson

DOAG 2012: News on WebLogic 12c, monitoring, licensing

By | Application integration & Middleware | No Comments

I spent three interesting days at the DOAG Konferenz 2012 – the German Oracle User Group’s conference. It was the 25th birthday and my first time as a DOAG Konferenz speaker. In this post, I will not talk about my presentation, but rather give you information from the sessions I went to. I will talk about three areas: Oracle WebLogic 12c, monitoring & diagnostics, and licensing. Regarding WebLogic, Mr. Munz from munz & more described…

Read More