Question:
Hello all ,
can anyone help me in getting the query execution time..
i tried using query monitor , but no mentione of time taken..also tried bw statistics..is there any other possibility of getting the query execution time..
guest
Answer:
Use the Query Monitor RSRT.
Execute in the Debug mode
Mark the box: Others / Display Statisitics Data
Or use transaction ST03 for more nice info.
In here use expert mode.
Check for the values in --> BW System load
Answer:
hi hva..
thanks a lot for ur reply...
but i have a confusion here..
i tried both the ways u mentioned..
using st03.. am unable to see the option 'expert mode' also couldn't see 'BW System load'
Moreover in the transaction rsrt after executing by debug mode and giving the options mentioned by u, did not give me the query execution time..guide me plz..
its veri urgent for me..
prasad
Answer:
hi hva..
iforgot to mention earlier that i am on 2.1c
prasad
Answer:
Probably this will help:
(Sorry! didn't see your reply that you're on 2.1c, as I was busy uploading the screen captures to webshots These are for 3.0B
_________________
Keep smiling
Answer:
hello all,
can anyone help me on my query, about the query execution time...
kindly help..
would appreciate a generous response..
prasad
Answer:
Ok, this set-up might not be available in your release. I can not check. I am on 3.0.
Do you have tableQTIMEDB? (see note 130696 for details).
And, try if table RSDDSTAT is in your release.
Answer:
hi hva..
thanks for input..
also could plz help in getting the format in which the time is being displayed for the field QTIMEOLAPINIT
value is '0,230469'..
i am unable to understand in which format its being displayed..
i mean the date time stamp..
prasad
Answer:
Hello prasad,
It is in seconds.
The time stamp is the start time of the quiery in long format and seems to be: YYYYMMDDHHMMSS.SSSSS.
Answer:
hi hva..
thanks a lot hva..
i have created aggregates on an existing infocube
later found the query time with ur help...
what i found in that the QTIMEOLAP after aggregation is greater than that before aggregation!..
however the QTIMEDB has reduced to large extent..let me show the values below:
before aggregation:
QTIMEOLAP = 1,097656
QTIMEDB = 4,488281
after aggregation:
QTIMEOLAP = 1,226563
QTIMEDB = 0,882812
...what actually do I need to consider for concluding that query time has reduced, QTIMEOLAP or QTIMEDB? or is ther any other time to stress upon...
please advice...
once again thanks a lot hva for ur help..
prasad
Answer:
Hi prasad,
It is QTIMEDB.
But not only this, if it is about Aggregates.
- Is QTIMEDB more than 30% of total runtime without aggr.? If not than than the aggr. is less relevant.
- Check QDBSEL (# Db records read) divided by QDBTRANS (# records transfered). This is the aggreagation ratio. What is the figure with - and without the aggregate?
Succes!
Answer:
hi hva,
before aggregation:
QTIMEDB = 4,488281
after aggregation:
QTIMEDB = 0,882812
Aggregation ratio is 1, both before and after aggregation.
However as the Database time has reduced to a large extent...I hope i can conclude that the aggregation has worked out for me??
plz help.
prasad
Answer:
Hello Prasad,
But what is the info you got in your aggregate maintenance screen?
- valuation, records summarized, usage, # records summarized (sholud be much smaller).
Answer:
hi hva,
records = 170163
records summarized = 1
usage = 3
thanks in advance hva..
prasad
Answer:
Hello prasad,
To my idea your aggr. is useless. There are no records summarized; the aggregate is about as big as the cube. The QTIMEDB is less for you but the total time maybe longer.
I think you have to find out more knowledge about creating aggregates.
The 2 points I gave (QTIMEDB >30% of total and Ratio must be > than 10) are important.
Try proposal by the system.