Is anyone out there running DVT (Data Verification Programs) in V10 on Windows/SQL who migrated from UNIX/Oracle and can share your experience with performance/timing? We always completed this in a five hour downtime while on UNIX but we can't complete half the jobs in 7 hours in our new environment. Some examples below. We went live on V10 Feb 20th so it's still very new. DB server is a single quad core with 32Gb memory, App server has dual quad with 24 Gb memory with a cluster of 3 IBM App servers). We have all suites, RQC, EMSS, Fin, HR/PR, Materials and also use LBI, MSCM, LSO ~3000 users (130 backend core users) We have had reports of slowness in other areas as well. I would greatly appreciate any feedback.
PO420 V9 in Unix Dec 38 min, Jan 42 min
PO420 V10 in Windows April(prod): 1 hour 30 min , May(test): 1 hour 21 min (PURCHORDER records read: 0000000295401)
RQ420 V9 in Unix Dec 59 min, Jan: 1 hr 4 min
RQ420 V10 in Windows April (prod): 2 hours 3 min, May(test): 1 hr 59 min (Total Records Processed = 0000000316138)
