Skip to Content
author's profile photo Former Member
Former Member

Do Cache values from RSRT exist in tables, or can program be written?

Hello SDN Community,

The transaction RSRT, and then go to Cache Monitor, then either Memory or one of the other Cache pushbuttons.

This shows the creation of the caches, on a query by query basis.

For each query, they may have different query variable values.

so you may see many caches per query.

Now, is it possible to write a program to basically export these cache parameter variable values to a table.

RSDDSTAT indicates many information for the query run time etc... but not the variables for that query.

I imagine this information we are seeking is stored only dynamically.

I found this document

Understanding OLAP Processor.pdf

which shows the BREAK points for the query Technical information. I would envisage, creating a program that intercepts this area, and writes the cache parameters to a table.

We are looking to do this, because the customer has had much performance problems, and we want to do detailed statistical analysis.

Is there any way of capturing or retrieving this information.

Thank you.

Simon

Edited by: BW Basis Support on Aug 18, 2011 7:23 AM

Edited by: BW Basis Support on Aug 18, 2011 7:23 AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Aug 18, 2011 at 06:18 AM

    Hi,

    Navigate inside this t-code RSRCACHE. You may get some idea........

    Regards,

    Suman

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.