Categories
OBIEE Admin tool performance
Hi,
OBIEE 12.2.1.3
The Admin tool is installed on Windows Server 2012R2 machine. The machine is having 18 GH of memory.
But still when I work with RPD, its dead slow!, I can experince slowness even to go up and down in the BMM and other layers!
The infra team says server is not even reaching 30% of utilization, not sure what is going on can somone help me with how can I improve the performance of Admin tool.
Regards
Hesh
Answers
-
Can someone please help me with this... even any reference read I can do.
Regards
Hesh
-
0 -
What kind of work is it: online or offline?
How big is your RPD?
Does it behave differently when using the admin tool somewhere else than on that environment?
I don't remember having ever seen a document about "admin tool" performance.
0 -
Adding to Gianni: why are you still on 12.2.1.3? There were 3 major releases since then and countless bundle patches.
0 -
Thank you Gianni,Christian ..
The RPD size is 1 MB and we are working offline.
We will try the RPD in some other environment, we need to sort out permissions for that.
The version is not upgrated for sometime now! any potential issues with the current one i.e. 12.2.1.3 ?
Any specific memory settings we need to have for the Admin tool?
like I was reading somewhere about Java heap size, not sure if that is related but anything similar we can consider to have to review?
Regards
Hesh
0 -
To what numbers of objects does the 1Mb translate? (subject areas, business models, .... some generic numbers to have an idea about what's inside that RPD).
The Admin tool isn't Java (and that's why it works only on Windows), so java settings aren't going to do much.
0 -
Thanks Gianni,
Following is the number of objects in BMM layer currently ...
I was also requesting IT to install Admin tool in some other server , but they are raising issues as there could be some licencing required . Not sure if we need any licencing for Admin tool .
i) DWarehouse -- 89 Dim and 30 Fact
iI) XYZ Model -- 30 Dim and 6 Fact
iiI) DQ Model -- 1 Dim and 1 Fact
iv) ETL Stats -- 3 Dim and 1 Fact
v) Usage Tracking -- 4 Dim and 1 Fact
Dimensional Hierarchies list as same as no. of dim tables
Regards
Hesh
0 -
Based on your numbers, your RPD isn't huge but already a good size with 120 elements in a logical model.
More than on another server I would try on a client: the admin tool is developed to be used on a laptop or desktop PC, it is a client.
There is no licensing, you can install 200 admin tools, you are paying for the server licenses.
0 -
Thanks Gianni,
We have tested this RPD in local environment now and the performance looks very good.
Now its clear that the issue is not with the RPD, something should be wrong with that Remote server, I believe as this is a GUI toolthe screen movement over a remote environment slowign down this, can't say anything!
Regards
Hesh
0 -
Hi Gianni,
While going through the Certification Matrix of the Admin tool 12.2.1.3 is compatable with Windows 7, 8.1, & 10 only.
But our machine where the tool is installed is of Windows server 2012 R2, do we have anything available to support this version of Windows?
Regards
Hesh
0 -
As far as I know no, because the concept of the Admin tool is to be a client tool, not a server tool. Therefore the certification is for clients OS (and not server OS).
0
