Tcode RSRT

[Former Member]

Hello,

In BW production system I'm using tcode RSRT to scan the query for performance issues, using this transaction does anyone know what options to select to determine if it is an Extractor, OLAP, Excel, etc... that is causing the query performance to run slow?

Please advice, thanks for your assistance.

Regards,

Niki Nguyen

[Former Member · Accepted solution]

Give query name - > Hit Performance...You wud useful info there..u can check

1)if DB stats are updated or not....

2) if OLAP cache is used or not

3)Compression

4)IF aggregates are used or not

5) Indexes are fine or not

6)Partitions

You need to check BI stats for OLAP/DB time..or use T code ST03N in expert mode..

Let me knw if you need more help

Gaurav

• Assign pts if ie helps**

Message was edited by:

Gaurav

[Former Member · Accepted solution]

Hello Gaurav,

I don't see the Performance option, here are the options:

Default Breakpoints

Authorization Breakpoints

Cache Breakpoints

Aggs

BIA Server

Data Manager

Planning

Others

Input Help

What options do I select for query performance issues?

Please advice, thanks for your assistance.

Regards,

Niki Nguyen

[Former Member · Accepted solution]

Hi

Go to RSRT ..

below Execute button there is performance info button...

pls check and let me know..

Gaurav

[Former Member · Accepted solution]

Hi Niki,

For Query Performance analysis I would suggest you to use TCODE : ST03

Go to --> ST03 --> on left side top change from Administrator to Expert Mode --> now click of BW system of left side.

You will be able to find all performance aspects of Queries

Hope this helps,

Sudhakar

[Former Member · Accepted solution]

Hi Gaurav,

I'm trying to debug query performance issues via RSRT, what options should I select to debug it? Please advice.

Thanks,

Niki Nguyen

[Former Member · Accepted solution]

Hi Sudhakar,

I'm trying to debug query performance issue, please advice how using tcode ST03 can help to debug it?

Thanks,

Niki Nguyen

[Former Member · Accepted solution]

Using RSRT > Performance Info button > here is the system response,

Compression (ZCSCCOMP) 27 Requests Not Compressed

What does it means?

Please advice, thanks for your assistance.

Regards,

Niki Nguyen

[Former Member · Accepted solution]

Niki,

If you want to perform a targeted performance analysis (i.e. single query), RSRT can be used. You can also get a good idea by looking at the RSDDSTAT records, which keep the time and record count on different phases of a query.

Since DB access is an usual suspect I'd look there first. In RSRT, use the Execute + Debug option. Check the "Display Run Schedule" option. The query will stop before each select statement. You can step through it to see whether any select statement is producing the bottleneck. Gauray already included some good points to look into, but I'd try to narrow it down. For exampel, if you're reporting against a multiprovider you need to find out which data target is causing the performance problem.

[Former Member · Accepted solution]

Hello Rick,

Using RSRT > Performance Info butto > listed below are the result regarding to InfoProvider Compression, what does it means?

Compression (ZCSCCOMP) 28 Requests Not Compressed

Please advice, thanks for your assistance.

Regards,

Niki Nguyen

[edwin_harpino · Accepted solution]

hi Niki,

it means your infoprovider/infocube ZCSCCOMP has 28 requests not compressed,

compression will improve query performance

for compression take a look

http://help.sap.com/saphelp_nw70/helpdata/en/ca/aa6437e7a4080ee10000009b38f842/frameset.htm

for RSRT (Query monitor) detail

http://help.sap.com/saphelp_nw70/helpdata/en/1b/55d979fd5ca54d96fdb605f22b677e/frameset.htm

http://help.sap.com/saphelp_nw70/helpdata/en/a0/2a183d30805c59e10000000a114084/frameset.htm

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/2d589190-0201-0010-f19a-c74465ce...

hope this helps.

[Former Member]

Hello Edwin,

Using tcodes ST03 or ST03N > Frontend Statistics, what do I look for on the tabs (Times, Database, Roll information, Parts of response time, All data) to analyze the query performance issues (RSRT > Single query)?

Please advice, thanks for your assistance.

Regards,

Niki Nguyen