Can anyone tell me how I can down the response time from my DB because just right now I have a response time around 6,500,
I hope you can help me...
Since now thanks
If DB response time is high, you have to check when it is reaching high value for e.g; when executing any specific transactions or report.. if yes enable sql trace n check what happens exactly with the help of ABAP consultant.
If it happens always, check whether db parameter settings are configured properly. Check the RAM and CPU utilisation as well. Check your early watch alert report n do the suggested changes in the system. Update ur db patches n do post steps n parameters settings.
Above should resolve the issue otherwise pls raise to SAP to check. Table or db compression won't help in performance tuning as data will be defragmented. if you do shrink or compression often and this will affect the performance.
Also check SAP memory parameters as well.
Sign up for STechies
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.