SAP System run slowly

[Former Member]

Dear all,

Our DB Instance always run very slowly and update process
responding time is very long during month end.
I think this maybe due to it runs the database and application.
So I want to delete the DB Instance from Logon Group, and then users
will just access other else three Dialog Instances, is it Ok or what
impact will have ?

How to check PI system connected to SAP ECC Logon Group's IP , but not only
connected to the DB Instance ?

Users always need run many Background Jobs at the day,but I heard other
company almost only allow users run Background Jobs at the night.
Generally, how many background jobs running on one Instance is normal?
Do we have any good ways to control or limit users' background job
setting at the day ?

The dialog and update process numbers of DB Instance are respectively 80 and 6(Update & Update2) , other Dialog Instance is 50:4(Batch:Update)

How is the general ratio between dialog and update process numbers ?

what's the difference between update and update2 process ?

Thanks,

Michael

[Former Member]

Hi Michael,
The difference between UPD and UP2 is simple,

UPD is time critical and primary update which has more priority.

UP2 is non- time critical which are dependent on UPD which deal with calculation updates.

Thanks,
Pavan

[divyanshu_srivastava3]

Do reorg, update stats, check your network setting, update you OS with latest supported patch, tune your buffer....etc etc.

There is so much you can do. Important is, that as a BASIS Admin, you have to recognize the area which are causing problems.

Monitor your system with standard transactions and check for fluctuations.

Divyanshu

[Former Member]

Hi Michael,

Your company basis team searching why SAP system run slowly.

But don't have your company basis team check your system transactions.

ST01 - Operating system monitor

ST02 - Tune Summary

ST04 - SQL Server performance analysis

SM21 - System Log

SM50 - Process Overview

SM13 - Update Requests.

SM12 - Lock Entries

Maybe long time background working process see u overview tcode SM50 and SM12 kill procees after system speed normaly.

Regards.

Cem ATES