Is there any way to get the break of the report execution time.
I mean to see how much time it took in DB to fetch the data and the time to display.
For e.g total execution time is 1 min ( 40 secs in DB & 20 secs in congos to format and display).
Thanks in advance.
This topic has been locked.
1 reply Latest Post - 2013-01-31T14:44:41Z by DanielWagemann
Pinned topic How to get the break of the report execution time
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-31T14:44:41Z at 2013-01-31T14:44:41Z by DanielWagemann
DanielWagemann 2700058MAJ839 PostsACCEPTED ANSWER
Re: How to get the break of the report execution time2013-01-31T14:44:41Z in response to ankam1987There is a Perf.QFS trace that is covered in the following training course:
If you cannot take that, you will need schedule the report to completion to get the entire execution time, and in parallel trace the incoming query to the database.
TotalReportExecution-timeondatabase would give you the time the report takes to do its local processing and rendering. This would not cover any request transport time. (Time between dispatchers etc.)