cancel
Showing results for 
Search instead for 
Did you mean: 

After OS migration reports are taking huge time as compare with old server

0 Kudos

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.

  1. SAP versions are same (SAP_APPL 617 SP11)
  2. JOB input also same.
  3. memory parameters are same as old system..
  4. executed table update statistics(indexing).
  5. we increased RAM from 16GB to 32GB
  6. SDI report only taking huge time, we checked with ABAPER for number of tables using by report. And we executed table update statistics(indexing) for entire database and also particular tables which are related to that report. But still report taking same time.

Please let us know if any we need to check .

Thanks,

MM

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

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

jong-un_seo
Participant
0 Kudos

Hi MM,

Can you provide the outputs of the commands?

sp_monitorconfig 'all'
go

sp_helpthread
go

Best regards,
Jongun Seo

former_member188958
Active Contributor
0 Kudos

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