ST03

[p_m8]

We can use ST03 ->Workload to see the statistic/check the performance of the query. In order to use this, we must activate the Technical Content and load the data into it right?

If I donu2019t have the Technical Content activated, is there other way for me to see the statistic/check the query performance?

Please advice.

[p_m8]

thanks

[Former Member]

Hi,

Go the the transaction RSDDSTAT.

Check to see if your default setting values are X(on) and 2(All).

If not click to extras and change the defaults.

Then highlight the query name(s) you want click to "replace values".

Cheers

Tansu

[Vitaliy-R]

Then you need to read directly from RSDDSTAT* tables.

Regards,

-Vitaliy

[p_m8]

Vitaliy,

Thanks, but can I confirm that only if we have activated the Technical Business Content, then we can check is thru RSDDSTAT* table, which can be displayed via ST03 transaction?

OR

We can just display it directly via RSDDSTAT* tables.

Thanks.

[Vitaliy-R]

Hi.

Technical BI Statistics cubes and ST03N work only when content is activated. RSDDSTAT* tables are always populated, although level of data granularity depends on settings described by Tansu in previous post.

Regards,

-Vitaliy

[rajkumar_kandula]

For checking query performance you can make use of the Tcode RSRT.

[Former Member]

Hi,

Please check for some info here:

http://help.sap.com/saphelp_nw04/helpdata/en/ca/86df4254d81e1fe10000000a155106/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/2d/b8be3befaefc75e10000000a114084/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/25/ece73a39e74d27e10000000a114084/frameset.htm

http://help.sap.com/saphelp_47x200/helpdata/en/c4/3a735b505211d189550000e829fbbd/frameset.htm

http://help.sap.com/saphelp_47x200/helpdata/en/25/ece73a39e74d27e10000000a114084/frameset.htm

look at this -

/people/vikash.agrawal/blog/2006/04/17/query-performance-150-is-aggregates-the-way-out-for-me

Reg

Pra