st04 and st02

[former_member829550]

hi all,

what excatly we check in ST04 and ST02.(Along with threshold values and minimum required values for the sap servers.)

ECC6.0, oracle, windows 2003server.

explaination and related will be links will be really appreciated.

regards,

bhupesh

[Former Member · Accepted solution]

This message was moderated.

[former_member829550]

thanks for your answers.

[Former Member]

Hi,

st02

Here you can check diffrent types of buffer fill percentage.

Normally the value in swap column has to be looked.

swap upto 1000 can be ok after that you have to look that for buttleneck.Here you can restart the application server to make the buffer empty because some times the buffer area get fragmented. if swap happens regularly for some buffers then think of changing the parameter.

Below you can check for roll area,paging area and extended memory and heap.Check for used percentage.if extended memory used % is >= to in memory then there is buttleneck for

same.Extend the value if physical memory is available.Make sure there is no heap memory used.

ST04

Data buffer

Size (kB)

Quality (%)

Size default pool (kB)

Here data buffer quality is most important the % sud be more than 90.unless increase the size.

Regards

Ashok

[Former Member]

Hello Ashok,

Thanks for info, can u please also provide more basic thumb rules of memory management...and also for database perofrmance.

thanks.

[Former Member]

Hello mudari bhupesh,

All information about memory management you can find in transaction ST02. This is a good place to verify if there are swaps in the buffers. You can also check the memory parameters set in the instance. On the other hand, ST04 provides all necessary information to analyze database problems. For example: Expensive SQL Statements. Other important information is the buffer quality, number of total logical reads, physical reads, user/recursive calls, etc...

Hope this helps!

Best regards,

Rafael Toshiaki