Skip to Content
0
Apr 14, 2014 at 02:45 PM

How to get query response time from ST03 via a script ?

101 Views

Hello People,

I am trying to get average query response time for BW queries with a script (for monitoring/historisation).

I know that this data can be found manually in ST03n in the "BI workload'.

However, I don't know how to get this stat from a script.

My idea is to run a SQL query to get this information, here is the state of my query :

select count(*) from sapbw.rsddstat_olap

where calday = 20140401

and (eventid = 3100 or eventid = 3010)

and steptp = 'BEX3'

The problem is that this query is not returning the same number of navigations as the number shown in ST03n.

Can you help me to set the correct filters to get the same number of navigation as in ST03n ?

Regards.