SAP Server getting slow when we are running reports like mc.1 fbl3n etc.

[Former Member]

Hello,

The time we are running transactions like mc.1 fbl3n, on sm04 the Megabyte column memory showing 578,233 like. that time other users are getting very slow while working.

What is the problem how I can rectify this problem.

please help me

regards

lal

[Former Member]

That is a large amount of memory for a standard transaction. You might want to check ST10 to see if the related tables are buffered (transaction tables should not be buffered). Also, check the technical settings for the tables in SE11 and make sure the size settings match the number or records.

Finally, check with your developers to see if they have made any changes to the index or append tables.

Hope that helps.

J. Haynes

Denver, CO

[Former Member]

Hello Haynes,

Thanks it was very help, i checked st02 and changed accordingly. Have lots of performance changes. how can I check how many record in a table?

Please help.

regards

lal

[tolulope_okusaga]

Hi kariyath,

If you know the name of the table, run TCod SE16.

You should be able to view the contents of the table.

Regards,

Tolulope

[Former Member]

In the DB13, make sure you have schedule the oracle optimizer stats. If not schedule to Run atleast once a week

login as orasid

brconnect -c -u / -f stats -t all

The SAP runs slow if the oracle stats are very old

[JPReyes]

Check ST03n for response time in the different areas. Also check ST02 for swaps in memory maybe you'll have to review you memory params.

Regards

Juan