on 2008 Oct 09 7:15 AM
Hi Everyone,
Anyone knows the tables used by ST02, ST04, ST06 and ST07 which similar to ST03N, I can get to query them directly for performance statistics?
( Debasis, any advice on this?)
Thank you.
Regards
Hwee Seong
Help others by sharing your knowledge.
AnswerRequest clarification before answering.
Hi,
the tables are:
ST02: MONI
ST04: MONI
ST06: OSMON (for last 30 days), MONI (for the hour values of the last 30 days)
ST07: MONI
ST03: MONI (until release 6x), SWNCMONI (since release 7x)
But you will not be able to extract the data directly from the MONI table as the values are stored in a long raw field. Each kind of data has its own structure and only the reports and function modules of the mentioned transactions will be able to read the data and convert it to the correct structure.
Exception: the workload data (st03) can be accessed as described in the [note 1053634|http://service.sap.com/sap/support/notes/1053634].
Regards, Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
An intermediated solution might be to setup the EWA in solman and transfer the data to BW.
You can add CPH data if you need specific things
There you have a bit more options.
What exactly are you looking for?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Hwee Seong
Program for ST02 : RSTUNE50
It uses the below tables:
TABLES: TUNEHD, "statistic about SAP buffers
TUNEHD64, "statistic about SAP buffers
DBSTATITEM, "statistic about buffered tables
SAPBUFQUAL, "SAP buffer qualities
RFCDES. "RFC destinations
I am also looking for the tables used for other statistical data.
If you got the information, could you please share with us.
Thank you.
Regards,
Anuj Nigam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Hwee Seong,
These tcodes reads the data as collected by the SAPOSCOL.
For more details about this, follow the link
http://help.sap.com/saphelp_nw70/helpdata/EN/c4/3a6bff505211d189550000e829fbbd/frameset.htm
Regards,
Debasis.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
ST06/OS06 - directly takes from SAPOSCOL. for this no data from MONI table. MONI stores the statistical data.
As you might be knowing..OS07 is similar to OS06, but its for global os monitoring.
I just checked for ST07.. it runs the report SAPMS07A. may be you can investigate a little more..
Regards,
Debasis.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.