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

[Former Member]

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

[former_member182470]

Hi,

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

Regards,

Suman

[Former Member]

Hi Suman,

Thank you for the tip, but this is only high level information.

We require the finest level detail to be stored and accessed from tables.

Thank you.

Simon