Performance on Oracle 10g x64 and ECC5.0 (640 x64) on Windows 2003 R2 x64

[Former Member]

Hello all,

We have a serious problem with this landscape. SAP kernel updated to 155. Oracle updated with OPatch to patch 12 (latest) and the new database statistics were updated. It seems an IO degradation because the Average Disk Queue is very high. We tested the hardware and it performs very well compared to other solutions. In the mean time we talked to the support from SAP and they didn't find any problems on configuration of parameters and recomended to turn off AUTO_SPACE_ADVISOR_JOB in Oracle, but the performance is still low. Does anyone tested/implemented these versions together?

Best Regards,

Emanuel

[antonio_bossini · Accepted solution]

Hi Emanuel,

try run or re-run from DOS prompt :

brconnect -u / -c -f stats -t oradict_stats

brconnect -u / -c -f stats -t system_stats

using the latest BrTools 7 (Path level 24).

Good luck

Boss

[Former Member]

Hello,

Thank you for your feedback Antonio and Limig. Unfortunately I don't have access to this system anymore. The hardware was tested by vendors and was ok. I forgot to say that the developement system had the same problem so i intend to say that was a software problem: it's a very rare occasion where 3 brand new servers are faulty. Thank you again, but i can't keep you informed about this problem.

Best Regards,

Emanuel

[Former Member]

If no configuration problem is found even after getting SAP involved, I suggest you re-examine the hardware.

Poor I/O performance is often indication of I/O hardware problem. In the case on Windows platform, please check Windows event log. If you find ANY 'Event ID 9' or Event ID 11' errors, you can almost certain to conclude disk/disk-controller is defective. Please note that Windows does NOT alway write such message when I/O problem occurs.

I find that I/O problem is more common on Windows platform because Windows servers often have less hardware diagnostic features and less direct support from manufactures.