Run time for a query

[Former Member]

Hello all,

Can you please tell me how can I see the total running time for a query?

What other transactions besides ST03 and RSRT with statistics on?

Points will be assigned

Thanks

Ramona

[Former Member · Accepted solution]

Hi Ramona,

this is very different for BW3.5 and BI 7.0 In BI 7.0 there are much more options an tables to look at than in BW3.5 And ST03N will only work in BI, if the Technical content is activated and the interesting Queries and Cubes are marked for monitoring. There are other threads here for details about this. But in general RSDDSTAT* will give you the tables where all this knowledge is hidden.

Kind regards,

Jürgen

[Naga_P]

Hi,

Table RSDDSTAT gives you this information. OSS Note Note 309955 - BW statistics - Questions, answers and errors - details the various fields of this table.

rgds

naga

[Former Member]

Hi........

You can use ST03N -> BW System Load

Depending on the time frame you select, you get historical data or

current data.

To get to a specific query you need to drill down using the InfoCube

name

Use Aggregation Query to get more runtime information about a

single query. Use tab All data to get to the details.

(DB, OLAP, and Frontend time, plus Select/ Transferred records,

plus number of cells and formats)

Also You can get it in RSRT,RSRTQ...

WE07 IDoc statistics

DB20 Update DB Statistics

Regards,

Debjani........

Edited by: Debjani Mukherjee on Sep 25, 2008 2:42 PM