on 01-14-2019 3:00 PM
Hi Team,
After SAP OS migration from windows (2012) to SUSE Linux (12.3) reports are taking longer time as compare with Old server (Windows). Database is Sybase.
Please let us know if any we need to check .
Thanks,
MM
As it is a ABAP system - use SAP Transaction DBACOCPIT as a starting poing for your analysis.
If generall response time is good - but certain jobs a re slow compared to before , then it is likely SQL tuning issue.
You said table stats have been updated - so that should not be the issue then.
Identify the most costly SQL statements in your sytem - investigate why these statements run slow .
Even if performance is generally bad for everything and inital analysis shows it is mainly DB response time that drives overall performance issues , then SQL query tuning is often one of the things to consider - fixing the 5 to 10 most expensive SQL frequently saves overall system performance.
HTH
Tilman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi MM,
Can you provide the outputs of the commands?
sp_monitorconfig 'all'
go
sp_helpthread
go
Best regards,
Jongun Seo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
A starting place would be to run sp_sysmon for the duration of the report on both systems and look for any major differences in the reports.
-bret
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.