Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to measure Data Warehouse performance

Hi,
We need to know how can we measure performance of data warehouse ? How can we analyze current system performance ?
can anybody suggest ?
Thanks!
Answers
-
Hi,
100 - the number of emails of complaints you get from users saying the analysis are slow per week = the performance in %.
More in general what's the link between "performance of a datawarehouse" and OBIEE (the place where you posted the question) ?
Can you define what performance of a datawarehouse? I bet you can't ... just because that concept doesn't exist and it's a totally subjective and evolutive thing.
0 -
Hi Gianni,
Thanks for your reply!
We are using OBIEE 12c in our environment and management is looking for some other analytic product and wants to analyze current system performance.
What specific areas we need to look to get measure current system performance ?
Thanks,
Mukesh
0 -
Mukeshs wrote:management is looking for some other analytic product and wants to analyze current system performance.
That's the thing ... "system performance" doesn't really mean anything.
It's all about what you do with your system and how you use it.
But you will hardly compare tools by "performance", it's about BI, so it's all about functionality first. Performance can always be achieved in a way or another.
So you are the only one able to define what you call "performance" and once you defined it you will have to find a way to measure it.
0 -
As Gianni is already saying, the term performance on itself doesn't really mean that much, you need to define what exactly you want to measure and what to compare it to.
Your performance will not magically improve just by using another tool, you will need to know what you are doing to get it working right.
OBIEE <> datawarehouse, performance bottlenecks can be in the Datawarehouse, or OBIEE Server, or both. You should find out what is causing the system to perform as it is before you can do anything about it (and definitely before doing something drastically like switching tools)
To get some ideas about Database / Datawarehous Optimization (Assuming you are using an Oracle database), read:
A good guide about OBIEE optimization is provided by RittmanMead:
https://www.rittmanmead.com/blog/2013/03/performance-and-obiee-introduction/
0 -
You might want to set up usage tracking, that will give you a meaningful measure of what reports are being run on a regular basis and of those reports what their runtimes are.
The combination of the two factors will provide a useful starting point to ascertain which regularly used reports could potentially yield the largest benefit if they run faster than currently.
0 -
Btw - you might also want to have a look at; -
0 -
Why are you asking us? MANAGEMENT wants the new system - management therefore has the criteria and requirements for making the decision ...
I often say "You can confess to one or both of the following 2 sins - incompetence or inconsistency; there's no opting out of either - pick one or both..."
Incompetence - management doesn't know how to make the decision
Inconsistency - management has no consistent criteria fro decision-making
I've gone into clients and have been told - the system isn't performing ... it takes a lot of know-how and effort to fully vet the performance (end-to-end) and expose the potential bottle-necks -- is management willing to spend that kind of money and time on a 'want'?
0 -
Hi Thomas,
Exactly this is the case you have mentioned !
We have enabled USAGE tracking and created custom dashboards to measure ETL performance. Since usage tracking will not give us much data as of now.
What metrics do we need to set in order to measure OBIEE performance ? Could you please suggest your expert view on this ?
Thanks!
0 -
Mukeshs wrote:What metrics do we need to set in order to measure OBIEE performance ?
So it seems you are trying to do something as a wrong answer to the wrong question.
There isn't a thing called "OBIEE performance".
You can measure page rendering time, Kb/s delivered over the network, page views per day and another amount of random things. What all these things give you? Nothing, just a bunch of numbers on a page / spreadsheet, not usable for any decision or anything other than bragging about how many metrics you collected for nothing.
One analysis can take 1 second at 10:00am, 30 seconds at 10:01am, fail at 10:02am and take 1 second at 10:03am : what's the performance of the system based on that? Well ... Nothing... It took 30 seconds because the system on which the user opened it was struggling and his browser was about to crash, it failed because there was a connection issue with the DB at that time and then was working fine again.
You have a bunch of links posted above giving hints, but you still have no idea of what you look for apparently.
So if you try to answer a random management request of "show me OBIEE performance" then take Excel, use RAND() many times to get numbers changing all over the place and done, they will anyway not get nor care about a single thing of your OBIEE performance. It's just a way to say "you see, that other system is faster because I tell you so, and that's why we change".
0 -
0