Rittman Mead Blog - Performance

Tagged

Performance

A collection of 35 posts

OBIEE Component Status Notifications

At Rittman Mead, we often hear requests for features or solutions generally not provided by Oracle. These requests range from commentary functionality to custom javascript visualizations. There are many ways to implement these functionalities, but organizations often lack the in-house resources to engineer an acceptable solution. Rittman Mead has the

New Performance Analytics Release

Poor performance is one of the most common complaints we hear upon arrival to customer sites, and often for good reason. When users have time to “make the rounds” before the system returns a result (if it returns a result at all), they have the right to be frustrated. Unfortunately,

Common OBIEE Implementation Mistakes That Impact Performance

I've recently performed several assessments to help our clients diagnose and fix their OBIEE performance problems. They often share similar design or implementation issues, and I thought it would be useful to present them here as a handy reference: * No software monitoring * Randomly changing configuration settings * Data transformation

POUG

I've just attended my first user group in Poland, the very-excellent POUG [http://poug.org/en/]. This was the first international version of the conference, having been run previously just within Poland. Based on these two days, I would say it was a resounding success! There was a

All You Ever Wanted to Know About OBIEE Performance…but were too afraid to ask

At the Polish Oracle Users Group (POUG) conference [http://poug.org/en/timeline/] this week I'm presenting one of my favourite talks, [Still] No Silver Bullets - OBIEE Performance in the Real World [https://speakerdeck.com/rmoff/still-no-silver-bullets-obiee-12c-performance-in-the-real-world] . This presentation is based on the shared experiences of myself

System Metrics Collectors

The need to monitor and control the system performances is not new. What is new is the trend of clever, lightweight, easy to setup, open source metric collectors in the market, along with timeseries databases to store these metrics, and user friendly front ends through which to display and analyse

OBIEE 12c – Extended Subject Areas (XSA) and the Data Set Service

OBIEE 12c – Extended Subject Areas (XSA) and the Data Set Service

One of the big changes in OBIEE 12c for end users is the ability to upload their own data sets and start analysing them directly, without needing to go through the traditional data provisioning and modelling process and associated leadtimes. The implementation of this is one of the big architectural

New OTN Article - OBIEE Performance Analytics: Analysing the Impact of Suboptimal Design

New OTN Article - OBIEE Performance Analytics: Analysing the Impact of Suboptimal Design

I’m pleased to have recently had my first article published on the Oracle Technology Network (OTN) [http://www.oracle.com/technetwork/index.html]. You can read it in its full splendour and glory(!) over there [https://community.oracle.com/docs/DOC-993649], but I thought I’d give a bit

OBIEE Performance - Why Metrics Matter (and…Announcing obi-metrics-agent v2!)

OBIEE Performance - Why Metrics Matter (and…Announcing obi-metrics-agent v2!)

One of the first steps to improve OBIEE performance is to determine why it is slow. That may sound obvious—can’t fix it if you don’t know what you’re fixing, right? Unfortunately, the “Drunk Man anti-method [http://www.brendangregg.com/methodology.html]”, in which we merrily stumble

Using Linux Control Groups to Constrain Process Memory

Using Linux Control Groups to Constrain Process Memory

Linux Control Groups [http://docs.oracle.com/cd/E37670_01/E37355/html/ol_about_cgroups.html] (cgroups) are a nifty way to limit the amount of resource, such as CPU, memory, or IO throughput, that a process or group of processes may use. Frits Hoogland [https://fritshoogland.wordpress.com/2012/

Driving OBIEE User Engagement with Enhanced Usage Tracking for OBIEE

Driving OBIEE User Engagement with Enhanced Usage Tracking for OBIEE

Measuring and monitoring user interactions and behaviour with OBIEE is a key part of Rittman Mead’s User Engagement Service [http://ritt.md/ue]. By understanding and proving how users are engaging the system we can improve the experience for the user, driving up usage and ensuring maximum value for

Introducing the Rittman Mead OBIEE Performance Analytics Service

Introducing the Rittman Mead OBIEE Performance Analytics Service

Fix Your OBIEE Performance Problems Today OBIEE is a powerful analytics tool that enables your users to make the most of the data in your organisation. Ensuring that expected response times are met is key to driving user uptake and successful user engagement with OBIEE. Rittman Mead can help diagnose

What's New in OBIEE 11.1.1.9 for Systems Administrators and Developers

What's New in OBIEE 11.1.1.9 for Systems Administrators and Developers

After over two years since the last major release of OBIEE, Oracle released version 11.1.1.9 in May 2015. You can find the installers here [http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-2537285.html] and documentation here [https://docs.oracle.com/middleware/11119/biee/docs.htm]. 11.

Analysing ODI performance with Flame Graphs

Flame Graphs [http://www.brendangregg.com/flamegraphs.html] are a visualisation that I learnt about through the excellent Linux systems performance work of Brendan Gregg [http://www.brendangregg.com/], and saw Luca Canali [https://twitter.com/lucacanalidb] talk about recently at UKOUG Tech 14 [http://tech14.ukoug.org/default.asp?

Instrumenting OBIEE Database Connections For Improved Performance Diagnostics

Nearly four years ago I wrote a blog post entitled “Instrumenting OBIEE - The Final Chapter” [https://rnm1978.wordpress.com/2011/10/10/instrumenting-obiee-the-final-chapter/] . With hindsight, that title suffix (“The Final Chapter”) may have been a tad presumptuous and naïve of me (or perhaps I can just pretend to be

An Introduction to Analysing ODI Runtime Data Through Elasticsearch and Kibana 4

An important part of working with ODI is analysing the performance when it runs, and identifying steps that might be inefficient as well as variations in runtime against a baseline trend. The Operator tool in ODI itself is great for digging down into individual sessions and load plan executions, but

OBIEE Monitoring and Diagnostics with InfluxDB and Grafana

In this article I’m going to look at collecting time-series metrics into the InfluxDB database and visualising them in snazzy Grafana dashboards. The datasets I’m going to use are OS metrics (CPU, Disk, etc) and the DMS metrics from OBIEE, both of which are collected using the support

BI Forum 2014 preview - No Silver Bullets : OBIEE Performance in the Real World

I'm honoured to have been accepted to speak at this year's Rittman Mead BI Forum [http://www.rittmanmead.com/biforum2014/], the sixth year of this expert-level conference that draws some of the best Oracle BI/DW minds together from around the world. It's running

Built-In OBIEE Load Testing with nqcmd

nqcmd ships with all installations of OBIEE and includes some very useful hidden functionality - the ability to generate load tests against OBIEE. There are lots of ways of generating load against OBIEE [https://www.rittmanmead.com/blog/2013/03/performance-and-obiee-test-build/], but most require third party tools of varying degrees

Introducing obi-metrics-agent - an Open-Source OBIEE Metrics Collector

Understanding what is going on inside OBIEE is important for being able to diagnose issues that arise, monitor its health, and dig deep into its behaviour under stress in a load test. OBIEE exposes a set of metrics through the Dynamic Monitoring Service (DMS) and viewable through Enterprise Manager (EM)

Oracle BI Suite EE

Monitoring OBIEE Performance for the End User with JMeter from EM12c

This is the third article in my two-article set of posts (h/t [https://en.wikipedia.org/wiki/Trilogy_in_five_parts]) on extending the monitoring of OBIEE within EM12c. It comes after a brief interlude discussing Metric Extensions [https://www.rittmanmead.com/blog/2013/11/collecting-usage-tracking-data-with-metric-extensions-in-em12c/] as an alternative

Oracle Data Integrator 12c release : Part 2

In the first part of this article [https://www.rittmanmead.com/blog/2013/10/oracle-data-integrator-12c-release-part-1], we discovered the new mappings and reusable mappings, the debugger and the support of OWB jobs in the freshly released ODI 12c. Let's continue to cover the new features in ODI 12c with

Rittman Mead BI Forum Atlanta Special Guest: Cary Millsap

I feel like I'm introducing the Beatles... though I think Kellyn Pot'Vin [https://twitter.com/DBAKevlar] calls them the "DBA Gods" [http://dbakevlar.com/author/kpedersen/]. Today I'll be talking about Cary Millsap, and tomorrow I'll introduce our other special

Performance and OBIEE - Summary and FAQ

This article is the final one in a series about OBIEE and performance. You can find the previous posts here: 1. Introduction [/2013/03/performance-and-obiee-introduction] 2. Test - Define [/2013/03/performance-and-obiee-test-define] 3. Test - Design [/2013/03/performance-and-obiee-test-design] 4. Test - Build [/2013/03/performance-and-obiee-test-build] 5. Execute [/2013/03/

Performance and OBIEE - part VII - Optimising OBIEE performance ("Tuning")

Potato potato? When I first drafted this blog post, I gave it the title “Tuning”, rather than “Optimising”. Tuning is the word used so often in the context of performance, but it can actually be a bit misleading. A system that has fundamental design flaws doesn’t need “tuning” -