We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-basis] Bad performance between SQL and ABAP program

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Reply from Balaji_Guru on Feb 18 at 7:36 AM
What are the other factors like memory, CPU ,SWAPS configured..
Fine tune them to check if there could be a difference.

What is the DB hit ratio and the dialog transaction response time in general on the new server.
Please provide some more info on the SAP server release /DB information to suggest better.

---------------Original Message---------------
From: JOSJAN
Sent: Wednesday, February 11, 2015 12:24 PM
Subject: Bad performance between SQL and ABAP program

Hi,

We are testing a "fastest" hardware to put in production soon. To test the machine we use our quality server which is a clone of production server.

When we make the test, we have noticed that:
- When we access from Abap to the database the time of the "fastest" HW is worst.
- When we access to the DB from SQL (db02 transaction) the time of the "fastest" HW is better.
- By server, the times from Abap and SQL of our quality server are similar.
- But the times of our new server are 50% "fastest" from SQL comparing it with ABAP access.

The new server is an exact copy of our quality server and we have reviewed parameters database and system.

Do you know if there is an special parameter that I've to configure?

I need help please.

Thanks

 
Reply to this email to post your response.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2015 Ziff Davis, LLC. and message author.
Ziff Davis, LLC. 28 E 28th Street New York, NY 10016
Balaji_Guru  

IT/IS Professional/Admin/Staff
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language