how can i found which program consume more memory in server

[Former Member]

Dear Experts,

please do needful on below issue

in my servers one server is very slow i checked in all arear

but i didnot found any issues on my servers

now i have one doubt

is their any problem in abapers coading

so i need to check how much memory it will takes for sql statments

i dont know how can i get this requirment

so please tel me how can i check sql statments which they consuming more memory in my server

Regards

[Former Member]

Hi,

You can check st03 (db time should be less than 40% of response time).

check st04 - current sql query,

check sm66 - any tables reading for log time by particular process / user.- if its so,please check the index and storage quality of the table.

From EWA report - you can get exact program / query which is consuming more time.

according that you can do the analysis.

With Regards

CSK.

[Former Member]

Hi,

please do needful on below issue

For the same, I suppose ?

Use Transaction ST03, choose the period (day, week or month), select "Memory Use Statistics" and sort by "Average Total Memory Usage " or "Maximum Extended Memory Usage".

Check specially if some programs use Private Memory.

Regards,

Olivier

[Former Member]

Hi,

You can activate sql trace from transaction st05.

Regards,

Vishnu

[nirmal_konchada]

Hi,

In SM04 you can check the memory utilized by each user in his current working transaction.

Regards,

Nirmal.K