Report event - Time

Hi All,

when we generate the report (DESKI / WEBI). how do calculate/ know the time for each & event?

For example we will take report loading process…

Step 1 : user log on - from Desktop to Web servre
Step 2 : Web server send request to Application server
Step 3 : WCA send request to CMS /System DB
Step 4 : CMS request send to external authentication
Step 5 : Authentication send response to CMS
Step 6 : CMS send the response to Application Server
Step 7 : Application send request to Cache server
Step 8 : Cache server send request to page server
Step 9 : Page server send request and get response from FRS
Step 10 : Page server response to the cache server
Step 11 : Cache server response to Application server
Step 12 : Application server response to the web server
Step 13 : Web server response to the Desktop

And finally the user view the report

in the above scenaro, how to know the each and every even time…

Pls suggest me…

Thanks
Naga


Nags :india: (BOB member since 2007-02-07)

[Moderator Note: Moving from General Discussion to XI Server Discussion]


Marek Chladny :slovakia: (BOB member since 2003-11-27)

You would have to enable tracing on all your servers then comb through the log files. I don’t know if every server captures IDs when logging is enabled so you might have to do this in a test environment where you can control system usage.

But why would you be interested in those times? There’s almost nothing you can do to realistically improve any of them. Also, the sum total of all the processes you listed is a very small figure in seconds.


BoB LoblaW :us: (BOB member since 2007-10-23)

Thanks for your reply my bff jill…

yes … i want know which event / action taking more time …

in my BOXIR2 report taking more than 10 mins… :frowning:

So i planned to improve the performance …

Tx


Nags :india: (BOB member since 2007-02-07)

Hi,

I suggest focusing on optimizing the report query/queries rather than optimizing the steps mentioned above.


Marek Chladny :slovakia: (BOB member since 2003-11-27)

I agree with Marek’s advice. Does it take 10 minutes to login? To open the report? To refresh data? Try narrowing your focus or you’ll be chasing a million different things that have nothing to do with the real problem.


BoB LoblaW :us: (BOB member since 2007-10-23)