Sunil S. Ranka's Weblog

Superior Data Analytics is the antidote to Business Failure

Performance Measurement of an OBIEE Application

Posted by sranka on June 20, 2008

Hi All

Its been over a year since, we been having fights/argument with Business regarding application performance, IT kept claiming that application performances well, but business kept saying — “I can click on a page and go for coffee and come back, go for lunch come back, go for meetings and come back and still page keeps running”. Of course I am exaggerating. Along with the database team and DBA we worked on the issue and got to the point where we felt results were good but still it was never ending battle with business.

With frustration, we started looking at the other avenues. Just to horn my webdevelopment skills, downloaded Firebug, the great Mozilla extension and found an option Net withing the utility. Net option does nothing but the “Network Monitoring “.

Looking at the statistics on Net option, I was amazed that almost 20% of the time was taken by CSS and .js. Having said this, doesn’t mean that our reports were superfast, but agreement of 9sec per report was not achievable as CSS and JS were taking around 3.5 seconds. Apart from the CSS, there were few gif files were missing and http request to get those images were taking almost 1.5-2sec. All these things were adding up to the report rendering.

In the above screen shot you can see that the total time (22.08 sec) taken by the request to render on to the page. Look at the saw.dll, this is nothing but the report request to SAS server taking over 19.52 sec and rest is Java Script,CSS, images and etc.

Coming back to the main point, if you guys are profiling your application and doing the application base line, I would highly encourage using Firebug tool. Also keep in mind that its just not the query which constitutes the report performance but the CSS,JS and other things also contributes to it. Along with Firebug you can use Yahoo slow utility. It gives the nice pie view of the total time spent. see the screen shot below.

Yahoo Slow

For more details on how to use Firebug in general go to http://getfirebug.com/. For yahoo slow, go to http://developer.yahoo.com/yslow/.

In case of any questions, please email me at sunil_ranka@yahoo.com. If need arise I can do a conference call.

Hope this helps

Sunil S Ranka

Advertisements

One Response to “Performance Measurement of an OBIEE Application”

  1. Nikhil Kumar said

    Hi Sunil,

    We are facing an issue in OBIEE reports.
    We are using teradata client to connect to teradata database on Sun Solaris server.
    when we open the reports in windows machine it works fine but when we place the same rpd and default catalog folder on UNIX server it gives the below error

    Odbc driver returned an error (SQLExecDirectW).
    Error Details
    Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 16023] The ODBC function has returned an error. The database may not be available, or the network may be down. (HY000)

    We are able to connect to teradata database using ./adhoc from UNIX machine.

    Do we need to set any environment variable for the same?
    Any help in this regrd will be highly appreciated.
    Please mail me on nikhil.cts@gmail.com

    Thanks
    Nikhil

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: